A newer version of this page is available. Switch to the current version.

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

Declaration

[XtraSerializableProperty]
[DefaultValue(DefaultBoolean.Default)]
[TypeConverter(typeof(DefaultBooleanConverter))]
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
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