4 ms·
Excel is also extremely robust. You can, for example, do VLOOKUP between tables that are ~10K columns by 100K rows. And it just does it. And pauses/restarts cal
by mirimir 9y ago
Excel is also extremely robust. You can, for example, do VLOOKUP between tables that are ~10K columns by 100K rows. And it just does it. And pauses/restarts calculating, if you need to tweak something. But Calc? It just freezes, and eventually dies, and then must rebuild the file after restart. Which may end up being impossible. Indeed, Excel will do pivot tables that choke MySQL :) And it uses multiple processors.
- SubiculumCode 9y agoI do a lot of work in calc but there is a definite problem with large files..and they aren't solved by adjusting thr included memory options.
- mirimir 9y agoYeah. I've tried messing with those too. No luck. Calc seems to crap out at about 10 MB. Anything over 5 MB is prone to freezing. Especially if you use AutoFilter. The first time I encountered the file-repair prompt, it was total déjà vu to the DOS era ;)
- SubiculumCode 9y agoYes Autofilter kills performance even moderate sized files.