2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
Customize the summary row or columnTo customize the summary row descriptor to summarize the specific rows, you can use the QueryCellStyleInfo. The reported scenario is achieved by customizing the SummaryFieldCell. C# void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e) { switch (e.TableCellIdentity.TableCellType) { case GridTableCellType.SummaryFieldCell: { if(e.TableCellIdentity.SummaryColumn.Name == "Data1") { e.Style.CellType = GridCellTypeName.FormulaCell; e.Style.CellValue = "=SUM(B2:B5)"; //To summarize specific rows(First three rows) } break; } } } VB Private Sub gridGroupingControl1_QueryCellStyleInfo(ByVal sender As Object, ByVal e As GridTableCellStyleInfoEventArgs) Select Case e.TableCellIdentity.TableCellType Case GridTableCellType.SummaryFieldCell If e.TableCellIdentity.SummaryColumn.Name = "Data1" Then e.Style.CellType = GridCellTypeName.FormulaCell e.Style.CellValue = "=SUM(B2:B5)" 'To summarize specific rows(First three rows) End If Exit Select End Select End Sub In the sample, Summary is calculated for first three rows. Figure 1: Summary calculated for first three rows Samples: |
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.