Page 1 of 1

[Issue] Open spreadsheet (XLS format) with Hebrew text

PostPosted: Sat May 08, 2021 4:24 pm
by Motim
Hello,
New to this forum, new OpenOffice user.
Hello again.
When I try to open a calc spreadsheet (mainly downloaded) which has Hebrew text inside, it appears as giberish. So first I open it with Microsoft Office (Excel), save it as ".xls" file, then open it in the program and the text is Hebrew.
Later I can edit, add, whatever in Hebrew and it works.
Note: OS system basically is US-English, Hebrew language added.
How to make it work ?
Answers will be appreciated
Thanks
Motim

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 5:11 pm
by Villeroy
What you open is propably not a Calc spreadsheet. What do you download?

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 6:35 pm
by Motim
Hello,
Thanks for some answer.
The file is a Calc Spreadsheet, yes. Attached a screenshot of part of it.
You can see the giberish insted of Hebrew.
Motim

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 7:38 pm
by Villeroy
Nobody can tell without having the actual file at hand. Possibly you want to replace OpenOffice with LibreOffice which handles foreign file formats much better. https://www.libreoffice.org/discover/li ... penoffice/

The one and only application which will ever be able to handle all pitfalls of xls is Excel and nothing but Excel. This is intentional and no other software can be fully compatible with anything that does not want to be compatible.

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 8:13 pm
by Motim
Hello,
Thanks.
I am trying "LibreOffice", but it has a bug in calc spread-sheet since version 7.
The bug is resizing columns when page is in right to left format, the body of the column is resized and the column's heading is not resized with the column.
In left to right format, the resize columns is OK.
Its a pity, as I started to like the "OpenOffice".
Motim

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 8:22 pm
by Villeroy
Apart from the column resize error, does LibreOffice interprete the content of the xls correctly?

Do you know the issue number of the column resize problem? I can't find this issue in the bug tracker system.
Wiki page of current and past right-to-left related issues: https://wiki.documentfoundation.org/RTL_Bugs

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 9:42 pm
by Motim
Hello,
Thanks.
Answer 1: Yes.
Answer 2: Started a post "https://ask.libreoffice.org/en/question/292082/libreoffice-710/", then posted a bug report on the site mentioned there.
My bug report was deleted as a duplicate, see 139241 in the bug list which was posted by someone else (not me), but still its the same issue.
Motim

Re: Importing Calc Spreadsheet

PostPosted: Sat May 08, 2021 11:27 pm
by Villeroy
So which bug is more serious? The one with the misaligned headers (until screen repaint) or a program which fails completely to interprete the file content?

Re: Importing spreadsheet (XLS format) with Hebrew text

PostPosted: Mon May 10, 2021 11:42 am
by Motim
Hello,
Just curious.
The info I sent on the 8 May, did you find it ? interesting ? something will be fixed ?
Motim

Re: Importing spreadsheet (XLS format) with Hebrew text

PostPosted: Mon May 10, 2021 1:00 pm
by Villeroy
The LibreOffice bug will be fixed as soon as somebody takes the time do work on it. Since you posted a duplicate, you will be notified by email when the status of the original bug is changing. There is some activity on the Right-to-Left issues and this particular bug has been introduced between versions 6 and 7. It was overlooked when fixing/improving something else. I think, the project could benefit from volunteers being able to test release candidates in non-Latin languages.

There are bad chances that the OpenOffice bug will ever be fixed because of a serious lack of developers.

Re: Importing spreadsheet (XLS format) with Hebrew text

PostPosted: Mon May 10, 2021 3:04 pm
by Motim
Hello and thanks for the detailed answer.
Motim

Re: Importing spreadsheet (XLS format) with Hebrew text

PostPosted: Wed May 12, 2021 11:01 am
by Motim
Hello,
This is just for your info.
After a long time which the problem about resizing columns in "LibreOffice Calc spreadsheet" was asleep (after all, my post about the problem was marked as duplicate). I started to get about 5 to 6 e-mails from "Bugs.DocumentFoundation.org".
I wonder what was the trigger for that.
However, there is a new version 7.1.3, downloaded and installed it to test - the problem still there.
Motim

Re: Importing spreadsheet (XLS format) with Hebrew text

PostPosted: Wed May 12, 2021 3:33 pm
by Hagar Delest
Have you checked the bug report?
Usually adding a comment (even merely marking a report as duplicate) tells that other users are impacted and that the issue may be worth tackling.
Perhaps bumping the report has made some devs have a look and raised some interest.

Re: Importing spreadsheet (XLS format) with Hebrew text

PostPosted: Wed May 12, 2021 4:40 pm
by Villeroy
Status changed to "Resolved, Fixed". Will be in 7.1.4.