Function Event
Fired when an unsupported function is encountered.
Syntax
[VB.NET] Public Event OnFunction As OnFunctionHandler
[C#] public event OnFunctionHandler OnFunction; public delegate void OnFunctionHandler(object sender, ExceldocFunctionEventArgs e); class ExceldocFunctionEventArgs : EventArgs { string Name {get;} string Parameters {get;} string Result {get; set;} }
Remarks
This event fires for each unsupported function that is encountered when calling EvaluateFormula, Recalculate or RecalculateAll. Use the parameters available within this event to calculate a result.
Name is the name of the function.
Parameters is a comma separated list of function parameters. Ranges are enclosed with braces. String values are quoted. For instance if a sheet contains data such as:
A | B | |
1 | 11 | 12 |
2 | 13 | 14 |
MYFUNCTION(A1:B2,"test",3)Parameters will hold:
{11,12,13,14},"test",3The RangeRowDelimiter setting controls how a range is represented.
Result should be set to the calculated value.
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