Skip to main content

PivotGridOptionsPrint.MergeColumnFieldValues Property

Gets or sets whether the values of outer column fields are merged when a pivot grid is printed.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

[TypeConverter(typeof(BooleanTypeConverter))]
[XtraSerializableProperty]
public bool MergeColumnFieldValues { get; set; }

Property Value

Type Description
Boolean

true if the values of outer column fields are merged; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to MergeColumnFieldValues
PivotGridControl
.OptionsPrint .MergeColumnFieldValues

Remarks

If this property is set to true, the field values of outer column fields are merged when a pivot grid is printed (in the same way as the outer field values are displayed in the control on a form). Otherwise, merged cells are split into small cells and an empty cell duplicates the original cell’s value.

PivotGrid-Print-MergeColumnFieldValues

The MergeColumnFieldValues property is used to customize the Pivot Grid’s export settings in WYSIWYG export mode. This property is not in effect in data-aware export mode. To apply the same settings in data-aware mode, customize the control’s PivotXlsExportOptions or PivotXlsxExportOptions export settings as in the example below.

Use the PivotGridOptionsPrint.MergeRowFieldValues property to specify whether to merge the outer row field values.

Example

WYSIWYG Mode

The following example illustrates how to disable merged values of outer column fields in the exported Excel document. Use the ExportType property to enable the WYSIWYG export mode and set the MergeColumnFieldValues property to false.

private void btnExportToWYSIWYG_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e){
    PivotXlsxExportOptions pivotExportOptions = new DevExpress.XtraPivotGrid.PivotXlsxExportOptions();
    pivotExportOptions.ExportType = DevExpress.Export.ExportType.WYSIWYG;
    pivotGridControl1.OptionsPrint.MergeColumnFieldValues = false;
    var path = "D:/temp/pivot-grid-data.xlsx";
    pivotGridControl1.ExportToXlsx(path, pivotExportOptions);
}

Data-Aware Mode

When you export data in Excel format, the exporting mechanism does not duplicate values of outer column fields for each child field value in the exported document. To duplicate field value for every empty cell of outer column fields, handle the PivotXlsExportOptions.CustomizeCell event and fill empty cells with the values, as illustrated in the code snippet below. The resulting table looks similar to the table exported in the WYSIWYG mode with the disabled MergeColumnFieldValues property.

private void btnExportToDataAware_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
    PivotXlsxExportOptions options = new PivotXlsxExportOptions();
    options.CustomizeCell += options_CustomizeCell;
    options.ExportType = DevExpress.Export.ExportType.DataAware;
    options.AllowCellMerge = DevExpress.Utils.DefaultBoolean.False;
    string path = "D:/temp/pivot-grid-data.xlsx";
    pivotGridControl1.ExportToXlsx(path, options);
}
void options_CustomizeCell(CustomizePivotCellEventArgs e) {
    if (e.ExportArea == PivotExportArea.Column && e.ValueItemInfo.Field != null 
    && e.Value == null && e.ValueItemInfo.Value != null) { 
        e.Value = e.ValueItemInfo.Field.GetValueText(e.ValueItemInfo.Value);
        e.Handled = true;
    }
}
See Also