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(?).