Created attachment 143882 [details]
right click menu screen shot
On Right-To-Left sheet
When you tring to insert new column by right click -> Insert columns left - its insert to right.
And when you click on -> Insert columns right - its adding to left.
The insert left/right commands are not found in the oldest versions.
Arch Linux 64-bit
Build ID: 1c59d021b3dd27c8c0255312bd0d53ad25965bab
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5;
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on September 1st 2018
This is not quite a "bug", more like a faulty assumption in the choice of words. Actually, what LO implements is "Insert Column Before" and "Insert Column After" - and in LTR sheets, To the Left = Before and To the Right = After.
Now, one of two things should happen: Either the feature be altered to actually insert to the left / to the right, or the text be altered according to what the feature does.
Also, it's the exact same issues with Tables in LO Writer - if they're Right-to-Left-directed.
I'm in favor of altering the text to say After/Before, because it sounds better alongside Above/Below.
Heiko: you just did a similar change for Writer table row inserts, so throwing this to your lap.
We changed the before/after thing in Writer to left/right recently. And the icons are pointing towards left and right, so I think the better approach is to switch left/right in case of RTL. The patch is here https://gerrit.libreoffice.org/#/c/60022/, review pending.
The patch was not good so we changed now the captions to Before/After (accordingly at Writer too).
heiko tietze committed a patch related to this issue.
It has been pushed to "master":
tdf#119036 - Inserting columns into RTL sheets will add them to the wrong side
It will be available in 6.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.