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.v20.1.dll

Declaration

[DXCategory("Behavior")]
[DefaultValue("")]
public string XlsxFormatString { get; set; }
<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.

See Also