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.
Im thinking of having 2 computers with a shared volume
Why the fuck is anyone using a spreadsheet for that kind of data? That's what databases are for.
True, and a lot of my reports turn into scripted programs.
Its when you're in the cutting edge. Being the first to data mine it.
(post is archived)