TextExportOptionsBase.TextExportMode Property
Gets or sets a value indicating whether to use the formatting of the data fields in the bound dataset for the cells in the exported TXT, CSV, XLS or XLSX document.
Namespace: DevExpress.XtraPrinting
Assembly: DevExpress.Printing.v24.1.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Property Value
| Type | Description |
|---|---|
| TextExportMode | A TextExportMode enumeration value. |
Available values:
| Name | Description |
|---|---|
| Value | Exports all data fields to the XLS (or XLSX) file using the same formatting as they have in the original document. |
| Text | Exports all data fields to the XLS (or XLSX) file as strings, with the corresponding non-HTML formatting embedded into those strings. HTML tags are ignored. |
Remarks
Use the TextExportMode property to specify whether to use the formatting of the data fields in the bound dataset for the cells in the resulting export document.
Note that if the TextExportMode property is set to Text, all data fields are exported as strings, with the corresponding formatting embedded into those strings. And, if the TextExportMode property is set to Value, all formatting will be lost in the resulting file.
When exporting a PivotGridControl, this property also affects field values (if these values are different from the display text). For example, when a field’s PivotGridFieldBase.GroupInterval is set to Month, this property determines whether it will be exported in numeric or string format.