Calculation (crtl+shift+f9) takes 1.5 hours and I want to reduce this time.
Windows 10 home / Core I3 / 8g ram
Libreoffice 126.96.36.199 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.