On Tue, May 20, 2014 at 2:45 PM, Martin Manns <mma...@gmx.net> wrote: >> I am so fed up with LibreOffice's inability to properly support really >> basic Excel capabilities, I'm about ready to throw my computer out the > > Could you please give some examples, what basic Excel capabilities you > are missing?
That's the problem. It's not that it's obviously missing some features. It's that the files it writes sometimes are misinterpreted by xlrd. (Maybe the problem is xlrd, but it never has a problem with actual Excel-generated XLS files.) For example, I use a formula to generate a sequence of strings in one column: "F0", "G0", "H0", ..., "Z0", "F1", "G1", ... continuing for as long as I have data in an adjoining column. If I add or delete rows, this sequence grows and shrinks. It looks fine in the spreadsheet. I rarely, if ever, change the number of rows, so the values in this column rarely, if ever, change. Still, sometimes when xlrd reads the values out of that column it finds all cells in that column contain the number 0. If I mess around with the spreadsheet in ways which are apparently unrelated to this column, I can sometimes get it to read right, sort of like hitting a jukebox to stop a record from skipping. I haven't tried changing the output format to XLSX format (isn't that a compressed XML document?), but maybe I should give that a whirl. I don't know if xlrd will read such files (at first blush, it appears not). Also, Mac isn't my primary platform. This problem occurs using the Linux version of LibreOffice as well. Sometimes I edit this spreadsheet from home though. Before I upgraded to OS X Mavericks, I still had an ancient version of Excel for Mac which worked fine (despite all the disparaging remarks I've seen over the years about that product). Once I upgraded though, that was no longer an option. Thanks for the gnumeric and pyspread suggestions. I thought gnumeric was a long dead project, but see that it's available for my Mac, so I'll try that right off. I'll also play around with pyspread and see how that does. I don't mind rewriting my couple of formulas, though I will no longer be able to rely on the Excel experts at work. :-) Skip -- https://mail.python.org/mailman/listinfo/python-list