News for hackers. Stuff that matters.

A comment on Coda, a “next-generation spreadsheet” – from rows and columns to custom apps. Parent comment

Re:Coda, a “next-generation spreadsheet” – from rows and col... by mirimir on Tuesday October 24, 2017 @09:56PM (#15546785)
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.
[ Parent | on HN ]
Re:Coda, a “next-generation spreadsheet” – from rows and col... by SubiculumCode on Wednesday October 25, 2017 @12:28AM (#15547464)
I 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.
[ Parent | on HN ]
Re:Coda, a “next-generation spreadsheet” – from rows and col... by mirimir on Wednesday October 25, 2017 @12:59AM (#15547603)
Yeah. 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 ;)

[ Parent | on HN ]
Re:Coda, a “next-generation spreadsheet” – from rows and col... by SubiculumCode on Wednesday October 25, 2017 @01:20AM (#15547699)
Yes Autofilter kills performance even moderate sized files.
[ Parent | on HN ]