The following Excel-compatible functions can be used in JCVGantt user grids.
(Note: we will be more fully documenting these features in a later release,
for the moment, here is
a list of features which may be referenced against this list of instructions on how to use them:
|
ABS
|
|
ACOS
|
|
ACOSH
|
|
ADD
|
|
AND
|
|
ASIN
|
|
ASINH
|
|
ATAN
|
|
ATAN2
|
|
ATANH
|
|
AVERAGE
|
|
CEILING
|
|
CHAR
|
|
CLEAN
|
|
CODE
|
|
COMBIN
|
|
CONCATENATE
|
|
COS
|
|
COSH
|
|
DATE
|
|
DAY
|
|
DB
|
|
DDB
|
|
DEGREES
|
|
EVEN
|
|
EXACT
|
|
EXP
|
|
FACT
|
|
FIND
|
|
FLOOR
|
|
FV
|
|
HOUR
|
|
IF
|
|
INT
|
|
INVERSE
|
|
ISBLANK
|
|
ISEVEN
|
|
ISNONTEXT
|
|
ISNUMBER
|
|
ISODD
|
|
ISREF
|
|
ISTEXT
|
|
LEFT
|
|
LEN
|
|
LN
|
|
LOG
|
|
LOG10
|
|
LOWER
|
|
MAX
|
|
MEDIAN
|
|
MID
|
|
MIN
|
|
MINUTE
|
|
MOD
|
|
MODE
|
|
MONTH
|
|
NEG
|
|
NOT
|
|
NOW
|
|
NPER
|
|
ODD
|
|
OR
|
|
PERMUT
|
|
PI
|
|
PMT
|
|
POWER
|
|
PRODUCT
|
|
PROPER
|
|
PV
|
|
RADIANS
|
|
RAND
|
|
RANK
|
|
REPLACE
|
|
REPT
|
|
RIGHT
|
|
ROUND
|
|
ROUNDDOWN
|
|
ROUNDUP
|
|
SECOND
|
|
SIGN
|
|
SIN
|
|
SINH
|
|
SLN
|
|
SQRT
|
|
SQUARE
|
|
STDEV
|
|
STDEVP
|
|
SUBSTITUTE
|
|
SU
|
|
SUMSQ
|
|
SYD
|
|
TAN
|
|
TANH
|
|
TIME
|
|
TODAY
|
|
TRIM
|
|
TRUNC
|
|
UPPER
|
|
URL
|
|
VAR
|
|
VARP
|
|
WEEKDAY
|
|
XROOT
|
|
YEAR
|
|
|
|
|
|
|
