PivotGridCells.SetSelectionByFieldValues(Boolean, Object[], PivotGridFieldBase) Method

Selects cells that reside within the specified column or row, identified by the specified data field.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public void SetSelectionByFieldValues(
    bool isColumn,
    object[] values,
    PivotGridFieldBase dataField
)

VB.NET

Public Sub SetSelectionByFieldValues(
    isColumn As Boolean,
    values As Object(),
    dataField As PivotGridFieldBase
)

Parameters

Name	Type	Description
isColumn	Boolean	true to select cells within a column; false to select cells within a row.
values	Object[]	An array of field values that identifies the column or row that should be selected.
dataField	PivotGridFieldBase	A PivotGridFieldBase descendant. Specifies a data field that identifies the column or row that should be selected.

Remarks

If the specified field value array identifies several columns, the SetSelectionByFieldValues method selects all of them.

Use the null (Nothing in Visual Basic) value to identify the Grand Total column or row.

Consider the following pivot grid.

The table below demonstrates how to use the SetSelectionByFieldValues method to select columns and rows.

C#	Visual Basic	Selected Column(s)
pivotGridControl.Cells.SetSelectionByFieldValues(true, new object[] {1994, 8}, fieldUnitPrice);	pivotGridControl.Cells.SetSelectionByFieldValues(True, New Object() {1994, 8}, fieldUnitPrice)	0
pivotGridControl.Cells.SetSelectionByFieldValues(true, new object[] {1994, 8}, fieldQuantity);	pivotGridControl.Cells.SetSelectionByFieldValues(True, New Object() {1994, 8}, fieldQuantity)	3
pivotGridControl.Cells.SetSelectionByFieldValues(true, new object[] {1994}, fieldUnitPrice);	pivotGridControl.Cells.SetSelectionByFieldValues(True, New Object() {1994}, fieldUnitPrice)	0 - 2
pivotGridControl.Cells.SetSelectionByFieldValues(true, new object[] {}, fieldQuantity);	pivotGridControl.Cells.SetSelectionByFieldValues(True, New Object() {}, fieldQuantity)	3 - 5
pivotGridControl.Cells.SetSelectionByFieldValues(true, new object[] {null}, fieldQuantity);	pivotGridControl.Cells.SetSelectionByFieldValues(True, New Object() {Nothing}, fieldQuantity)	7