PivotGridFieldBase.ExpandValue(Object) Method

Expands the column/row that contains the specified value.

Namespace: DevExpress.XtraPivotGrid

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

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

Declaration

C#

public void ExpandValue(
    object value
)

VB.NET

Public Sub ExpandValue(
    value As Object
)

Parameters

Name	Type	Description
value	Object	An object which specifies the value in the grouping column/row that should be expanded.

Remarks

When the current field is placed within the Column Header Area the ExpandValue method expands the grouping column which corresponds to the current field that contains the specified value.

When the field is placed within the Row Header Area the ExpandValue method expands the grouping row that contains the specified value.

To expand all grouping rows/columns which correspond to the current field use the PivotGridFieldBase.ExpandAll method.

Grouping rows/columns which correspond to a field can be collapsed and expanded by end-users if the field’s PivotGridFieldOptions.AllowExpand and control’s PivotGridFieldOptions.AllowExpand properties are set to True.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExpandValue(Object) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-customize-pivot-grid-data-before-displaying-it-in-a-chart-control/CS/Form1.cs#L49

    fieldCategoryName.CollapseAll();
    fieldCategoryName.ExpandValue("Produce");
}

VB.NET

winforms-customize-pivot-grid-data-before-displaying-it-in-a-chart-control/VB/Form1.vb#L53

    fieldCategoryName.CollapseAll()
    fieldCategoryName.ExpandValue("Produce")
End Sub