"Save Document" Hangs the Whole OS

[yalec]

Calc Version: 24.8.4.2
Operating System: OpenSUSE Tumbleweed

I am currently working on a math admission task and my reasearch requires working with a large database of random integers.

I am using =randbetween.nv() and copy pasting 32 whole columns of random integers as unformatted text to take some load off my laptop. This method, however, does not cut it.

Obviously, the software and hardware is guaranteed to be strained during the saving process, but on numerous occasions, it has completely hung my system, sometimes absolutely destroying LibreOffice Calc and the spreadsheet itself.

Is there any other way to optimize this? Am I to reconfigure my LibreOffice Calc install? Thanks in advance.

[fpy]

@yalec

optimize

would need to get some more precise idea of your hardware, and how “large” is your “database”, and what you actually intend to do with it.

@yalec

copy pasting

definitely not the way to go.

[yalec]

The database used to be 32 million =randbetween.nv values, but I managed to solve my problem by splitting the workload into 3 speadsheets, so I’m good now.