Axolot Data

Cell contains formula =TODAY().
Call XLSReadWrite1.Calculate() leads to error:

Calculate error on cell Sheet1!B1 (1:1:0)
"Can not calculate function TODAY"

Is there exists list of supported Excel functions?

Hello

The following functions are supported now:

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.


Lars Arvidsson