After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 129398 - date export to csv is broken (or strange)
date export to csv is broken (or strange)
Status: RESOLVED DUPLICATE of bug 128936
Product: Gnumeric
Classification: Applications
Component: import/export Text
unspecified
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2003-12-15 20:01 UTC by David Mansfield
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: 2.3/2.4


Description David Mansfield 2003-12-15 20:01:27 UTC 
Using gnumeric 1.2.1 with Fedora Core 1, if I create a new spreadsheet with
a single cell, format the cell as DATE, 'M/D/YY', enter a date then 'Save
As' text CSV, it exports the date '2/7/04' as 38024.  If this is correct,
it certainly violates the principal of least surprise.  At any rate, I
cannot see how this can be correct.
Comment 1 David Mansfield 2003-12-15 20:12:27 UTC 
after a little more research I should add the following:

The 'random' number exported is apparently the excel specific internal
code for a date: number of days since the last day of the year 1899
(with a leap year bug).

However, exporting this as CSV makes any subsequent import USELESS,
since the 'date'ness of the field is lost, and it becomes just a number.

Excel exports dates as MM/DD/YYYY (regardless of the date cell format
apparently), thus this is a compatibility BUG.
Comment 2 Morten Welinder 2003-12-15 20:19:32 UTC 

*** This bug has been marked as a duplicate of 128936 ***