IWorkbook.Functions Property

Provides access to the built-in functions in a workbook.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

WorkbookFunctions Functions { get; }

VB.NET

ReadOnly Property Functions As WorkbookFunctions

Property Value

Type	Description
WorkbookFunctions	An object implementing the WorkbookFunctions interface.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Functions 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-the-built-in-worksheet-function-t124453/CS/FunctionWrapperSample/Form1.cs#L29

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

spreadsheet-use-concatenate-function-to-update-long-strings-in-formulas/CS/SpreadsheetApp/ReplaceLongStringsWalker.cs#L38

var modifer = modifiers.Peek();
modifer(new FunctionExpression(workbook.Functions["CONCATENATE"],
        SplitLongString(expression.Value.TextValue)));

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.

spreadsheet-use-concatenate-function-to-update-long-strings-in-formulas/VB/SpreadsheetApp/ReplaceLongStringsWalker.vb#L39

Dim modifer = modifiers.Peek()
modifer(New FunctionExpression(workbook.Functions("CONCATENATE"), SplitLongString(expression.Value.TextValue)))
IsExpressionModified = True