Home > Products > JComponentPack Overview > Features > Cell Formula Component

Cell Formula Component Features

 

Formula Support

supports the logical functions, date functions, math functions, string functions, cell functions, and partial statistical functions.

JDataGrid includes many formulas, it have the same syntax like Excel formulas.
Excel Formula
JDataGrid includes many formulas, it have the same syntax like Excel formulas, it allow you to perform calculations on data you have entered into the spreadsheet, you can change the data and JDataGrid will automatically recalculate the answer for you..
Functions
The current version 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 automatically.
Formula Renderer and Editor
The JDataGrid provides a formula cell renderer and a formula cell editor.