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.