CsvDataAwareExporterOptions.UseCellNumberFormat Property

Gets or sets whether to use the cell Formatting.NumberFormat property to convert a cell numeric value to a string.

Namespace: DevExpress.XtraExport.Csv

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public bool UseCellNumberFormat { get; set; }

VB.NET

Public Property UseCellNumberFormat As Boolean

Property Value

Type	Description
Boolean	True to use cell formatting to convert a cell value to a string; otherwise, false.

Remarks

By default, numeric cell values are exported using the cell format strings. However, you can set the UseCellNumberFormat to false, so that the current culture’s format string is used to convert a value to a string representation.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the UseCellNumberFormat property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

VB.NET

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L119

csvOptions.WritePreamble = True
csvOptions.UseCellNumberFormat = False
csvOptions.NewlineAfterLastRow = True