Page 1 of 1

AsFmtString...

Posted: Fri Dec 15, 2006 8:14 pm
by Guest
Hi, Larsa!
Why value of a cell is incorrectly displayed?
In cell [ColNumb, RowNumb] - 1:04:09
At reading from a file

Code: Select all

var Value: string;
...
Value:= XLSRW.Sheets[idx].AsFmtString[ColNumb, RowNumb];
Value = 1:04:SS :shock: ...

Posted: Mon Dec 18, 2006 7:35 am
by larsa
Hello

I need the excel file in order to tell why. Please send it to me.


Lars Arvidsson

Posted: Mon Dec 18, 2006 2:18 pm
by Guest
File is sent.

Posted: Sat Dec 23, 2006 5:27 pm
by Guest
In addition...
1.
In a cell is written year - as 2003.
I use AsFmtString.
After loading in the Grid I receive - 2 003.

2.
I save the Grid in a xls-file.
I click on a cell for change of a format of a cell.
Dialogue does not appear.