Bug 136899 - Inconsistent/wrong shifting & wrapping when editing RTL cells or cells in RTL sheet
Summary: Inconsistent/wrong shifting & wrapping when editing RTL cells or cells in RTL...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: RTL-UI
  Show dependency treegraph
 
Reported: 2020-09-20 19:14 UTC by ori
Modified: 2023-02-16 13:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file (39.66 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-09-21 06:16 UTC, ori
Details
A reduced testcase with integrated explanation (21.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-02-13 10:28 UTC, Eyal Rozenberg
Details
A reduced testcase with integrated explanation (48.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-16 13:39 UTC, Eyal Rozenberg
Details
A reduced testcase with integrated explanation (51.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-16 13:40 UTC, Eyal Rozenberg
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ori 2020-09-20 19:14:08 UTC
Description:
When I try to fix a caption in Calc, the caption jumps to the right and does not start from the same rectangle I clicked. Or it goes down, instead of the same line that is written on it.
on that video: (Those bugs appear from the beginning of the video until 3:10)
https://youtu.be/1wxdP4XnbAg

Steps to Reproduce:
1. see on the video
2. same
3. same

Actual Results:
see video:

Expected Results:
see video:


Reproducible: Always


User Profile Reset: Yes



Additional Info:
see video:
Comment 1 BogdanB 2020-09-21 04:47:50 UTC
Ori, could you eliminate the confidential info from your file and upload here?...
In order to test on it.
Comment 2 ori 2020-09-21 06:07:40 UTC
(In reply to BogdanB from comment #1)
> Ori, could you eliminate the confidential info from your file and upload
> here?...
> In order to test on it.

i'm sorry but i'm not following. what file exactly?
Comment 3 BogdanB 2020-09-21 06:10:47 UTC
When you have created the video you have played on a file. That file could be useful to test your results. But if there are confidential data eliminate that data and let just the minimum of text.
Comment 4 ori 2020-09-21 06:16:34 UTC
Created attachment 165707 [details]
Test file
Comment 5 ori 2020-09-21 06:17:08 UTC
I uploaded the file like you asked
Comment 6 Eyal Rozenberg 2021-02-13 09:56:30 UTC
Confirmed. The choice of where to overflow text outside of a cell is inconsistent: When just viewing the spreadsheet, an RTL cell on an RTL sheet overflows to the left; but when editing, it overflows to the right.

If we're on the cell of the sheet, then overflowing to the right is not an option, and instead of properly overflowing to the left, the cell text will be wrapped ("overflow down", if you will). Also, it will be left-aligned within the edit box rather than right-aligned, which is inappropriate and confusing but is probably a different bug.
Comment 7 Eyal Rozenberg 2021-02-13 10:28:55 UTC
Created attachment 169711 [details]
A reduced testcase with integrated explanation

A reduced testcase. Just edit any of the cells with Hebrew text.

And note that there is nothing special about this document - this bug manifests ubiquitously whenever you enter RTL-language text in an RTL sheet, whose length exceeds the width of the column.
Comment 8 eladhen2 2021-02-15 15:32:08 UTC
Confirmed on 6.3.6.2
Comment 9 Eyal Rozenberg 2021-02-15 16:56:32 UTC
I should also mention that when these cells overflow "due down" (are displayed wrapped for editing) - the wrapping's alignment does not respect the cell being RTL, i.e. the wrapping is left-aligned even though the cell is not explicitly left-aligned. That's a secondary bug.
Comment 10 QA Administrators 2023-02-16 03:25:53 UTC Comment hidden (obsolete)
Comment 11 Eyal Rozenberg 2023-02-16 13:27:29 UTC
Comment on attachment 165707 [details]
Test file

Use the newer test document.
Comment 12 Eyal Rozenberg 2023-02-16 13:39:22 UTC
Created attachment 185405 [details]
A reduced testcase with integrated explanation

Edited the text in the reduced testcase and added a link back to this page.
Comment 13 Eyal Rozenberg 2023-02-16 13:40:42 UTC
Created attachment 185406 [details]
A reduced testcase with integrated explanation
Comment 14 Eyal Rozenberg 2023-02-16 13:41:16 UTC
Sorry for the spam :-)

Anyway, bug still manifests with:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ad387d5b984c6666906505d25685065f710ed55d
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: he-IL (en_IL); UI: en-US
Calc: threaded