Skip to main content

XlsxExportOptionsEx.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.v24.2.Core.dll

Declaration

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean AllowCombinedBandAndColumnHeaderCellMerge { get; set; }

Property Value

Type Default Description
DefaultBoolean Default

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 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

Remarks

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