Dialog option text needs to be changed for right to left spreadsheets, currently it could cause confusion as what it does (correctly) is actually opposite to what it says (but the option is mislabelled, the behaviour seems correct).
Steps to Reproduce:
1.Open/create a right to left spreadsheet (with some data in it)
2. Right click on a cell
3. Select "Insert..."
The second option on the dialog box says "Shift cells right".
For right to left spreadsheets, this should actually say "Shift cells left"
User Profile Reset: No
The functionality works correctly, shifting cells to the left - only the dialog text needs to be changed.
Shall we rename it to "Shift left/right" or make the text depending on RTL settings?
"Shift left/right" sounds like a confusing title. Better is to make it text direction dependent.
In Writer we use Left/Top, Right/Bottom for paragraph style > alignment depending on horizontal/vertical direction. The dynamic label might be not so easy to implement. How about "Shift forward" and backward for left/right?
(In reply to Heiko Tietze from comment #3)
> How about "Shift forward" and backward for left/right?
Sounds ok. Is forward to the right in LTR?
(In reply to Thomas Lendo from comment #4)
> (In reply to Heiko Tietze from comment #3)
> > How about "Shift forward" and backward for left/right?
> Sounds ok. Is forward to the right in LTR?
Would be my understanding but the drawback of not perfectly terms with forward/backward instead of left/right is clear.
The insert column commands are titled "before" and "after" and the insert rows commands are titled "above" and "below".
If used in RTL cells, the behavior also is false like the text in the 'Insert...' dialog. If something will be changed here also the 'Delete...' dialog and the above mentioned column/row commands must be taken into account.
I doubt this is technically possible? What with only partially RTL columns/rows? How could LibreOffice decide if it's LTR, RTL, whatever?
But to come to this bug report: As columns and rows commands were renamed, also the 'Delete...' and 'Insert...' dialog must be changed:
* Insert... > Shift cells right ----> Shift cells after
* Delete... > Shift cells left ----> Shift cells before
This isn't what the bug opener wants but it would be at least the same naming than in other commands.
"Shift before"... I wouldn't understand this command. So let's not make compromises.
I'm pretty sure we can evaluate LTR/RTL and update the command label and the various captions accordingly.