RepositoryItemTextEdit.XlsxFormatString Property

Gets or sets the native Excel format string used to format the editor’s value when exporting to XLSX. This property is in effect in WYSIWYG export mode.

Namespace: DevExpress.XtraEditors.Repository

Assembly: DevExpress.XtraEditors.v23.2.dll

NuGet Package: DevExpress.Win.Navigation

Declaration

C#

[DefaultValue("")]
[DXCategory("Behavior")]
public string XlsxFormatString { get; set; }

VB.NET

<DXCategory("Behavior")>
<DefaultValue("")>
Public Property XlsxFormatString As String

Property Value

Type	Default	Description
String	String.Empty	A string value, representing the XLSX format string.

Remarks

A Text Editor is exported to XLSX format when it is embedded in a compound data control (e.g., GridControl, TreeList, etc.) and this data control is exported to XLSX format.

In WYSIWYG export mode, use the XlsxFormatString property to apply a native Excel format to the editor’s value.

The following list shows available format specifiers:

• 0
• 0.00
• #,##0
• #,##0.00
• #,##0_);(#,##0)
• #,##0_);[Red](#,##0)
• #,##0.00_);(#,##0.00)
• #,##0.00_);[Red](#,##0.00)
• $#,##0_);($#,##0)
• $#,##0_);[Red]($#,##0)
• $#,##0.00_);($#,##0.00)
• $#,##0.00_);[Red]($#,##0.00)
• 0%
• 0.00%
• 0.00E+00
• ##0.0E+0
• # ?/?
• # ??/??
• m/d/yyyy
• d-mmm-yy
• d-mmm
• mmm-yy
• h:mm AM/PM
• h:mm:ss AM/PM
• h:mm
• h:mm:ss
• m/d/yyyy h:mm
• mm:ss
• mm:ss.0
• @
• ($* #,##0);($* (#,##0);($* “-“);(@_)
• (* #,##0);(* (#,##0);(* “-“);(@_)
• ($* #,##0.00);($* (#,##0.00);($* “-“??);(@_)
• (* #,##0.00);(* (#,##0.00);(* “-“??);(@_)

For information on these format specifiers, refer to the following topic from the MS Excel documentation: Create or delete a custom number format.