function TODAY()

Guest · Post by **Guest** » Fri Oct 20, 2006 1:13 pm

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

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

Guest · Post by **Guest** » Sat Oct 21, 2006 7:58 am

Is there exists list of supported Excel functions?

Post by **larsa** » Mon Oct 23, 2006 5:44 am

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