CellFormula Property

The formula of the selected cell.

Syntax

[VB.NET]
Public Property CellFormula As String

[C#]
public string CellFormula {get; set;}

Remarks

This property holds the formula of the selected Cell.

The following functions are supported by the component. Unsupported functions are handled through the Function event.

Address and Reference functions

• ADDRESS
• CHOOSE
• COLUMN
• COLUMNS
• INDEX
• ROW
• ROWS
• VLOOKUP
• HLOOKUP

Information functions

• ERROR_TYPE
• ISBLANK
• ISERR
• ISEVEN
• ISERROR
• ISLOGICAL
• ISNA
• ISNONTEXT
• ISNUMBER
• ISODD
• ISREF
• ISTEXT
• N
• NA
• TYPE

Date and Time functions

• DATE
• DATEVALUE
• DAY
• DAYS360
• EDATE
• EOMONTH
• HOUR
• MINUTE
• MONTH
• NOW
• SECOND
• TIME
• TIMEVALUE
• TODAY
• WEEKDAY
• WEEKNUM
• YEAR

Math Functions

• ABS
• ACOS
• ACOSH
• ASIN
• ASINH
• ATAN
• ATAN2
• ATANH
• AVERAGE
• CEILING
• COMBIN
• COS
• COSH
• SUM
• SUMIF
• SUMPRODUCT
• SUMSQ
• SUMX2MY2
• SUMX2PY2
• SUMXMY2
• DEGREES
• EVEN
• EXP
• FACT
• FACTDOUBLE
• FLOOR
• GCD
• INT
• LCM
• LN
• LOG
• LOG10
• MOD
• ODD
• PI
• POWER
• PRODUCT
• QUOTIENT
• RADIANS
• RAND
• RANDBETWEEN,
• ROUND
• ROUNDDOWN
• ROUNDUP
• SERIESSUM
• SIGN
• SIN
• SINH
• SQRT
• SQRTPI
• TAN
• TANH
• TRUNC

Logical functions

• AND
• IF
• TRUE
• FALSE
• OR
• NOT
• MAX
• MIN

Statistical functions

• COUNT
• COUNTA
• COUNTBLANK
• COUNTIF
• VAR
• VARP
• SUBTOTAL

Text functions

• TRIM
• MID
• LEFT
• RIGHT
• CHAR
• CLEAN
• CONCATENATE,
• EXACT
• LEN
• LOWER
• UPPER
• REPLACE
• FIND
• PROPER
• REPT
• SUBSTITUTE
• T
• VALUE
• FIXED
• DOLLAR
• CODE
• SEARCH

This property is not available at design time.

Default Value

""