Issue 114969 - When the sheet is RTL then the cells border settings are flipped
Summary: When the sheet is RTL then the cells border settings are flipped
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.2.1 RC2
Hardware: All Windows 7
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-10-06 19:13 UTC by yomach
Modified: 2013-08-14 08:59 UTC (History)
4 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description yomach 2010-10-06 19:13:07 UTC
How to reproduce:
1) create a new sheet
2) format, sheet, right to left
3) pick a cell (or a group of them), right click, format cells, borders.
4) Choose one side (for example left) & border it.
5) The border will appear on the wrong side (right).
Comment 1 netanel 2010-10-07 09:15:49 UTC
Reproduceable in OOO330m7.
note that is issue affects only the left and the right borders, but not the two
diagonal lines.
Comment 2 niklas.nebel 2010-10-07 09:57:57 UTC
Exchanging the left and right borders in RTL mode is necessary so a border
around a cell range remains around that cell range when a sheet is switched to
RTL. Perhaps we should then exchange them in the dialog, too.
Comment 3 yomach 2010-10-07 10:36:49 UTC
So the dialog needs to update as well.
If the sheet is in RTL mode then clicking on the right border should apply the
left border.

I feel that this solution is not elegant and might complicate things in the

Problem is that there are many RTL left to right problems...
for example:
Another solution which i think is better and will solve many RTL problems is
making the switch a "one time big action".
As far as i'm aware, currently the RTL is mainly cosmetic.
Everything is done exactly the same but is displayed "backwards".

I think that switching to RTL should rebuild the sheet completely, changing the
indexs of all of the cells being used.
It means that switching an existing sheet that has information into it in RTL
would take some time, but since in most cases people will either create an RTL
sheet or an LTR sheet and won't change it then i think it'll be much better.

Anyone has a better idea that doesn't require rewriting the RTL code?
Comment 4 kaplanlior 2010-10-07 10:39:43 UTC
This is very similar for #72804, except it's about tables in writer instead of
cells in calc.
Comment 5 Edwin Sharp 2013-08-14 08:59:18 UTC
As given in description.

Rev. 1507307 Win 7