Axolot Data

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