WorkbookFunctions Interface

Provides access to worksheet functions and enables you to override a built-in function.

Namespace: DevExpress.Spreadsheet.Functions

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

Declaration

C#

public interface WorkbookFunctions

VB.NET

Public Interface WorkbookFunctions

Related API Members

The following members accept/return WorkbookFunctions objects:

Library	Related API Members
Cross-Platform Class Library	IWorkbook.Functions
Office File API	Workbook.Functions

Remarks

An object of the WorkbookFunctions class is available by using the IWorkbook.Functions property. Use the WorkbookFunctions.OverrideFunction method to override a worksheet built-in function. The method requires the function to be replaced and a custom function with which the built-in function will be replaced.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the WorkbookFunctions interface.

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-the-built-in-worksheet-function-t124453/CS/FunctionWrapperSample/Form1.cs#L29

{
    WorkbookFunctions functions = spreadsheetControl1.Document.Functions;
    // Obtain the built-in function to override.

VB.NET

udf-custom-function-how-to-replace-the-built-in-worksheet-function-t124453/VB/FunctionWrapperSample/Form1.vb#L26

Private Sub ReplaceSinFunction()
    Dim functions As WorkbookFunctions = spreadsheetControl1.Document.Functions
    ' Obtain the built-in function to override.