close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 15 years ago

Last modified 15 years ago

#1213 accepted defect

ReadDate fails with ancient dates

Reported by: Jorge Owned by: Jorge
Priority: high Milestone: Mantainance
Component: Excel API Version: 2.0.1
Severity: major Keywords:
Cc:

Description

The following code results in a wrong date:

TolExcel::@WorkBook xls2 = TolExcel::@WorkBook::Open("ex2.xls");
Real xls2::ActivateWS(1);
Date d = xls2::ReadDate( 1, 1 );

with the attached file d should y1820m1d1 but it is y1820m01d02

Attachments (1)

ex2.xls​ (6.5 KB) - added by Jorge 15 years ago.

Download all attachments as: .zip

Change History (3)

Changed 15 years ago by Jorge

Attachment: ex2.xls​ added

comment:1 Changed 15 years ago by Jorge

Status: new → accepted

There should be a bug in the formula which convert the excel number to a tol date. With recent dates it is correct.

comment:2 Changed 15 years ago by Víctor de Buen Remiro

Según Excel el año 1900 fue bisiesto, lo cual es falso, así que el error es de Excel, no de TOL

Note: See TracTickets for help on using tickets.