The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

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.v19.2.Core.dll

Declaration

[DefaultValue(CustomFunctionExportMode.Function)]
public CustomFunctionExportMode CustomFunctionExportMode { get; set; }
<DefaultValue(CustomFunctionExportMode.Function)>
Public Property CustomFunctionExportMode As CustomFunctionExportMode
[DefaultValue(CustomFunctionExportMode.Function)]
public CustomFunctionExportMode CustomFunctionExportMode { get; set; }
<DefaultValue(CustomFunctionExportMode.Function)>
Public Property CustomFunctionExportMode As CustomFunctionExportMode
[DefaultValue(CustomFunctionExportMode.Function)]
public CustomFunctionExportMode CustomFunctionExportMode { get; set; }
<DefaultValue(CustomFunctionExportMode.Function)>
Public Property CustomFunctionExportMode As CustomFunctionExportMode

Property Value

Type Default Description
CustomFunctionExportMode

Function

A CustomFunctionExportMode enumerator value.

Property Value

Type Default Description
CustomFunctionExportMode

Function

A CustomFunctionExportMode enumerator value.

Property Value

Type Default Description
CustomFunctionExportMode

Function

A CustomFunctionExportMode enumerator value.

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