Calc sucks the donkey dick if you do large spreadsheets. I must dual boot windows 10 to use excel.
I managed a business for a decade using some fairly complicated open office spreadsheets to track project labor cost. I provided these to my upstream contractors in open document format and never had a single complaint. At the time the biggest shortcoming, in my opinion, was the lack of conditional formatting. It has been added in later releases or not since I don't do that anymore.
I'm talking large datasets. 100000 lines sorting into a pivot table. Royal clusterfucluster fuck.
Curious. Did you export into xls or leave it up to your contractors to open the file with whatever the default ods format was?
Never worked with datasets that large. At most a couple of thousands rows spread over half a dozen tabs. Lots of embedded charting.
I saved it in native ODS and told them not to be confused that it wasn't an XLS. Excel had no problems that I ever knew about.
I did NOT try to produce an XLS for them nor use that XML-wrappered proprietary-blob shit Microsoft was peddling as their "open" format.
Maybe i just hit the sweet spot in use cases but I did not exceed it's abilities or have exchange problems.
Edit: I do not recall the versions involved on either side but this was the 2008 to 2012 time frame.
Why the fuck is anyone using a spreadsheet for that kind of data? That's what databases are for.
(post is archived)