(no subject)

[tamaranth]

I have created the same simple 9-cell spreadsheet in Excel, OpenOffice and Google. (Basically, it tested what happened in date and numeric formats if I typed "07/04/1701", "04/07/1701", "31/12/1899" and "01/01/1900".)

I have saved / exported each spreadsheet to each of the other formats (except that Excel is too snobbish to export to OpenOffice).

I conclude that, individually, they each have problems. (Excel doesn't believe in pre-1900; Google doesn't believe in Europe; OpenOffice thinks that everyone will like it if it tries really really hard.)

But put any two together, and @#$£%!WTF chaos ensues.

Have sent OpenOffice-saved-as-Excel file to collaborator. If we want it online, I suspect I shall have to type out the calculated values by hand.

And it's true: there was No New Year's Eve in 1899. Unless, y'know, you were running OpenOffice.

Comments

[geekmama.livejournal.com]

Haven't used google's new spreadsheet program, but was assuming one could just import from Excel. Sounds like... not so much. Good luck with that. That was an interesting article under the 1899 link, and set me to surfing Wikipedia where somehow I ended up with John Calvin. Time to close that window. *G*