Skip to main content

PivotGridControl.ExpandAllColumnsAsync() Method

Expands all columns asynchronously.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

public Task<bool> ExpandAllColumnsAsync()

Returns

Type Description
Task<Boolean>

An asynchronous operation that returns true in case of success.

Remarks

The ExpandAllColumnsAsync method is asynchronous. ExpandAllColumnsAsync starts to execute the related operation in a background thread, and returns the Pivot Grid control. The main UI thread remains unblocked to allow the application to continue responding to user actions. Refer to the following topic for more information: Asynchronous Mode.

Use the following methods to collapse or expand Pivot Grid columns:

CollapseAllColumnsAsync
Collapses all columns asynchronously.
ExpandAllColumns
Expands all columns.
CollapseAllColumns
Collapses all columns.

Use the following methods to collapse or expand Pivot Grid rows:

ExpandAllRowsAsync
Expands all rows asynchronously.
CollapseAllRowsAsync
Collapses all rows asynchronously.
ExpandAllRows()
Expands all rows.
CollapseAllRows
Collapses all rows.

You can specify whether a user can expand or collapse field values in the UI. For this, use the PivotGridFieldOptions.AllowExpand property.

Example

The following example shows how to expand all columns in the Pivot Grid asynchronously. The image below displays the resulting Pivot Grid with expanded columns for the Country and City fields.

Pivot Grid with expanded columns

using DevExpress.XtraPivotGrid;
using System.Windows.Forms;

namespace WindowsFormsApp2 {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
            pivotGridControl1.OptionsBehavior.UseAsyncMode = true;
            ConfigureLayout();
        }
        async void ConfigureLayout() {
            pivotGridControl1.BeginUpdate();
            // Create and configure Pivot Grid fields
            PivotGridField fieldCountry = pivotGridControl1.Fields.Add("Country", PivotArea.ColumnArea);
            fieldCountry.DataBinding = new DataSourceColumnBinding("[Customer].[Country].[Country]");
            fieldCountry.Name = "fieldCountry";

            PivotGridField fieldCity = pivotGridControl1.Fields.Add("City", PivotArea.ColumnArea);
            fieldCity.DataBinding = new DataSourceColumnBinding("[Customer].[City].[City]");
            fieldCity.Name = "fieldCity";
            // ...
            await pivotGridControl1.EndUpdateAsync();

            await pivotGridControl1.ExpandAllColumnsAsync();
        }
    }
}
See Also