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

NuGet Packages: DevExpress.Reporting.Core, DevExpress.WindowsDesktop.Reporting.Core

Declaration

C#

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

VB.NET

<SRCategory(ReportStringId.CatData)>
Public Overridable Property XlsxFormatString As String

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).