XlsExportOptions.Suppress256ColumnsWarning Property

Gets or sets a value indicating whether to suppress the exception that raises when trying to export a document to an XLS file with more than 256 columns.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v20.2.Core.dll

Declaration

[DefaultValue(false)]
public bool Suppress256ColumnsWarning { get; set; }
<DefaultValue(False)>
Public Property Suppress256ColumnsWarning As Boolean

Property Value

Type Default Description
Boolean

false

true, to suppress the exception and reduce the number of columns in the resulting XLS file; false, to cancel the export and fire the exception.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to Suppress256ColumnsWarning
Cross-Platform Class Library RemotePrintingSystem
.ExportOptions.Xls.Suppress256ColumnsWarning
ExportOptions
.Xls.Suppress256ColumnsWarning
PrintingSystemBase
.ExportOptions.Xls.Suppress256ColumnsWarning
WinForms Controls PrintingSystem
.ExportOptions.Xls.Suppress256ColumnsWarning
XtraSchedulerReport
.ExportOptions.Xls.Suppress256ColumnsWarning
WPF Controls ExportOptionsContainer
.Xls.Suppress256ColumnsWarning
PrintingSystem
.ExportOptions.Xls.Suppress256ColumnsWarning
PrintingSystem
.ExportOptions.Xls.Suppress256ColumnsWarning
Reporting XtraReport
.ExportOptions.Xls.Suppress256ColumnsWarning
DocumentOperationRequest
.ExportOptions.Xls.Suppress256ColumnsWarning

Remarks

Versions of MS Excel prior to 2007 cannot display more than 256 columns. If the resulting XLS file exceeds this format's limitation, the export process depends on the Suppress256ColumnsWarning option:

  • If this option is set to false (the default value), the export operation is canceled and the following exception message is displayed:

    "The created XLS file is too big for the XLS format, because it contains more than 256 columns. Please try to use the XLSX format, instead."

  • If this option is set to true, the exception does not raise, and the document is silently exported to XLS, but only first 256 columns are included into the resulting file.
NOTE

If your document is targeted for MS Excel 2007, export it to the XLSX format (the special MS Excel 2007 format) instead. In this format, the number of rows and columns permitted has been significantly increased in comparison with XLS. For more information, refer to Export to XLSX.

See Also