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.v19.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 |
|---|---|
| True | Corresponds to a Boolean value of true. |
| False | Corresponds to a Boolean value of false. |
| Default | The value is determined by the current object’s parent object setting (e.g., a control setting). |
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. |
See Also