GNOME Bugzilla – Bug 525323
Pasting of dates between workbooks using different date convensions changes dates
Last modified: 2008-04-09 11:42:34 UTC
Please describe the problem: in linux, all .xls format: when cut and pasting data from one spreadsheet file into another file that originated on a mac, three years and one day is added to each date. Steps to reproduce: 1. create a mac.xls file in excel for mac 2. move the mac.xls file to linux 3. in linux, open mac.xls file in gnumeric 4. import data (with dates) from an xls file (that originated on linux) into the mac.xls file. Actual results: three years and a day should be added to each of the dates on the mac.xls file. 01/01/2007 becomes 01/02/2010 Expected results: Does this happen every time? in my case, yes. Other information: please email me if you need the files to reproduce this problem. lawtonpaul@yahoo.com
It would be helpful if you could attach a sample mac file to this bug report. I am guessing that the file could actually be empty.
Never mind, I see the problem. The source workbook uses a 1904-based calendar; the target uses a 1900-based calendar. The pasting is not, in general, going to work as we cannot always identify dates. What we can do is something like this: 1. Detect the situation. (We already do include the date conventions in the xml we send.) 2. Pop up a warning dialog. The situation should be rare enough that it will not be too irritating. 3. Offer to do our best conversion effort.
*** This bug has been marked as a duplicate of 490419 ***