Bug 160860 - SAVING spreadsheets taking too LONG - FILESAVE
Summary: SAVING spreadsheets taking too LONG - FILESAVE
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-29 18:20 UTC by info
Modified: 2024-06-26 20:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description info 2024-04-29 18:20:21 UTC
Description:
When selecting SAVE icon or MEUN--> SAVE in a spreadsheet--in this case approx. 900 rows and about 20 cols, I get a spinning pinwheel lasting 7-15 seconds.

Also noting memory problems persisting after SAVE

Steps to Reproduce:
1.Use a decent size spreadsheet
2. click save or Menu save
3.

Actual Results:
I get a spinning pinwheel lasting 7-15 seconds.

Also noting memory problems persisting after SAVE

Expected Results:
instantaneous save with no pinwheels or save delays.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
This is a CRITICAL bug and needs immediate attention as it impacts performance and system resources and not released.

Systems parameters:

Using Libreoffice for MAC silicon v. 24.2 in Apple Mac M3 w. 32g RAM running latest MAC OS Sonoma 14.5.

This issue has existed in prior libre versions (including the official libreoffice version) and noticed as well in prior MAC OS versions.

Lastly, the Libre profile safe mode resetting was done and it did NOT fix this situation.
Comment 1 Stéphane Guillou (stragu) 2024-05-15 03:40:39 UTC
Thank you for the report.
Sounds similar to bug 160286.
Could you please test version 24.2.3, as it includes some macOS memory bug fixes?
Thank you!
Comment 2 info 2024-06-26 16:12:46 UTC
I am using 24.2.4.2 and still the issue exists.  

It appears to be driven by whenever a spreadsheet has conditional formatting or code in place in rows that the spinning wheel occurs on saving.  

The wait time is significant and should never be the case on my M3 32g Macbook Pro.
Comment 3 info 2024-06-26 16:16:06 UTC
Same issue as orginal ticket below and issue persists in newest release 24.2.4.2

This should be raised to MAJOR issue however, I am not allowed to make that change in this ticket.

Much Thanks.
Comment 4 Stéphane Guillou (stragu) 2024-06-26 16:57:57 UTC
(version changed back to original one, as the field is for "earliest affected" version)
(status set to "unconfirmed" as "reopened" is for specific cases: only for when a report was previously set as "fixed")

Thanks for testing again.
- What do you mean by "code in place in rows"?
- Are you able to attach a sample document, so others can test in the same conditions?

Thank you.
Comment 5 ady 2024-06-26 17:47:32 UTC
Considering patches already committed to the Dev builds for tdf#161461 and for tdf#159175, I would suggest following (for example) tdf#159175 comment19 (especially the "xattr" command).

At any rate, please report back here in tdf#160860 (not in the other tickets).
Comment 6 ady 2024-06-26 20:59:21 UTC
(In reply to ady from comment #5)
> At any rate, please report back here in tdf#160860 (not in the other
> tickets).

Was that text I am quoting too difficult to understand?

The patches in the aforementioned reports will be available in the next LO 24.2.5 and also in the next 24.8 and 25.5 branches. This is also mentioned in the links I posted before – just needs a minor simple reading (of only one comment).

Please either report here in tdf#160860 your tests with the Dev versions, or wait for those versions to be released.

At any rate, there is no way to know whether the new versions will effectively solve the reported problem, unless it is tested and reported back here.