Formula Support

JDataGrid Programmer Guide > Formula Support

Formula Support

The evaluation version of JDataGrid only provides a few formula functions for demostrating, in order to get more functions, please purchase a Binary License or Source Code License.

The purchase version of JDataGrid supports the logical functions, date functions, math functions, string functions, cell functions, and partial statistical functions. We work hard to add new functions and improve the formula support for JDataGrid in the future release.

Functions

The current version of JDataGrid supports the following functions:

Logical Functions:
- AND
- OR
- NOT
- IF
- TRUE
- FALSE
Date Functions:
- DATE
- DATEVALUE
- DAY
- DAYS360
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WORKDAY
- YEAR
- YEARFRAC
Math Functions:
- ABS
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- CEILING
- COMBIN
- COS
- COSH
- COUNTIF
- DEGREES
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
String Functions:
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FIXED
- LEFT
- LEN
- LOWER
- MID
- PROPER
- REPLACE
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- T
- TEXT
- TRIM
- UPPER
- VALUE
Info Functions:
- CELL
- COUNTBLANK
- ERROR.TYPE
- INFO
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISREF
- ISTEXT
- N
- NA
- TYPE
Cell Functions:
- ADDRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- INDEX
- ROW
- ROWS
Statistical Functions:
- SUM
- AVERAGE
- MAX
- MIN
- COUNT
- COUNTA

Create a formula

The following codes demostrate how to create a formula:

Code Samples:

String text = "3+4*5+7"; Formula formula = FormulaFactory.getDefault().createFormula(text);

Formula Syntax

The formula syntax follow the standard formula syntax of Microsoft EXCEL.

Work formula with JDataGird

The JDataGrid provides support for formula operation, it allows calculating the formula automaticly.

Formula Renderer and Editor

The JDataGrid provides a formula cell renderer and a formula cell editor.

Known Problems

The support for the formula of JDataGrid is not completed, and we will continue working hard to add new functions and improve the formula support.