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.
(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(?).
Reproduced in version 24.8.0.0.beta1 Version: 24.8.0.0.beta1 (X86_64) / LibreOffice Community Build ID: 318462181c709ed29c01eb3239b4d600d7b82ecc CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
If I may... It might be probably worth for someone from the QA Team to try to contact Paris Oplopoios on its collabora email address (paris.oplopoios), or contact someone else from collabora, since there has been no reply here from Paris' gmail address. Alternatively, someone else would need to step-in, in order to solve the multiple reported regressions. Some related regressions were already solved in other reports. Wrap Text is a frequently-used cell format, and usage of manual line-breaks is not uncommon, so more reports should probably be expected (in addition to those already mentioned in comment 7).
Still reproduced in 24.8.0.3 (Released version) Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
(In reply to jun meguro from comment #10) > Still reproduced in 24.8.0.3 (Released version) > > Version: 24.8.0.3 (X86_64) / LibreOffice Community > Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 > CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: > Skia/Vulkan; VCL: win > Locale: ja-JP (ja_JP); UI: ja-JP > Calc: threaded Please, do not change the version. It the oldest version affected, not the newer one.
Still reproduced in 24.8.2.1 (Released version) Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
I have confirmed that the issue has been resolved in the following nightly build. I would like to thank everyone who contributed. Version: 24.8.3.0.0+ (X86_64) / LibreOffice Community Build ID: c6a2014aeb60fa14f9ff3bebccd358f2a55ce0be CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: CL threaded
I have confirmed that the issue has also been resolved in the following nightly version (24.2 series). Version: 24.2.7.0.0+ (X86_64) / LibreOffice Community Build ID: aaef1bc01476c6a7250bd749fb1422ef2d886a5f CPU threads: 8; OS: Linux 6.8; 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 #13) > I have confirmed that the issue has been resolved in the following nightly > build. Thanks, closing.
This seems to be a dupe of tdf#161453. I have not tested (bisected) whether the patch for tdf#161453 is exactly what solved this tdf#160900.