An assembly of functions that faithfully match their Excel equivalents, and are ready for use by walkingkooka-spreadsheet-server.

This is mostly an assembly of the following repos which concentrate on ExpressionFunction implementations.

All the functions in the above repos have been executed using the default environment which has several important different semantics that exist within a spreadsheet formula or function evaluation.

All java exceptions thrown by an expression or function are converted to the correct error, the normal function execution simply throws exception. This is important because an expression like isError(1/0) needs the divide by error as its argument rather than lettering the exception propogate.
The functions include tests that use spreadsheet context that handles value converting using spreadsheet rules and formatters.

Functions

abs()
acos()
address
and()
asin()
atan()
average()
averageIf()
base()
bin2dec()
bin2hex()
bin2oct()
bitAnd()
bitOr()
bitXor()
ceil()
cell()
char()
choose()
clean()
code()
column()
columns()
concat()
cos()
count()
countA()
countBlank()
countIf()
date()
day()
days()
dec2bin()
dec2hex()
dec2oct()
decimal()
degrees(),
delta(),
dollar()
e(),
even()
exact()
exp()
false()
find()
fixed()
formulaText(),
hex2bin()
hex2dec()
hex2oct()
hour()
int()
if()
ifs()
indirect()
isBlank(),
isErr(),
isError(),
isEven(),
isFormula()
isLogical()
isNa(),
isNonText(),
isNumber(),
isOdd()
isoWeekNum()
isText(),
lambda(),
left(),
len(),
let(),
ln(),
log(),
log10(),
lower(),
max(),
maxIf(),
mid(),
min(),
minIf(),
minutes()
mod()
month()
not()
now()
numberValue()
oct2bin()
oct2dec()
oct2hex()
odd()
offset()
or()
pi()
product()
proper()
quotient()
radians()
rand()
randBetween()
replace()
rept()
right()
roman()
round()
roundDown()
roundUp()
row()
rows()
search()
second()
sign()
sin()
sinh()
sqrt()
substitute()
sum(),
sumIf(),
switch()
t()
tan()
tanh()
text()
textjoin()
time()
trim()
true()
trunc()
type()
unichar()
unicode()
upper()
value()
weeknum()
year()
xor()

mP1/walkingkooka-spreadsheet-server-expression-function

Functions