Issue 55178

Summary: Force Left To Right direction while editing formulas
Product: Calc Reporter: eyalzvi <eyal>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO 2.0 Beta2Keywords: BIDI
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 114236    

Description eyalzvi 2005-09-28 12:16:07 UTC
Calc supports input of text in Right To Left (RTL) languages. However input of
formulas when the input mode is RTL, the formula is displayed incorrectly and
confuses the user.


The display of RTL text requires re-ordering the visual layout of characters.
There is a BiDi algorithm which determines the correct order, depending on the
characters in the string. The logic is a bit complicated and this is not the
place to go into all the details.

When the user inputs normal text in RTL language, it is displayed correctly and
logically by the cell editor. However, when in RTL input mode, formulas are
displayed incorrectly.

Formulas always begin with an equal sign (=), and contain Latin functions names,
cell references, parentheses and commas. This causes the BiDi algorithm to
display the formula in a completely messed order. It is virtually impossible to
edit formulas in RTL edit mode.

The correct behavior should be to always display and edit formulas in LTR mode,
regardless of the direction of the sheet and regardless of the input mode.

Actually, the editor line (above the sheet and below the toolbar) works exactly
like that, and the in-cell editor should be the same. Of course the user should
be able to switch input direction during editing, but the major direction of the
input string should be forced to LTR.

For those who may wonder how "other" spreadsheet programs work - "they" work as
I suggest.
Comment 1 frank 2005-10-13 13:14:06 UTC
one for the requirements team
Comment 2 ace_dent 2008-05-16 01:42:03 UTC 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:
or consider trying the new OOo 3 BETA (still in testing):
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:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 Martin Hollmichel 2011-01-24 13:55:41 UTC
as long as no assignee for this issue has been found the issue can't be set to a 
specific release target, set again to office later.