Google Docs'n'Spreadsheets Problem

[tamaranth]

I'm having a problem with date conversion in a spreadsheet that was created in OpenOffice, saved as Excel format and then uploaded to Google Docs&Spreadsheets, for the purpose of collaboration.

As you will see from the screenprint under the cut, the dates in it are all quite a long time ago.

In Google Docs&Spreadsheets, they are showing up as 3 days later than the dates that were entered. E.g. 10th April 1701 instead of 7th April 1701.

When the spreadsheet is saved as Excel and the columns are formatted as Date, the correct dates show up.

I'm scanning their help system and trying to join the support group -- but if anyone can help / suggest anything that would be great.



Click on image to see those dates in detail ...

Comments

[dougs.livejournal.com]

My suspicion is that the two systems are making different provision for leap days in 1900, 1800 and 1700 -- see, for example, the description of the way Excel handles dates on this page (http://en.wikipedia.org/wiki/Epoch_(reference_date)#Trivia).

[autopope.livejournal.com]

Practical query: is the original OpenOffice spreadsheet available? Because Google Docs and Spreadsheets should be able to read it, I hope? (I know Google docs can cope with OASIS OpenDoc files so I'm assuming their spreadsheet app can do likewise ...)