Page 1 of 1

DirectRead Excel97 OnReadCell not Fired

Posted: Fri May 17, 2013 12:31 pm
by braune
When read Excel97 file the OnReadCell Event not fired.
Excel2007 files works fine.
Have testet with ReadDirect Sample with Version xvExcel97.

Delphi2007
Windows XP SP3
ExcelReadWriteII V5 .10.21

Thanks

Re: DirectRead Excel97 OnReadCell not Fired

Posted: Mon May 20, 2013 1:06 pm
by larsa
Hello

This is fixed in update 5.10.22

Re: DirectRead Excel97 OnReadCell not Fired

Posted: Tue May 21, 2013 7:10 am
by braune
Hello

thanks to fix the event, but the function ColRowToRefStr(ACell.Col,ACell.Row) get following for xvExcel97:

A Excel table with 2 columns:

A1, B1, C1, D1, E1, F1,... ???

I think: A1, B1, A2, B2, A3, B3,... is right

under xvExcel2007 its right

Re: DirectRead Excel97 OnReadCell not Fired

Posted: Tue May 21, 2013 7:29 am
by braune
... and

ACell.AsString on a float cell get a false result

Re: DirectRead Excel97 OnReadCell not Fired

Posted: Tue May 21, 2013 1:19 pm
by larsa
Hello

Will fix the row problem in the next update. AsString is intentional. Check the CellType before you read the value.