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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

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

VB.NET

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

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
There are two distinct Photo headers.	Photo headers are merged into a single cell.