Skip to main content

XRControl.XlsxFormatString Property

Specifies the native Excel format to be imported to the control’s content after the report is exported to an Excel file (XLS or XLSX).

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v24.1.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

[SRCategory(ReportStringId.CatData)]
public virtual string XlsxFormatString { get; set; }

Property Value

Type Description
String

A string value, representing the XLSX format string.

Remarks

The XlsxFormatString property is available for the XRLabel control only, to support the Excel format string, which is applied to a cell when the report is being exported to XLS or XLSX (the Microsoft Office® native format).

Note

The XlsxFormatString property is in effect only when the report’s XlExportOptionsBase.TextExportMode property is set to Value.

The XlsxFormatString property works independently from the XRBinding.FormatString and XRSummary.FormatString properties, to allow simultaneous application of both the .NET and native Excel formats. And, in contrast to these two properties, the XlsxFormatString property can also be applied to static content (that is, when the control isn’t bound to a data field).

Not all descendants of the XRControl class use the XlsxFormatString property (for example, the Band class descendants ignore this property).

See Also