In a spreadsheet, add multiple lines, save it as XLSX (or save the attached ODS as XLSX), and reopen it. => No line breaks in cell. Observed in LO 24.2.0.0.alpha0+ (c60a9db1f2a8e2a088c6b89bcdff4901b28f2864) / Linux. It's a regression from the commit below. Since the same XLSX opens differently before or after this commit, it looks like the bug is on import side. Adding CC: to Paris Oplopoios. https://cgit.freedesktop.org/libreoffice/core/commit/?id=16d43b7c5396d6382926d514dc9ce10b3ce94cba author Paris Oplopoios <paris.oplopoios@collabora.com> 2023-08-28 20:40:33 +0300 committer Paris Oplopoios <parisoplop@gmail.com> 2023-08-28 22:12:43 +0200 Shared string shouldn't account preserve space property
Created attachment 190886 [details] Sample ODS
Created attachment 190891 [details] Screenshot For me the line breaks remain, and they are showed in the input line, but not in the cell. And cells saved with other versions opens fine. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5fe2bf914c251009ec4709fa8fdc45c3b53f676b CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
(In reply to m.a.riosv from comment #2) > And cells saved with other versions opens fine. Good point, thanks! I looked further, and there's a second (or rather, first) part of this regression. If the XLSX was saved in a version before the below commit, then opening in a build after the commit in the description doesn't exhibit the bug, only if it was saved in a build after this commit (the changes seem related): https://cgit.freedesktop.org/libreoffice/core/commit/?id=1760ee4d328cfb6ba22a5b3c84016625b12adb25 author Paris Oplopoios <paris.oplopoios@collabora.com> 2023-08-23 12:31:15 +0300 committer Paris Oplopoios <parisoplop@gmail.com> 2023-08-28 10:27:37 +0200 sc: Fix wrapText not being applied correctly on export
offtkp committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/17e362e56f9e15d0214c441e632c91d22e58519d tdf#158252 sc: Enable text wrapping when inputting line breaks in cell It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Please try after the patch I just pushed.
Possibly the change in commit 17e362e56f9e15d0214c441e632c91d22e58519d could be replaced by a code specific to export. That would fix bug 159690, too.
Ah - commit 1760ee4d328cfb6ba22a5b3c84016625b12adb25 explicitly dropped this from the export.