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 ?
Error in formula
Re: Error in formula
Hello
You are probably using the wrong character for parameter separator. Use the value of the global variable ListSeparator.
You are probably using the wrong character for parameter separator. Use the value of the global variable ListSeparator.
Lars Arvidsson, Axolot Data
Re: Error in formula
Pardon ?
I do not understand how can affect ListSeparator with a sentence like
sheet.SetAsFormula[1,1] := 'IF($I8<$F9, $F9, $I9)' ;
I do not understand how can affect ListSeparator with a sentence like
sheet.SetAsFormula[1,1] := 'IF($I8<$F9, $F9, $I9)' ;