Apache OpenOffice (AOO) Bugzilla – Issue 37449
Have a prefrence for default cell directionality
Last modified: 2013-08-07 15:00:01 UTC
When setting a Hebrew locale, Writer by default starts all documents as RTL (which is good), and Calc starts all sheets as RTL. However, all the cells in the sheet are set as RTL, and the setting is kept even when the sheet direction is changed to LTR. This is very annoying when working with lots of numeral content (which is always LTR)- even if the user wants the sheet itself to be RTL, most of the content of the sheet is still LTR (this can be seen very clearly in Hebrew excel files loaded to the web- most of them have RTL sheets, where most of the content is LTR). At the moment, the user has two not-so-good options: * Leave the locale setting in OOo as Hebrew (to benefit from RTL pages in writer and other niceties), but for each and every sheet for every file, click once to select all cells, and click another time to change them all to LTR (regardless if the user want the general sheet direction to be LTR or RTL- changing sheet direction does not change the direction of the cell, which *is* the correct action). This really adds up over time. * Don't use a RTL locale, and then loose default RTL pages in Writer, default RTL sheets in calc and other small issue. IMO, we should either default cell direction to LTR (as most content is numeral, which is always LTR), or give the user the option of choosing default cell direction.
reassign open l10n issue to new default owner.
Reassigned
FT: Re-assigned to requirement default user
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 2+ years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
The default text direction in version 3.0.0 is still RTL, which causes problems for formulas (see Issue 77928). Also, the default alignment is left, which is inappropriate for both Hebrew text and numbers. Since most data that Hebrew users will enter is either formulas, Hebrew text, or numbers, the current situation seems to contain the worst of all worlds.
Any news about this request?