GNOME Bugzilla – Bug 67202
Function DATE does strange things with cell-format when dragged
Last modified: 2004-12-22 21:47:04 UTC
Synopsis: Function DATE does strange things with cell-format when dragged
date(1900;1;1) in A1 gives 1/1/00
drag(autofill) A1 down to A2 gives 1
looking at the celformat, it changed from date-d/m/yy
One would expect the cell-format not to change when dragging to
Copying or just dragging to a different place leaves the cell-format
------- Bug moved to this database by email@example.com 2001-12-18 20:20 -------
The original reporter (firstname.lastname@example.org) of this bug does not have an account here.
Reassigning to the exporter, email@example.com.
Reassigning to the default owner of the component, firstname.lastname@example.org.
autofill was not taking the autoformat into consideration.