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.v20.1.Core.dll

Declaration

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean AllowCombinedBandAndColumnHeaderCellMerge { get; set; }
<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.

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.

Implements

DevExpress.Export.IDataAwareExportOptions.AllowCombinedBandAndColumnHeaderCellMerge
See Also