So I have a Calc document that takes 5-10 minutes to save. I think the long save time is due to the file being over the network and there being a lot of formulas. Regardless, when the file is saving I can’t do anything with any libreoffice module so I can’t work in another spreadsheet or base while Calc is saving. This wouldn’t be a problem if it didn’t autosave in the middle of working.
I came across this post: Autosave is disabled and yet LibreOffice Calc locks up autosaving so the software is unusable, but there was no solution. I’ve deleted my user profile as was suggested and still had the file autosave. I’ve turned on the autosave check box and tried changing the values then turning the check box back off to see if it changed anything; it didn’t.
Here is the order of operations I do every time:
- Open the file from the network location
- Select yes to refresh database ranges
- Go to Data>Calculate>AutoCalculate and turn it on to update formulas
Once all this is done, sometime in the next few minutes the file will then autosave and seems to autosave periodically, though I have not timed it to see if it is consistent or related to an action I perform.
Any suggestions on things to try? Is this a bug?
I have one extension installed which goes online and grabs data.
Here is the version info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4
Calc: threaded
Thanks,
Paul