Issue 59485 - Columns need to be RTL if locale is set to hebrew
Summary: Columns need to be RTL if locale is set to hebrew
Status: REOPENED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 2.0
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-12-17 23:47 UTC by bensch256
Modified: 2013-02-07 22:35 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description bensch256 2005-12-17 23:47:11 UTC 
The canvas needs to display the columns from right to left if the locale is set
to Hebrew, Arabic or Syriac. ie, cell A1 is displayed in the top-right corner
instead of the top-left. This is an extremely serious issue for users of OO in
RTL languages because of formatting of speadsheets coming from excel. 

Example:
They have their speadsheets set up to use columns A->E,F,G... but being
displayed RTL instead of LTR. When opened in OO calc, the columns showup as LTR.

Suggested fix:
When the locale is set to hebrew, Arabic or another RTL language, display
columns as RTL, hopefully the navigation system will not have to be reversed.

Cheers,
Ben
Comment 1 lars 2005-12-18 12:06:30 UTC 
according to 
http://qa.openoffice.org/issue_handling/workflowcharts/RFE_issues_by_QA.sxd I 
reassign this issue to requirements and set the status to new
Comment 2 lohmaier 2005-12-19 22:36:20 UTC 
This is an independent setting. Use the context-menu of the table-sheet's label
(the one next to the horizontal scrollbar) and set the table to right-to-left mode.

Worksforme.
Comment 3 lohmaier 2005-12-19 22:40:14 UTC 
closing issue. Feature already present and working.

Make sure you enable support for CTL in Tools|Options → Language settings,
otherwise you won't be offered the option to make the table right-to-left.
Comment 4 bensch256 2006-01-14 14:02:42 UTC 
Thanks for the worksforme.

However, from a usability point of view, if the locale is set to Hebrew, Arabic,
or Syriac, it's logical that the table default to right-to-left. Just because
the user can set the table RTL manually doesn't mean that they should have to if
their locale is a RTL language.

Cheers,
Ben
Comment 5 Rainer Bielefeld 2006-10-01 08:01:43 UTC 
DUP of  Issue 57433?