Back to Devexpress

TableColumn.Total Property

officefileapi-devexpress-dot-spreadsheet-dot-tablecolumn-4072d422.md

latest2.1 KB
Original Source

TableColumn.Total Property

Returns the cell that contains the column total.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
CellRange Total { get; }
vb
ReadOnly Property Total As CellRange

Property Value

TypeDescription
CellRange

A CellRange object.

|

Remarks

To show or hide the table total row, use the Table.ShowTotals property. If the table total row is hidden, the Total property returns null ( Nothing in Visual Basic).

A column total cell is highlighted in the following image.

To specify the content of a column total cell, use the TableColumn.TotalRowFunction, TableColumn.TotalRowFormula, TableColumn.TotalRowArrayFormula or TableColumn.TotalRowLabel property.

To access the cell range that contains the entire total row of the table, use the Table.TotalRowRange property.

See Also

Spreadsheet Tables

TableColumn Interface

TableColumn Members

DevExpress.Spreadsheet Namespace