Summary: | Inconsistency in Retaining Automatic Line Break Setting in LibreOffice Calc (xlsx Format) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | jun meguro <jmaguro> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | buzea.bogdan, parisoplop, raal, stephane.guillou |
Priority: | medium | Keywords: | bibisected, bisected, filter:xls, filter:xlsx, regression |
Version: | 24.2.2.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | Paris Oplopoios | |
Bug Depends on: | |||
Bug Blocks: | 87740 | ||
Attachments: | sample_of_wrap_problem |
(In reply to jun meguro from comment #0) > 3,Open the format dialog for cell A5 and enable automatic line break. Do you mean "Format Cells > Alignment > Wrap text automatically"? Or maybe you meant "Justify alignment"? Or some other setting? Please clarify the exact step/setting you are referring to. I apologize for the unclear description.
The issue occurs with the formatting set through the following menu path you provided:
>>Do you mean "Format Cells > Alignment > Wrap text automatically"?
(In reply to jun meguro from comment #2) > The issue occurs with the formatting set through the following menu path you > provided: > > >> "Format Cells > Alignment > Wrap text automatically" I can reproduce this problem in LO 24.2.0, but not in a recent LO Dev 24.8 alpha. Would you please test with LO 24.2.3 and report back? I was able to reproduce it in version 24.2.4. Version: 24.2.4.0.0+ (X86_64) / LibreOffice Community Build ID: ee9f7d31348e917eb8ba5b007a6679e01ecdb37f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: CL threaded (In reply to jun meguro from comment #4) > I was able to reproduce it in version 24.2.4. Repro when exporting to XLSX and XLS. I also reproduce in 24.8 alpha now. Not repro in LO 7.6.5 > Regression. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7a895ec4205659038aa95941b65715fed1a3e7be CPU threads: 4; OS: Windows 10 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded This seems to have begun at the below commit in bibisect repository/OS linux-64-24.2. Adding Cc: to Paris Oplopoios ; Could you possibly take a look at this one? Thanks 0fd3d8fa5041781bea37aeda264bda71a66c6152 is the first bad commit commit 0fd3d8fa5041781bea37aeda264bda71a66c6152 Author: Jenkins Build User <tdf@pollux.tdf> Date: Mon Aug 28 10:38:53 2023 +0200 source 1760ee4d328cfb6ba22a5b3c84016625b12adb25 155970: sc: Fix wrapText not being applied correctly on export | https://gerrit.libreoffice.org/c/core/+/155970 So we have yet another regression related to the same patch, either directly or as a consequence of another closely-related commit: tdf#159690, its dupe tdf#159351, tdf#159938, and maybe others, with focused on either manual line breaks within cells or on wrap text. No signs from the original developer in these(?). |
Created attachment 193934 [details] sample_of_wrap_problem In cells containing text created by formulas in an xlsx format file, the formatting for automatic line breaks is not retained. 1,Open LibreOffice Calc. 2,Open a sample document. 3,Open the format dialog for cell A5 and enable automatic line break. 4,Save the file (in xlsx format). 5,Close the file. 6,Reopen the file. Expected behavior: The automatic line break setting for the cell should be retained. Actual behavior: The automatic line break setting for the cell is not retained. This behavior occurred in LibreOffice 24.0.0 and 24.2.2. However, it did not occur in LibreOffice 7.6.4.