Apache OpenOffice (AOO) Bugzilla – Issue 114969
When the sheet is RTL then the cells border settings are flipped
Last modified: 2013-08-14 08:59:18 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).
Reproduceable in OOO330m7. note that is issue affects only the left and the right borders, but not the two diagonal lines.
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.
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 future... Problem is that there are many RTL left to right problems... for example: http://www.openoffice.org/issues/show_bug.cgi?id=106245 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?
This is very similar for #72804, except it's about tables in writer instead of cells in calc.
As given in description. Rev. 1507307 Win 7