Ask Your Question

When I receive an excel file with arabic letters, some of them are displayed in square garbage character. Is there any other alternative? [closed]

asked 2015-03-23 09:53:17 +0100

Fayaz gravatar image

updated 2020-08-17 22:49:31 +0100

Alex Kemp gravatar image

An excel files is created in MS Office Excel that contains both English and Arabic character is saved in .xls format and sent to users with LibreOffice 4.4.1. When users open the .xls file in scalc, some of the Arabic character appear unreadable and in square boxes. If the cell with 'square boxes" are selected and changed from "Italic" to "Non-Italic", then the Arabic letters appear. Does this mean every time users gets this spreadshuet, they have to change the text from Italic to Non-Italic?

Users PC configuration;

Windows XP and Windows 7 Pro LibreOffice 4.4.1

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-17 22:50:22.230966

1 Answer

Sort by » oldest newest most voted

answered 2015-03-23 11:52:28 +0100

Lupp gravatar image

updated 2015-03-23 12:16:28 +0100

This should be the issue reported as bug FDO#87532. I cannot confirm that it only applies to the fonts 'Arial' and 'Times New Roman' for which it is reported there.

As my test is showing the problem will also occur in documents not imported from alien files. 'Insert' > 'Special Character...' > (some Arabic letters) > change font style to 'Italic' will produce it in most cases. Many additional fonts (if not most) are afflicted.

As I don't know anything about writing in Arabic (except that it is running from right to left ... and always 'Italic' in a sense) I cannot say if the 'Italic' style has any meaning for it and if fonts (which ones?) contain an 'Italic' variant or if the 'Italic' style should be faked or ignored by the running software ...

As the handling of fonts is the same for all of LibreOffice the problem will also show in Writer documents.

My best idea: Negociate with your partners to not use 'Italic' in Arabic writing.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-03-23 09:53:17 +0100

Seen: 6,919 times

Last updated: Mar 23 '15