which things / settings affect the performance of calc

edit

of course plenty!

i'm not qualified to provide a full list,

just one spot not commonly known that almost threw me off my track, and how to avoid it:

• using plenty of comments (sometimes called 'notes', 'sticky-notes', 'post-it's', 'captions' or similar), or 'track-change notes' which have similar handling, can pull down calc to unusable.

it's happening wih various impact in various versions of calc and various OS's, best yet seen version: 6.2.7.1 win(x64).

performance issues: impressive unneeded system load on mousemoves, delayed reaction - up to 10 seconds to wait - on mouseclicks to change the focussed cell, long times to load and save, large memory footprint, doubled to tripled impact after the first save, 'save as', autosave or even 'save a copy' of the file, that reduced after a 'close-load-cycle',

to avoid:

estimate the size your document may grow to, estimate the count of comments and change-tracking-notes that may come up while use, double both values, create a sheet with that many filled cells, and check whether it's response times are tolerable for your work. if not try another version, if 6.2.7.1 doesn't suffice choose another platform :-(

up from 5,000 comments be quite careful.

note which values are working, and keep an eye on them and check the file from time to time ... with 'Navigator' you can check the amount of comments already in use, if you experience delays and suspect them resulting from comments make a copy of your sheet, remove all comments, and check whether it improves performance ...

if other users provide other points i'll make a list of no-no's.

reg.

.b.