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.v20.2.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core
Declaration
[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean UseNativeFormat { get; set; }
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 | Corresponds to a Boolean value of true. |
False | Corresponds to a Boolean value of false. |
Default | The value is determined by the current object’s parent object setting (e.g., a control setting). |
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.