Issue 107935

Summary: RTL-only cells should be displayed as RTL
Product: Calc Reporter: Dotan Cohen <>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.1.1   
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
test file created by MS Office user none

Description Dotan Cohen 2009-12-27 17:44:29 UTC
When a cell contains only RTL and neutral characters, the cell should always be
displayed as RTL.

Although I understand that a sheet can be configured as RTL and this issue is
then solved (actually the right way to do it), MS Excel will display a cell as
RTL if it contains only RTL and neutral characters, even if the sheet is LTR.
Therefore MS Excel users do not format their sheets as RTL, and these documents
look "wrong" in OOo. Therefore, there is argument to have this behaviour only in
.xls documents.
Comment 1 Dotan Cohen 2009-12-27 17:45:38 UTC
Created attachment 66838 [details]
test file created by MS Office user
Comment 2 haggai_e 2009-12-28 08:47:07 UTC
I'm sorry, but I can't seem to reproduce this bug on OpenOffice 3.1.1.
First of all, the attached file's sheet is opened RTL. Even when changing the
sheet's directionality, the cells directionality remains correct.

The only thing that looks wrong is the alignment of the cells, which is always
to the left, Instead of to the right. Is that what this bug is about?
Comment 3 Dotan Cohen 2010-01-01 13:37:20 UTC
The cells are not aligned left, they are LTR. The difference is that the
punctuation is on the right of the text, not the left.
Comment 4 Edwin Sharp 2013-08-26 08:12:38 UTC
text is left aligned.

Rev. 1516794 Win 7