Page 1 of 1

Unknown name error

Posted: Mon Jul 11, 2011 11:49 pm
by andreylindenau
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)'