Autosave is disabled and yet LibreOffice Calc locks up autosaving so the software is unusable

Autosave is disabled and yet LibreOffice Calc locks up autosaving so the software is unusable. By the time is finished one autosave it starts to the next. I just want it to stop and let me work. I have checked under tools->options and I see this

My document is open from an NVMe drive and my system drive is an SSD so it should not take so long to save anyway.

Any suggestions or anything I can turn off to make the software usable will be gratefully received. BTW of course I am working with a rather large dataset.

NIck

Please test with a clean profile, Menu/Help/Restart in Safe Mode

That definitely helped. BTW I am using v7.3 apparently. Not sure if that is latest. Will go and check after this.

In the status bar when it was getting stuck it was saying Save Document even though I hadn’t asked it to and had autosave turned off as you can see above. If I can help with more information please let me know.

Do I need to uninstall and reinstall to keep it working now or always start it in safe mode?

Keeps the clean profile and restart in normal mode.

One point to remember: Re-install does NOT change your profile! So any error in the profile will be there again to greet you like groundhog-day, after your install.
.
Safe mode ignores the existing profile, so you can see, if a new profile would help.
.
I usually suggest to rename the old profile, in case you need something stored there. Mostly dictionaries with your own additons and macros, but depending on your setup there may be more…
.
If you have a complete backup of your system you could restore from there, but Windows-Users often have no clue where %APPDATA% is, or why they should save it…

I just exited Calc and shift deleted my profile as I don’t care about my settings. I just want to get some work done. It makes no difference.

I open a spreadsheet with lots of columns (100+) and rows (150k+) of data in it.

I open a text file in calc and copy and paste that data over the data in the spreadsheet.

Libreoffice recalculates the other sheets.

I press Save and the progress bar gets maybe a 5th of the way through before it freezes and shortly after crashes.

This is the same before and after my deletion of the profile. Calc is using approx 16GB of RAM out of my 128GB RAM. It is attempting to save to an NVMe drive that has 379GB of free space.

I am running version 7.5.

I have to say, for the interest of anyone reading this that I would gladly pay several hundred dollars for an industrial strength spreadsheet capable of handling datasets like the one I describe above. There must surely be a market for a robust multi-threaded spreadsheet that doesn’t have all the bells and whistles but allows people to view and manipulate large datasets.

Right now I am wondering if I can write something that allows me to do the relatively simple operations I need to run but on massive datasets.

Having said that, I am writing this hoping to get an answer to this issue. My history is I have wasted many many hours over the years trying to work with MS Excel and I am coming to Libreoffice hoping for something better.

This office suite comes with a database component. Spreadsheets are rubbish.

Don’t know, if you can, but you should read up on Pandas/NumPy first. On the other side I would follow @Villeroy and put the actual data in a database (and skip the chapter embedded databases) and give Calc only the results of a query, if you can put your relatively simple operationsbin SQL.

PS: Read the printed edition of this book some years ago:

Thanks for all your suggestions and information. I write an app in C++ and so I am just going to slurp the file into that (which is where the data was going eventually anyway) and do the manipulation there. I should have done this a while ago.

I am really grateful to all the people who give their time to developing Libre Office and will continue to use it and submit bug reports when I find anything.

All the best,

Nick