DirectRead Excel97 OnReadCell not Fired

[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

[larsa]

Hello

This is fixed in update 5.10.22

[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

[braune]

... and

ACell.AsString on a float cell get a false result

[larsa]

Hello

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