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: 2025-02-16 03:10 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
Comment 15 QA Administrators 2025-02-16 03:10:17 UTC
Dear ori,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug