Issue 55175

Summary: Default text alignment should follow sheet language direction
Product: Calc Reporter: eyalzvi <eyal>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOO 2.0 Beta2Keywords: BIDI
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 114236    

Description eyalzvi 2005-09-28 11:53:16 UTC
In Calc it is now possible to use Right To Left (RTL) oriented sheets. This is
used by people who use RTL languages, and naturally most of their text is in
their (RTL) language.

However currently calc interprets the "default horizontal alignment" of text
cells always to be Left To Right. This means that RTL users need to force right
alignment for every text cell in their sheets.

The correct behavior should be that "default horizontal alignment" for text
cells will depend on the orientation of the sheet Left for LTR, Right for RTL.
Comment 1 frank 2005-10-13 13:11:25 UTC
Not a defect but an RFE. Re-assigned to requirements
Comment 2 eyalzvi 2006-08-04 11:07:27 UTC
I'm sorry but this is a DEFECT (of course you may call any request to fix bug a
requirement, but this is still a bug).

When a sheet is RTL, default text alignment must be to the right. Text that is
aligned to the left is confusing, is truncated at the right cell border (which
means the beginning of the text isn't shown), and causes havoc in files imported
from MS Excel.

In short, the current behavior produces INCORRECT results - therefore it is a BUG.

If that is not enought, it also goes against users' natural expectations, and it
differs from the (correct) behavior of the most popular application in the market.
Comment 3 frank 2006-08-04 12:08:23 UTC

as it has never worked, this is an enhancement and has to go it's way as such.
You may feel that this is a defect, but from the developers view it's not. This
system is mainly for developers to track the work to be done, so the developers
point of view is the one which counts, at least in this case.

Comment 4 eyalzvi 2006-09-02 10:51:39 UTC
>> as it has never worked, this is an enhancement

Huh? If something has been defective since the beginning, then it's not a bug
but an enhancement request?


Suppose that importing tables from Word has always produced broken tables in
Writer, how would you call a request to fix it - defect report or enhacement

And how would you call a scenario where tables (sheets) imported from Excel are
broken in Calc? This is exactly the problem here - Calc assumes a WRONG
alignment for RTL sheets, so both imported and new sheets are BROKEN.

Just to drive the point home - I want to switch my office to OpenOffice, but
people just refuse to use Calc. They are frustrated when they import Excel
sheets and get scrambled results, and they are annoyed to be forced to fix
alignment manually, both for imported and new sheets. 

Call it an enhancement if you like, it's still a defect from both user and
developer perspective. I won't change the issue type, I'll leave that to you.

PS -
I understand perfectly well how developers work and think - I've been a
developer for 25 years or so, and I still am in the business. When something
produces a wrong result, especially when compared to a similar program which
produces the correct result, then it is a defect.
Comment 5 eyalzvi 2008-05-07 22:37:52 UTC
Is anyone following this?
Any chance this annoying problem will be fixed in version 3.0 ?
Comment 6 Martin Hollmichel 2011-01-24 13:57:41 UTC
as long as no assignee has been found for this issue, the target cannot be set to 
a release target, re set it to OOo Later again.