Bug 161494

Summary:	Calc unresponsive after sorting data and saving
Product:	LibreOffice	Reporter:	chuck0754
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	miguelangelrv, stephane.guillou
Priority:	medium
Version:	24.2.3.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	spreadsheet saved as .xls

Description chuck0754 2024-06-10 13:59:35 UTC

Description:
the app becomes unresponsive when I sort a spreadsheet in calc and then try to save it.  I have to manually close.  The lock file for my spreadsheet and a temp file are left behind. Saving a spreadsheet after doing any other kind of update works without a problem.  I am running windows 11 home ver. 22H2. In safe mode, I get the same result.

Steps to Reproduce:
1.open spreadsheet
2.sort
3.save

Actual Results:
software becomes unresponsive, file is not saved and lock file and temp file are left behind I have to manually close the app


Expected Results:
file is saved and I can continue on


Reproducible: Always


User Profile Reset: No

Additional Info:
I have tested this with several spreadsheets and get the same results each time.

Comment 1 m_a_riosv 2024-06-10 22:32:30 UTC

Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

Comment 2 chuck0754 2024-06-12 12:12:35 UTC

Created attachment 194680 [details]
spreadsheet saved as .xls

This is a sample of the type of file that is causing a problem.  While creating this file I discovered that this problem happens when the file type is Excel 97-2003 (*.xls).  There is no problem with file type Excel 2007-365 (*.xlsx).

Comment 3 m_a_riosv 2024-06-12 22:21:30 UTC

I can't 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

What are the steps on how do you sort?

Comment 4 chuck0754 2024-06-13 10:35:26 UTC

I am using an inexpensive laptop that I recently purchased.  It is a Lenovo Ideapad 1I running Windows 11 home.  It was in s mode. I couldn't turn off s mode by following any of the instructions from microsoft. I had to disable secure boot in the bios.

As for the problem, I didn't do anything unusual.   

1.open spreadsheet in calc
2. sort the file on a chosen column
3. save the file

At that point I see the spinning circle and nothing happens. The software becomes unresponsive and I have to close it manually. The file itself is unchanged and the .~lock.(file name).xls# file is left behind.

Comment 5 Stéphane Guillou (stragu) 2024-06-25 16:21:59 UTC

Not reproduced with:

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded

Please update to version 24.2.4 and test again.
If it still happens:
- Does it only happen with the XLS format? What about saving as ODS or XLSX?
- Please paste here the version info copied with the button in Help > About LibreOffice.

Thank you

Comment 6 chuck0754 2024-06-25 16:45:31 UTC

Updated to v24.2.4.2 and problem is resolved.