XlsExportOptionsEx.ApplyFormattingToEntireColumn Property

Gets or sets whether cell formatting (cell appearance and borders) is applied to the entire sheet columns (faster) or individual sheet cells in the range of exported rows (slower). Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

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

Declaration

[DefaultValue(DefaultBoolean.True)]
public DefaultBoolean ApplyFormattingToEntireColumn { get; set; }
<DefaultValue(DefaultBoolean.True)>
Public Property ApplyFormattingToEntireColumn As DefaultBoolean

Property Value

Type Default Description
DefaultBoolean

True

A value that specifies whether cell formatting is applied to entire sheet columns or to individual sheet cells within the range of exported rows. The DefaultBoolean.Default value is equivalent to True.

Remarks

In a WinForms Data Grid, you can customize the appearance of cells within a single column with the GridColumn.AppearanceCell property. The ApplyFormattingToEntireColumn option specifies how these column appearance settings are applied to sheet cells in the exported document.

If the ApplyFormattingToEntireColumn property is set to Default or True, the appearance settings are applied to entire columns in the output worksheet, which is faster for large record sets. Sheet cells that are beyond the range of exported data are also formatted using the specified appearance settings and they get cell borders.

DataAwareExport-ApplyFormattingToEntireColumn-True

If the ApplyFormattingToEntireColumn property is set to False, the appearance settings are applied to each sheet cell within the range of exported rows, which is slower for large record sets. Appearance and borders of sheet cells that are beyond the range of exported data is not affected.

DataAwareExport-ApplyFormattingToEntireColumn-False

NOTE

When data is exported from Advanced Banded Grid Views (these Views allow columns to be arranged one under another), the ApplyFormattingToEntireColumn setting is forcibly set to False and it cannot be changed.

Implements

DevExpress.Export.IDataAwareExportOptions.ApplyFormattingToEntireColumn
See Also