Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

WorkbookExportOptions.CustomFunctionExportMode Property

Specifies whether custom function definitions should be replaced with the corresponding calculated values when exporting a document.

Namespace: DevExpress.XtraSpreadsheet.Export

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

[DefaultValue(CustomFunctionExportMode.Function)]
public CustomFunctionExportMode CustomFunctionExportMode { get; set; }

#Property Value

Type Default Description
CustomFunctionExportMode Function

A CustomFunctionExportMode enumerator value.

Available values:

Name Description
CalculatedValue

Export values calculated from custom functions.

Function

Export custom function definitions.

#Property Paths

You can access this nested property as listed below:

Object Type Path to CustomFunctionExportMode
DocumentOptions
.Export .CustomFunctionExportMode

#Remarks

Custom functions are not saved in a workbook. So, if a worksheet that contains a custom function is loaded in a workbook that is not aware of the function (or in MS Excel), the “#NAME!” error is displayed after the cell containing the function has been re-evaluated. To avoid this situation, you can set the CustomFunctionExportMode option to CustomFunctionExportMode.CalculatedValue and custom functions will be converted to their calculated values when saving a document.

See Also