Bug 160495

Summary:	FILESAVE, FORMATTING
Product:	LibreOffice	Reporter:	s.unger
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	normal
Priority:	medium
Version:	24.2.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	no line brake after reopening an xls or xlsx file testfile with line break over problem in combined cells

Description s.unger 2024-04-02 21:46:02 UTC

Created attachment 193449 [details]
no line brake after reopening an xls or xlsx file

I found an almmost idential post of the issue from Jan '15 here:
https://ask.libreoffice.org/t/calc-text-carriage-return-disappears-upon-re-open/11384

I too, have combined cells that have “text” cell-formatting.
There is an auto carriage return for the text, depending on cell size. This used to work for like a decade, but lately, When I save this document in the latest two LO versions as .xlsx or .xls, and then close then reopen the file, all the carriage returns disappear. There's no problem as long as one keeps the file open.

It saves and reopens with formatting OK in .odf, however this document is being worked on by other users running Excel on Mac and Win so going that route is no option. 

The last version I know of, not rendering this problem is 7.6.4.

Comment 1 ady 2024-04-02 23:19:52 UTC

Please attach a _minimal_ sample xls(x) file that shows the problem. Please consider that it will be publicly available.

Comment 2 s.unger 2024-04-08 14:00:00 UTC

Created attachment 193566 [details]
testfile with line break over problem in combined cells

Hello, please find a testfile with the line break over problem enclosed. Please have a look at the combined cells in the 'print range' marked area.
If the the format is corrected by using the line break over button all seems fine. But once the file is saved and opened again with the latest LE version 24.2.2 (and 24.2.1) the line breakovers are gone again.
If an older file is opened all the line breakovers are missing too. One can correct that by touching up all cells, but the changes are lost on reopening too.
I reverted back to 7.6.4.1 for now as I need the software for daily work. Hence this version is not having that issue I can not test this behaviour currently. 


Best regards