CellValueToStringConverter.SetPreferredNumberFormat(IWorkbook, String) Method

Specifies a number format (in the invariant culture) used for string representation of numeric values.

Namespace: DevExpress.Spreadsheet.Export

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

public void SetPreferredNumberFormat(
    IWorkbook workbook,
    string excelNumberFormat
)

VB.NET

Public Sub SetPreferredNumberFormat(
    workbook As IWorkbook,
    excelNumberFormat As String
)

Parameters

Name	Type	Description
workbook	IWorkbook	The current workbook.
excelNumberFormat	String	A Microsoft Excel compatible number format.

Remarks

You can also use the CellValueToStringConverter.SetPreferredNumberFormatLocal method to specify a number format based on the local culture defined by the DocumentOptions.Culture property.