Articles in this section
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); 
}
 

 

C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-06 11.14.49.png

Figure: Pivot Grid with pop up window showing row and column indices

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied