AsFmtString...

Guest · Post by **Guest** » Fri Dec 15, 2006 8:14 pm

Hi, Larsa!
Why value of a cell is incorrectly displayed?
In cell [ColNumb, RowNumb] - 1:04:09
At reading from a file

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

Value = 1:04:SS

...

Post by **larsa** » Mon Dec 18, 2006 7:35 am

Hello

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

Lars Arvidsson

Guest · Post by **Guest** » Mon Dec 18, 2006 2:18 pm

File is sent.

Guest · Post by **Guest** » Sat Dec 23, 2006 5:27 pm

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.