PivotGridFieldBase.UseNativeFormat Property

Gets or sets whether to use the current field’s data format when the Pivot Grid Control is exported in XLS/XLSX formats.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v21.2.Core.dll

NuGet Package: DevExpress.PivotGrid.Core

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean UseNativeFormat { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
Public Property UseNativeFormat As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	A DefaultBoolean value that specifies whether to use the current field’s data format when the Pivot Grid Control is exported in XLS/XLSX formats.

Available values:

Name	Description
True	true. DefaultBoolean.True has a constant value of 0, while the standard true value corresponds to a value of 1. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
False	false. DefaultBoolean.False has a constant value of 1, while the standard false value corresponds to a value of 0. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
Default	The default behavior determined by the control’s logic.

Remarks

You can export PivotGridControl’s data in XLS and XLSX formats using the PivotGridControl.ExportToXls and PivotGridControl.ExportToXlsx methods, respectively.

The UseNativeFormat option specifies whether values of numeric data fields are exported in XLS/XLSX format as numbers or as text. If the UseNativeFormat property is set to DefaultBoolean.Default, the actual export mode will be determined by the options or textExportMode parameter (depends on which overload is used) of the PivotGridControl.ExportToXls and PivotGridControl.ExportToXlsx method.