Open spreadsheet (XLS format) with Hebrew text

Discuss the spreadsheet application

Open spreadsheet (XLS format) with Hebrew text

Postby Motim » Sat May 08, 2021 4:24 pm

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
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing Calc Spreadsheet

Postby Villeroy » Sat May 08, 2021 5:11 pm

What you open is propably not a Calc spreadsheet. What do you download?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30116
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Importing Calc Spreadsheet

Postby Motim » Sat May 08, 2021 6:35 pm

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
Attachments
Part of Spreadsheet.jpg
Some columns deleted, some items retouched. This is a part of .xls spreadsheet
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing Calc Spreadsheet

Postby Villeroy » Sat May 08, 2021 7:38 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30116
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Importing Calc Spreadsheet

Postby Motim » Sat May 08, 2021 8:13 pm

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
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing Calc Spreadsheet

Postby Villeroy » Sat May 08, 2021 8:22 pm

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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30116
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Importing Calc Spreadsheet

Postby Motim » Sat May 08, 2021 9:42 pm

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
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing Calc Spreadsheet

Postby Villeroy » Sat May 08, 2021 11:27 pm

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?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30116
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Importing spreadsheet (XLS format) with Hebrew text

Postby Motim » Mon May 10, 2021 11:42 am

Hello,
Just curious.
The info I sent on the 8 May, did you find it ? interesting ? something will be fixed ?
Motim
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing spreadsheet (XLS format) with Hebrew text

Postby Villeroy » Mon May 10, 2021 1:00 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30116
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Importing spreadsheet (XLS format) with Hebrew text

Postby Motim » Mon May 10, 2021 3:04 pm

Hello and thanks for the detailed answer.
Motim
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing spreadsheet (XLS format) with Hebrew text

Postby Motim » Wed May 12, 2021 11:01 am

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
OpenOffice version 4.1.10
OS = Windows 10 pro (US-English), version 19041.928 x64
Motim
 
Posts: 7
Joined: Sat May 08, 2021 4:08 pm

Re: Importing spreadsheet (XLS format) with Hebrew text

Postby Hagar Delest » Wed May 12, 2021 3:33 pm

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.
LibreOffice 7.0.5 on Xubuntu 21.04 and 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29902
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Importing spreadsheet (XLS format) with Hebrew text

Postby Villeroy » Wed May 12, 2021 4:40 pm

Status changed to "Resolved, Fixed". Will be in 7.1.4.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30116
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests