PivotGridField.UseNativeFormat Property

Gets or sets whether to use the current field’s data format when the Pivot Grid Control is exported in XLS format. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public bool? UseNativeFormat { get; set; }

VB.NET

Public Property UseNativeFormat As Boolean?

Property Value

Type	Description
Nullable<Boolean>	true to use the current field’s data format when the Pivot Grid Control is exported in XLS format; otherwise, false.

Remarks

You can export PivotGridControl’s data in XLS format via the PivotGridControl.ExportToXls method.

The UseNativeFormat option specifies whether values of numeric data fields are exported in XLS format as numbers or as text. If the UseNativeFormat property is set to null, the actual export mode will be determined by the options parameter of the PivotGridControl.ExportToXls method.