Hi there,
I have a formula on cell B22, something like
=VLOOKUP($A$21;INDIRECT(F22);6)*G22
When I do the calculation:
XLS.Calculate;
Show me the message:
|--------------------------------------------------|
| Calculate error on cell Ten Times table!B22(0:1:21) |
| "Can not calculate function INDIRECT" |
|--------------------------------------------------|
Ten Times table = sheet name
.........................................................................................
The problem is: I would like to read the cell B22 (if I open in excel and save, everything is OK - I can read B22), but it would be great if XLSReadWriteII4 could calculate with Indirect function.
Lars said that in some where
"the following functions are supported for this component:"
COUNT, IF, ISNA, ISERROR, SUM, AVERAGE, MIN, MAX, ROW, COLUMN, NA, NPV, STDEV, DOLLAR, FIXED, COS, SIN, TAN, ATAN, PI, EXP, LN, LOG10, ABS, INT, SIGN, ROUND, LOOKUP, TRUE, FALSE, AND, OR, NOT, MOD
"Unsupported functions can be calculated in the OnFunction event".
.......................................................................................................................
I have simply no idea how to use OnFunction in this case.. Can somebody help me?
Thanks. Warleyalex