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.v25.2.dll

NuGet Package : DevExpress.Win.Navigation

Declaration

• C#
• VB.NET

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

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

Property Value

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.00_);(#,##0.00)
• #,##0.00_);Red
• $#,##0_);($#,##0)
• $#,##0_);Red
• $#,##0.00_);($#,##0.00)
• $#,##0.00_);Red
• 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

RepositoryItemTextEdit Class

RepositoryItemTextEdit Members

DevExpress.XtraEditors.Repository Namespace