PivotGridOptionsBehaviorBase.ClipboardCopyCollapsedValuesMode Property

Gets or sets how to copy collapsed field values to the Clipboard.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v19.2.Core.dll

Declaration

[DefaultValue(CopyCollapsedValuesMode.PreserveCollapsedLevels)]
public CopyCollapsedValuesMode ClipboardCopyCollapsedValuesMode { get; set; }
<DefaultValue(CopyCollapsedValuesMode.PreserveCollapsedLevels)>
Public Property ClipboardCopyCollapsedValuesMode As CopyCollapsedValuesMode

Property Value

Type Default Description
CopyCollapsedValuesMode

PreserveCollapsedLevels

A CopyCollapsedValuesMode enumeration value that specifies how to copy collapsed field values to the Clipboard.

Remarks

PivotGridControl allows end-users to copy contents of the selected cells to the Clipboard by pressing CTRL+C or CTRL+INS. You can optionally copy field values as well by setting the PivotGridOptionsBehaviorBase.CopyToClipboardWithFieldValues property to true.

The ClipboardCopyCollapsedValuesMode property allows you to specify how to copy collapsed field values. They can be replaced with duplicates of their parent values or empty cells. You can also disable copying collapsed field values to the Clipboard.

For instance, consider the following pivot grid.

Clipboard_CollapsedFieldValues

The ClipboardCopyCollapsedValuesMode property allows you to select one of the following modes.

The ClipboardCopyCollapsedValuesMode property is not in effect if copying field values to the Clipboard is disabled via the PivotGridOptionsBehaviorBase.CopyToClipboardWithFieldValues property.

See Also