SpreadsheetExportOptions.CustomFunctionExportMode Property
Specifies whether custom function definitions should be replaced with the corresponding calculated values when exporting a document. This is a dependency property.
Namespace: DevExpress.Xpf.Spreadsheet
Assembly: DevExpress.Xpf.Spreadsheet.v24.1.dll
NuGet Package: DevExpress.Wpf.Spreadsheet
Declaration
Property Value
| Type | Description |
|---|---|
| CustomFunctionExportMode | 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 |
|---|---|
| SpreadsheetControlOptions |
|
Remarks
Custom functions are not saved in a workbook. Therefore, 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.