IWorkbook.CustomFunctions Property

Provides access to a collection of custom functions in a workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v17.2.Core.dll

Declaration

C#

CustomFunctionCollection CustomFunctions { get; }

VB.NET

ReadOnly Property CustomFunctions As CustomFunctionCollection

Property Value

Type	Description
CustomFunctionCollection	A CustomFunctionCollection collection of custom functions.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CustomFunctions property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/CS/UDF_Discount/Form1.cs#L20

DiscountFunction udfFunction = new DiscountFunction();
if (!spreadsheetControl1.Document.CustomFunctions.Contains(udfFunction.Name))
    spreadsheetControl1.Document.CustomFunctions.Add(udfFunction);

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/CustomFunctionActions.cs#L23

SphereMassFunction customFunction = new SphereMassFunction();
if (!workbook.CustomFunctions.Contains(customFunction.Name))
    workbook.CustomFunctions.Add(customFunction);

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/CS/SpreadsheetAddIn/Form1.cs#L45

    AddInFunction function = new AddInFunction("SPHEREMASS", excelHelper);
    spreadsheetControl1.Document.CustomFunctions.Add(function);
}

VB.NET

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/VB/UDF_Discount/Form1.vb#L19

Dim udfFunction As New DiscountFunction()
If (Not spreadsheetControl1.Document.CustomFunctions.Contains(udfFunction.Name)) Then
    spreadsheetControl1.Document.CustomFunctions.Add(udfFunction)

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/CustomFunctionActions.vb#L24

Dim customFunction As New SphereMassFunction()
If Not workbook.CustomFunctions.Contains(customFunction.Name) Then
    workbook.CustomFunctions.Add(customFunction)

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538369/VB/CustomFunctionReturningArrayExample/Form1.vb#L26

Dim customFunction As New TestArrayCustomFunction()
If Not spreadsheetControl1.Document.CustomFunctions.Contains(customFunction.Name) Then
    spreadsheetControl1.Document.CustomFunctions.Add(customFunction)

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/VB/SpreadsheetAddIn/Form1.vb#L42

    Dim [function] As New AddInFunction("SPHEREMASS", excelHelper)
    spreadsheetControl1.Document.CustomFunctions.Add([function])
End Sub