I have a big spredsheet of about 8.7 MB with the extension .ods, and when i try to open it, is very slow, it takes about 10 minutes and multiple clicks on the wait button. The graphic memory limit is of 300 000 000. How much is it in MB? Will it be faster if i increase the value? If not, what can i do?
LibreOffice 26.2.4.2 620(Build:2)
MB is for Megabyte, so 1024*1024 Bytes, so 1,048,576 Bytes.
My Calculator gives approx. 286 MB for your setting.
This tells (nearly) nothing, because .ods-files are (like .xlsx) compressed zip-files. The size can be a result of some very big pictures with not compressible contents. Or it can be thousands of rows.
Years ago I tested limits of Calc on my Core i7-laptop and could handle around 10,000 rows without problem at edit/filter and some formulas. But other formulas like doing SUMPRODUCT. over complete columns were quite unusable.
So the size of the .ods-file is not the point, where you can see, if a file will give trouble.
IMHO large scale data should be handled in a database. My sqlite-database handles 150000 lines on the same computer with ridicoulous speed, if I compare this to Calc.
@Wanderer
My file has 20 sheets, but only a few are big, the biggest has about 3000 rows and 368 columns, and another with 552 columns, all the others are smaller. And about 11 charts and a lot of conditional formatting.
Now, entering a “1” in a cell takes at least 30 sec, saving the document takes multiple minutes.
Is there a problem if i increase the memory up to 1 GB? My PC has 4.
If i want to switch to a database, which one do you recommend? My problem with switching is that i might loose all the capabilities of calc. My main interest is not in storing the information, but in analyzing it.
Read somewhere that Excel has Power Query, which is very fast. Is it possible to introduce it in Calc?
No, you can’t put parts out of excel and use it elsewhere (unless you have the source-code).
As I can simple drag the result of a sql-query to a Calc-Sheet I’d say I don’t loose anything. The database stores the data. I use an additional layer of SQL to retrieve only the necessary data in my sheet and can analyze from there. Calc even remembers, the data came from the database and you can refresh the contents of the range by function refresh from menu data.