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 322392 - Autofilter drop down list displays unformatted dates
Autofilter drop down list displays unformatted dates
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Sheet Objects
unspecified
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-11-25 02:53 UTC by Robert Brennan
Modified: 2005-11-28 18:49 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Robert Brennan 2005-11-25 02:53:47 UTC 
Version details: 2.6.1rc-1
Distribution/Version: Windows 2000 sr4

When you create an autofilter on a worksheet, and one of the columns contains 
formatted date fields (eg. mm/dd/yy), the dates in the autofilter drop down 
list are shown as unformatted dates (eg. 38032, 38033, etc.). The drop down 
list should show the dates in the same format as displayed in the column being 
autofiltered to enable easy selection.
Comment 1 Morten Welinder 2005-11-28 16:51:58 UTC 
Confirmed.

I wonder what we would want to do if a list contained both 38032 and
whatever value that corresponds to.  Show both?  I am assuming that
we would not want to do that for now.
Comment 2 Morten Welinder 2005-11-28 18:49:15 UTC 
fixed in cvs.