Page 1 of 1

Error in formula

Posted: Fri Apr 17, 2009 3:31 pm
by rescondio
Hello,

If I assign to TSheet.SetAsFormula[row, col] the formula ''IF($I8<$F9, $F9, $I9)" I get an error: "Invalid name"

How can I assign that formula to sheet ?

Re: Error in formula

Posted: Tue Apr 21, 2009 9:15 am
by larsa
Hello

You are probably using the wrong character for parameter separator. Use the value of the global variable ListSeparator.

Re: Error in formula

Posted: Thu Apr 23, 2009 10:52 am
by rescondio
Pardon ?

I do not understand how can affect ListSeparator with a sentence like

sheet.SetAsFormula[1,1] := 'IF($I8<$F9, $F9, $I9)' ;