TextExportMode Enum
Specifies whether to use the formatting of the data fields in the bound dataset for the cells in the exported XLS (or XLSX) document.
Namespace: DevExpress.XtraPrinting
Assembly: DevExpress.Printing.v24.2.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Members
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. |
Related API Members
The following properties accept/return TextExportMode values:
Remarks
The TextExportMode
enumeration values are used to get or set the TextExportOptionsBase.TextExportMode property, which is used to specify whether to use the formatting of the data fields in the bound dataset for the cells in the exported XLS document. Note that if the TextExportOptionsBase.TextExportMode property is set to Text, all data fields are exported to the XLS 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.