Bug 161604

Summary:	Calc unwrap setting selection sometimes wraps the content and refuses to stay unwrapped
Product:	LibreOffice	Reporter:	John <creamin>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEEDINFO ---
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	24.2.1.2 release
Hardware:	Other
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Declined.ods has 6 sheets of financial data and text

Description John 2024-06-16 19:47:05 UTC

Description:
I have a old Calc file updated monthly with 1000s of rows of personal data. About a year ago I had this problem with this file.
This week I received a .xlsx file from a server. Adding text to it was not saved for reasons unknown, so I copied its content as text and numbers only into a Calc file. All cells were unwrapped, and remain unwrapped in the original file.

I added several comments in red text a few days ago and discussed them days later.

Today, after I entered some text into sheet "Damage Covered" at l79 it entered as wrapped text. It unwraps when requested and immediately reverts to wrapped.

This action seems to have triggered an existing unwrapped cell that has been stable on several occasions of opening and closing this file to wrap itself, sheet "Damage Declined", D58.

So this attached file has the same issue on two separate sheets. I did not touch the latter sheet: a cell within it wrapped itself.

This issue started with an Intel MacBook Pro over a year ago. I am now using a M2 MacBook Air with macOS Sonoma 14.5 (23F79)

When it happens, it then happens every time. Saving can trigger this too.

I tried to reproduce it using an empty cell, but I could not reproduce this.

I tried to reproduce this in the original revised file, but I could not reproduce this.

Files affected n this way never recover. Several cells have spontaneously wrapped themselves in my personal files that cannot be un-wrapped.

Steps to Reproduce:
1.enter a long string of characters into a cell that is not set to wrap.
2.if it wraps, try unwrapping it
3. if it does not wrap itself, then wrapping and unwrapping does not reproduce this

Actual Results:
FORMATTING error

Expected Results:
Settings to behave as expected

Reproducible: Sometimes

User Profile Reset: No

Additional Info:

User data is empty except for two pre-ticked boxes. I think this is my user profile as I cannot find anything with that title to reset. I do not have a help button in my menu bar or menu drop-down lists as instructed, nor do I know how to restart LibreOffice in safe mode.

Comment 1 John 2024-06-16 19:49:56 UTC

Created attachment 194765 [details]
Declined.ods has 6 sheets of financial data and text

Comment 2 m_a_riosv 2024-06-16 21:10:05 UTC

I'm not able to reproduce
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
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

Could it be in relation with 'Expand formatting' Calc option.
https://help.libreoffice.org/24.2/en-US/text/shared/optionen/01060300.html?System=WIN&DbPAR=CALC&HID=modules/scalc/ui/scgeneralpage/ScGeneralPage#:~:text=Expand%20formatting,attributes%20of%20the

Comment 3 ady 2024-06-16 23:13:36 UTC

My bet (not really tested) is that the reason is the same as other issues with either wrap text or multi line text within a cell. Similar issues are reported with LO 24.2, whether in ODS files or when importing/exporting from/to XLS and/or XLSX.

Examples: Bugs 159690, 160900, 161453. There are possibly others (and there will be more).

Comment 4 ady 2024-06-16 23:25:30 UTC

BTW, based on tdf#159938, the issue should be _partially_ solved with LO 24.2.2.

Comment 5 John 2024-06-17 10:44:11 UTC

Thank you Ady. My reaction;
Bugs 159690:
Adding a manual line break, then press "Enter" key, forces a not needed automatic wrap text. Lesson: avoid line breaks for now until this is resolved.

Bugs 160900, 161453 The first seems unrelated, the second maybe related.

In my latest case that I submitted, I did not have a line break. With my other calc files saved as .ods or .xls I often do have line breaks. Issue remains.

Comment 6 ady 2024-06-17 14:28:56 UTC

Whether you see a line break or not is not what relates those other reports to your case, but rather the imposed Wrap Text property of the relevant cells.

I would suggest making a copy of at least one of the files in which you see the problem, and installing the latest stable LO 24.2 version (instead of using the older LO 24.2.1). Then open the file with that new version and correct the cells (i.e. remove the Wrap Text property of the relevant cells). Save the file and reload it. Is the file saved correctly? Are the cells "unwrapped"?

Please report back.