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
Problem with that is you're chasing the lowest common denominator. Windows will at some point bite you.
I ditched OS/2 Warp for Linux in 1997 (had my fill with WfW and saw the coming new wave for the shite that it was). Only Windows I kept around was in a VM to run Quicken, and that I kicked to the curb when they switched to a subscription model.
If you HAVE to have MS Orifice a VM sharing a folder in your home dir is workable. But I strongly suggest testing Libre Office to see just how much you can live with it. Leaving Windows feels really good.
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)