Skip to main content

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

[XtraSerializableProperty]
public TextExportMode TextExportMode { get; set; }

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.

See Also