The btibExcel module uses the Apache POI API to read/write excel documents. It is an ever evolving API, and unfortunately all the excel functions aren't supported yet.
Some functions you're used to use might be absent from the list. In this case, try using another one.
And if you can't find a suitable replacement, what you can do is to work with two excel files:
-
one in which you will use your formulas
-
one which will be a copy of the first one, in which you will copy paste only the VALUES. This will be the file used for the imports/exports with the btibExcel module.
Here is the list of all the supported functions:
|
ABS |
|
ACOS |
|
ACOSH |
|
ADDRESS |
|
AND |
|
AREAS |
|
ASIN |
|
ASINH |
|
ATAN |
|
ATAN2 |
|
ATANH |
|
AVEDEV |
|
AVERAGE |
|
CEILING |
|
CHAR |
|
CHOOSE |
|
CLEAN |
|
CODE |
|
COLUMN |
|
COLUMNS |
|
COMBIN |
|
CONCAT |
|
CONCATENATE |
|
COS |
|
COSH |
|
COUNT |
|
COUNTA |
|
COUNTBLANK |
|
COUNTIF |
|
DATE |
|
DATEVALUE |
|
DAY |
|
DAYS360 |
|
DEGREES |
|
DEVSQ |
|
DGET |
|
DMAX |
|
DMIN |
|
DOLLAR |
|
DSUM |
|
ERROR.TYPE |
|
EVEN |
|
EXACT |
|
EXP |
|
FACT |
|
FALSE |
|
FIND |
|
FIXED |
|
FLOOR |
|
FREQUENCY |
|
FV |
|
GEOMEAN |
|
HLOOKUP |
|
HOUR |
|
HYPERLINK |
|
IF |
|
INDEX |
|
INDIRECT |
|
INT |
|
INTERCEPT |
|
IPMT |
|
IRR |
|
ISBLANK |
|
ISERR |
|
ISERROR |
|
ISLOGICAL |
|
ISNA |
|
ISNONTEXT |
|
ISNUMBER |
|
ISREF |
|
ISTEXT |
|
LARGE |
|
LEFT |
|
LEN |
|
LN |
|
LOG |
|
LOG10 |
|
LOOKUP |
|
LOWER |
|
MATCH |
|
MAX |
|
MAXA |
|
MDETERM |
|
MEDIAN |
|
MID |
|
MIN |
|
MINA |
|
MINUTE |
|
MINVERSE |
|
MIRR |
|
MMULT |
|
MOD |
|
MODE |
|
MONTH |
|
NA |
|
NORMDIST |
|
NORMINV |
|
NORMSDIST |
|
NORMSINV |
|
NOT |
|
NOW |
|
NPER |
|
NPV |
|
ODD |
|
OFFSET |
|
OR |
|
PERCENTILE |
|
PERCENTRANK |
|
PI |
|
PMT |
|
POISSON |
|
POWER |
|
PPMT |
|
PRODUCT |
|
PROPER |
|
PV |
|
RADIANS |
|
RAND |
|
RANK |
|
RATE |
|
REPLACE |
|
REPT |
|
RIGHT |
|
ROMAN |
|
ROUND |
|
ROUNDDOWN |
|
ROUNDUP |
|
ROW |
|
ROWS |
|
SEARCH |
|
SECOND |
|
SIGN |
|
SIN |
|
SINH |
|
SLOPE |
|
SMALL |
|
SQRT |
|
STANDARDIZE |
|
STDEV |
|
SUBSTITUTE |
|
SUBTOTAL |
|
SUM |
|
SUMIF |
|
SUMPRODUCT |
|
SUMSQ |
|
SUMX2MY2 |
|
SUMX2PY2 |
|
SUMXMY2 |
|
T |
|
TAN |
|
TANH |
|
TDIST |
|
TEXT |
|
TIME |
|
TIMEVALUE |
|
TODAY |
|
TRANSPOSE |
|
TREND |
|
TRIM |
|
TRUE |
|
TRUNC |
|
UPPER |
|
VALUE |
|
VAR |
|
VARP |
|
VLOOKUP |
|
WEEKDAY |
|
YEAR |