How to create cell double click event
We can collapse column/row by passing unique text of the expander header. Hence we should pass all the column headers to collapse entire column headers.
C#
List<string> columnHeaders = new List<string> { "Australia", "Canada", "France" }; ////List of string header which are belongs to Country (Which is added in pivot columns) group. pivotGridControl1.CollapseColumn(columnHeaders); //// Collapse the given headers at pivot grid control. pivotGridControl1.CollapseColumn("Australia");////Collapses only the Australia which is belongs to Country ((Which is added in pivot columns) group. List<string> rowHeaders = new List<string> { "Bike", "Car" }; ////List of string header which are belongs to Product (Which is added in pivot rows) group. pivotGridControl1.CollapseRow(rowHeaders);////Collapses the both Bike and Car. pivotGridControl1.CollapseRow("Bike");////Collapses only the Bike which is belongs to Product ((Which is added in pivot rows) group.
|
Figure: Pivot Grid shows all columns collapsed
Figure: Pivot Grid shows all Columns Expanded