A newer version of this page is available. Switch to the current version.

XlExportOptionsBase.TextExportMode Property

Gets or sets a value indicating whether the cells in the resulting XLS document should use the same formatting as the original document.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v18.2.Core.dll

Declaration

[DefaultValue(TextExportMode.Value)]
[XtraSerializableProperty]
public TextExportMode TextExportMode { get; set; }
<DefaultValue(TextExportMode.Value)>
<XtraSerializableProperty>
Public Property TextExportMode As TextExportMode

Property Value

Type Default Description
TextExportMode

Value

A TextExportMode enumeration value, specifying the text export mode in the resulting XLS document.

Property Paths

You can access this nested property as listed below:

Show 20 property paths
Library Object Type Path to TextExportMode
Cross-Platform Class Library RemotePrintingSystem
.ExportOptions.Xlsx.TextExportMode
RemotePrintingSystem
.ExportOptions.Xls.TextExportMode
ExportOptions
.Xlsx.TextExportMode
ExportOptions
.Xls.TextExportMode
PrintingSystemBase
.ExportOptions.Xlsx.TextExportMode
PrintingSystemBase
.ExportOptions.Xls.TextExportMode
WinForms Controls PrintingSystem
.ExportOptions.Xlsx.TextExportMode
PrintingSystem
.ExportOptions.Xls.TextExportMode
XtraSchedulerReport
.ExportOptions.Xlsx.TextExportMode
XtraSchedulerReport
.ExportOptions.Xls.TextExportMode
WPF Controls ExportOptionsContainer
.Xlsx.TextExportMode
ExportOptionsContainer
.Xls.TextExportMode
PrintingSystem
.ExportOptions.Xlsx.TextExportMode
PrintingSystem
.ExportOptions.Xlsx.TextExportMode
PrintingSystem
.ExportOptions.Xls.TextExportMode
PrintingSystem
.ExportOptions.Xls.TextExportMode
Reporting XtraReport
.ExportOptions.Xlsx.TextExportMode
XtraReport
.ExportOptions.Xls.TextExportMode
DocumentOperationRequest
.ExportOptions.Xlsx.TextExportMode
DocumentOperationRequest
.ExportOptions.Xls.TextExportMode

Remarks

Use the TextExportMode property to specify whether to use both the .NET and native XLSX formatting of the data fields in the bound dataset for the cells in the exported XLS (or, XLSX) document. Note that if the TextExportMode property is set to Text, all data fields are exported to the XLS (or, XLSX) file as strings, with the corresponding formatting embedded into those strings.

NOTE

Unfortunately, not all .NET format strings have their equivalents in XLS format. If exact conversion is impossible, the XtraPrinting Library tries to find a string that best resembles the original. For example, the .NET "n4" format that represents a numerical value with 4 decimal places, will be converted as "n2", to represent this numerical value with 2 decimal places, since the XLS format doesn't have a built-in numerical format with 3 or 4 decimal places.

See Also