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

Declaration

C#

[DefaultValue(TextExportMode.Text)]
[XtraSerializableProperty]
public TextExportMode TextExportMode { get; set; }

VB.NET

<DefaultValue(TextExportMode.Text)>
<XtraSerializableProperty>
Public Property TextExportMode As TextExportMode

Property Value

Type	Default	Description
TextExportMode	**Text**	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 formatting embedded into those strings.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to TextExportMode
Cross-Platform Class Library	ExportOptions	.Text.TextExportMode
WPF Controls	ExportOptionsContainer	.Text.TextExportMode

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.