Error in formula

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
rescondio

Error in formula

Post 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 ?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Error in formula

Post by larsa »

Hello

You are probably using the wrong character for parameter separator. Use the value of the global variable ListSeparator.
Lars Arvidsson, Axolot Data
rescondio

Re: Error in formula

Post by rescondio »

Pardon ?

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

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