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

And another cell has the formula:

MYFUNCTION(A1:B2,"test",3)

Parameters will hold:

{11,12,13,14},"test",3

The 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