Bug 161494 - Calc unresponsive after sorting data and saving
Summary: Calc unresponsive after sorting data and saving
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-10 13:59 UTC by chuck0754
Modified: 2024-06-25 16:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
spreadsheet saved as .xls (8.00 KB, application/vnd.ms-excel)
2024-06-12 12:12 UTC, chuck0754
Details

Note You need to log in before you can comment on or make changes to this bug.
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.