Hello
Calculation (crtl+shift+f9) takes 1.5 hours and I want to reduce this time.
My circumstance:
Windows 10 home / Core I3 / 8g ram
Libreoffice 6.2.4.2 x64 calc with 2 sheets of 8000 lines each
Functions like IF COUNTIF SUMIF VLOOKUP are mostly used
-
I tried 6.4.x.x and 6.4.7.x and 7.x.x.x.
When I tried 6.4.x.x, calculation was done quite faster but many cells are broken like n/a or other errors and it looks like it stopped during calculation. -
7.x.x.x even never got open properly.
-
Removing vlookups didnt help.
-
Of course I dont use auto calculations. I cannot because of too long time.