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 113845 - date format for pre-1900 dates
date format for pre-1900 dates
Status: RESOLVED DUPLICATE of bug 509720
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Low enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2003-05-27 16:41 UTC by Daniel Zappala
Modified: 2008-04-11 23:11 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Daniel Zappala 2003-05-27 16:41:29 UTC 
Gnumeric does not properly format dates that occur before 1900.

Enter a date such as 3/20/1900 -- Gnumeric recognizes this as a date and
formats it properly.  Enter 3/20/1899 and Gnumeric represents this as a
text string.  Changing the format to date -- either before or after
entering the date -- has no effect on pre-1900 dates.

I removed my default Redhat RPMs that were outdated and upgraded to
gal-0.24, guile-1.6.4, and gnumeric-1.0.13.  The bug is still present in
this version.
Comment 1 Jody Goldberg 2003-05-27 17:37:48 UTC 
Its not so much a bug as a design limitation of MS excel.  Dates are
stored as 'days since jan 1 1900'.  It may be feasible to work around
it  with negatives, but definitely not in 1.0.x.
Comment 2 Morten Welinder 2008-04-11 23:11:38 UTC 
Substantial work on this bug has occurred over in bug 509720.


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