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

NuGet Package : DevExpress.Printing.Core

Declaration

csharp

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

<DefaultValue(DefaultBoolean.Default)>
Public Property AllowCombinedBandAndColumnHeaderCellMerge As DefaultBoolean

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

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

Source Data Grid	Exported Document

There are two distinct Photo headers.	Photo headers are merged into a single cell.