Re: Drag date bug

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
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)


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]