A newer version of this page is available. Switch to the current version.

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

Declaration

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

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