Download it now!
Bug 119036 - Inserting columns into Right-To-Left sheets will add them to the wrong side
Summary: Inserting columns into Right-To-Left sheets will add them to the wrong side
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium minor
Assignee: Heiko Tietze
Whiteboard: target:6.2.0
Depends on:
Blocks: RTL-CTL
  Show dependency treegraph
Reported: 2018-08-01 12:13 UTC by Levi Natan
Modified: 2018-09-06 13:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

right click menu screen shot (23.23 KB, image/png)
2018-08-01 12:13 UTC, Levi Natan

Note You need to log in before you can comment on or make changes to this bug.
Description Levi Natan 2018-08-01 12:13:01 UTC
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.
Comment 1 Buovjaga 2018-09-01 15:34:55 UTC

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
Comment 2 Eyal Rozenberg 2018-09-01 16:35:39 UTC
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.
Comment 3 Eyal Rozenberg 2018-09-01 16:39:27 UTC
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.
Comment 4 Buovjaga 2018-09-01 16:55:10 UTC
Heiko: you just did a similar change for Writer table row inserts, so throwing this to your lap.
Comment 5 Heiko Tietze 2018-09-05 09:46:21 UTC
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, review pending.
Comment 6 Heiko Tietze 2018-09-06 09:42:53 UTC
The patch was not good so we changed now the captions to Before/After (accordingly at Writer too).
Comment 7 Commit Notification 2018-09-06 13:32:44 UTC
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 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.