Skip to main content
Tag

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public bool? UseNativeFormat { get; set; }

#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.

See Also