![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Entry tags:
(no subject)
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.
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 @#$£%!
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.