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.v24.2.Core.dll
Declaration
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:
| Object Type | Path to Suppress256ColumnsWarning |
|---|---|
| ExportOptions |
|
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.