[quote="larsa"]Hello
The N/A error is fixed in the latest update.
When formatting numeric values, use the NumberFormat property. Example: XLS.Sheets[0].Cell[0,0].NumberFormat := '# ##0.000';
The format string is the same as in excel.[/quote]
thanx, good job
Search found 2 matches
- Sat Oct 22, 2011 12:01 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: AsFormula =#N/A error
- Replies: 4
- Views: 5324
- Wed Oct 12, 2011 6:46 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: AsFormula =#N/A error
- Replies: 4
- Views: 5324
AsFormula =#N/A error
Hello!
I try trial version of XLSReadWriteII 4.00.55a in Delphi XE2
Situation :
xls.sheets[0].AsFormula[1,1]:='A1+B1';
Result in excel = =#N/A
thx,
ASD
I try trial version of XLSReadWriteII 4.00.55a in Delphi XE2
Situation :
xls.sheets[0].AsFormula[1,1]:='A1+B1';
Result in excel = =#N/A
thx,
ASD