A newer version of this page is available. Switch to the current version.

XlsExportOptionsEx.AllowCombinedBandAndColumnHeaderCellMerge Property

Gets or sets whether the headers of the same name are exported as merged cells. Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

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


public DefaultBoolean AllowCombinedBandAndColumnHeaderCellMerge { get; set; }

Property Value

Type Default Description


DefaultBoolean.True to export the headers of the same name as merged cells; DefaultBoolean.Default when unspecified and DefaultBoolean.False to not allow header cells to merge.

Available values:

Name Description

Corresponds to a Boolean value of true.


Corresponds to a Boolean value of false.


The value is determined by the current object’s parent object setting (e.g., a control setting).


The following pictures illustrate the effect of the AllowCombinedBandAndColumnHeaderCellMerge property set to DefaultBoolean.True.

Source Data Grid Exported Document
xl_export_options_AllowCombinedBandAndColumnHeaderCellMerge_source xl_export_options_AllowCombinedBandAndColumnHeaderCellMerge_true
There are two distinct Photo headers. Photo headers are merged into a single cell.
See Also