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 |
---|---|---|
Custom |
Function | A Custom |
Available values:
Name | Description |
---|---|
Calculated |
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 Custom |
---|---|
Document |
|
#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.