Re: Drag date bug

[Tino Meinen <a t meinen chello nl>]

On Tue, 2002-08-27 at 06:54, Jody Goldberg wrote:
> On Mon, Aug 26, 2002 at 09:26:50PM -0700, Rajiv Vyas wrote:
> > Here's a bug that I noticed when I use Ctrl and drag a date so that it
> > would drag in sequence. The problem is that Gnumeric does not recognize
> > how many days there are in a month. Which means that if I use Ctrl and
> > drag the the date July 27, than it would drag on until July 35. We know
> > there is no month in a year with more than 31 days.
>
> The string 'July 27' is not recognized as a date by any of the
> default formats.  Hence you are entering it as a string.  Gnumeric
> then recognizes a string followed by a number and increases it.
Gnumeric 1.1.8 has, however, a different increment than the 1.0.x
versions.
If I set the format of column A to Date (e.g. d/m/yy) set A1=1 (=1/1/00)
and then ctrl-drag, the sequence increases the years (A2=1/1/01)
Whereas I thought the 1.0.x version would increase the day (A2=2/1/00)

--Tino