Category / Section
How to search for and return the row and column indices of the subtotal rows
1 min read
We would like to inform you that, you can get the row and column index of all the cells using the below workaround including subtotal row.
The CellClick event of PivotGrid’s InternalGrid has the row and column index of the cell, which we click on it.
C#
void pivotGrid1_Loaded(object sender, RoutedEventArgs e) { this.pivotGrid1.ShowSubTotals = false; this.pivotGrid1.InternalGrid.CellClick += new Syncfusion.Windows.Controls.Grid.GridCellClickEventHandler(InternalGrid_CellClick); } void InternalGrid_CellClick(object sender, Syncfusion.Windows.Controls.Grid.GridCellClickEventArgs e) { MessageBox.Show("Row Index ="+ e.RowIndex + "& Column Index =" + e.ColumnIndex); }
Figure: Pivot Grid with pop up window showing row and column indices