Calc file ... first save is slow ... then fast
bump ... anyone?
I wonder if someone can explain this ....
I have created a Calc file with over 2000 rows and about 10 columns. Conditional formatting is applied and the cell formulas use iterations.
When I open the file and fill out a row and save the file ... LO 'freezes' for a short while saying "not responding". After literally a few seconds LO comes back to live again. Now when I fill out the next row (or multiple rows) and save the file, the saving process is fast (like it should be).
Does anyone know why 'the first save' is so slow and results in LO "not responding" for a short while? Is it loading data into memory or something like that? AND ... the one million dollar question ... is there a way to improve this behavior?
I just found out something strange.
When I open the file and IMMEDIATELY save it, it will save fast. Then when I fill out a row and save the file again, it still is fast!
So the problem only occurs when I open the file ... fill out a row and then save the file. Then LO is not responding and it litterally takes a couple of seconds before the file is saved.
What could be the problem?