TableColumn.TotalRowFormula Property
Gets or sets the formula to calculate the total of the table column.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| String | A string that is the formula contained in the total cell of the table column. |
Remarks
You can specify how to calculate a total for each column in the table. To do this, use the following properties.
- TableColumn.TotalRowFunction - allows you to select one of the predefined functions to calculate the column total.
TableColumn.TotalRowFormula- allows you to specify any formula to calculate the column total.- TableColumn.TotalRowArrayFormula - allows you to specify an array formula to calculate the column total.
- TableColumn.TotalRowLabel - allows you to specify the text to be displayed in the total cell of the table column.
Use the Table.ShowTotals property to control the visibility of the table total row.
See Also