Unknown name error
Posted: Mon Jul 11, 2011 11:49 pm
using XLSReadWriteII4 with BDS2006
Assigning formula
XLS.Sheets[0].asFormula[i,RowCounter-1] := 'C10 + D10 + E10 + F10';
Rowcounter = 10
i = 14
Getting Error : Unknown name C10
The code used to work fine with using XLSReadWriteII2.
Tried to make formula '(C10 + D10 + E10 + F10)' and 'Sum(C10 + D10 + E10 + F10)' - still getting same error.
If I remove C10 from the formula I get unknown name D10.
Narrowed it down to the following:
If formula is just 'C10' - works fine, 'D10' works fine, but 'C10 + D10' shows error unknown name C10.
Found a workaround: changed formula from 'C10 + D10 + E10 + F10' to 'SUM(C10,D10,E10,F10)'
Assigning formula
XLS.Sheets[0].asFormula[i,RowCounter-1] := 'C10 + D10 + E10 + F10';
Rowcounter = 10
i = 14
Getting Error : Unknown name C10
The code used to work fine with using XLSReadWriteII2.
Tried to make formula '(C10 + D10 + E10 + F10)' and 'Sum(C10 + D10 + E10 + F10)' - still getting same error.
If I remove C10 from the formula I get unknown name D10.
Narrowed it down to the following:
If formula is just 'C10' - works fine, 'D10' works fine, but 'C10 + D10' shows error unknown name C10.
Found a workaround: changed formula from 'C10 + D10 + E10 + F10' to 'SUM(C10,D10,E10,F10)'