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.v19.1.dll

Declaration

C#

public CustomFunctionExportMode CustomFunctionExportMode { get; set; }

VB.NET

Public Property CustomFunctionExportMode As CustomFunctionExportMode

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	.Export.CustomFunctionExportMode

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.