Re: Fix serial date buglet

[David Gilbert <david gilbert jrefinery com>]

Hi Neil,

This "bug" might be a clever way of covering for the fact that Excel itself 
has a bug in that it recognises 1900 as a leap year when in fact it is not a 
leap year.  More info here: 

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q181370

Since Excel will count 29-Feb-1900 as 59, then 1-Mar-1900 as 60, Excel and 
Gnumeric will fall into line from that point onwards...

Regards,

Dave Gilbert

On Sunday 13 January 2002 13:42, Neil Booth wrote:
> Gnumeric does not match Excel for the serial date of 28 Feb 1900.
> This fixes it.
>
> Neil.
>
> 2002-01-13  Neil Booth  <neil daikokuya demon co uk>
>
>       * datetime.c (date_serial_19000228): Should be 59 to match
>       Excel for 28 Feb 1900.
>
> Index: datetime.c
> ===================================================================
> RCS file: /cvs/gnome/gnumeric/src/datetime.c,v
> retrieving revision 1.15
> diff -u -p -r1.15 datetime.c
> --- datetime.c        2002/01/10 06:40:20     1.15
> +++ datetime.c        2002/01/13 13:35:35
> @@ -27,7 +27,7 @@ static int date_origin = 0;
>   * The serial number of 19000228.  Excel allocates a serial number for
>   * the non-existing date 19000229.
>   */
> -static const int date_serial_19000228 = 58;
> +static const int date_serial_19000228 = 59;
>
>  static void
>  date_init (void)
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list