corelibraries-devexpress-dot-xtraprinting-dot-xlsexportoptionsex-9a14bfa2.md
Gets or sets whether cell formatting (cell appearance and borders) is applied to entire sheet columns or individual sheet cells. Formatting algorithms applied to sheet columns are faster than those applied to individual cells. Only available in data-aware export mode.
Namespace : DevExpress.XtraPrinting
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
[DefaultValue(DefaultBoolean.True)]
public DefaultBoolean ApplyFormattingToEntireColumn { get; set; }
<DefaultValue(DefaultBoolean.True)>
Public Property ApplyFormattingToEntireColumn As DefaultBoolean
| 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.
|
Available values:
| Name | Description | Return Value |
|---|---|---|
| True |
The value is true.
|
0
| | False |
The value is false.
|
1
| | Default |
The value is specified by a global option or a higher-level object.
|
2
|
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.
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.
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.
See Also