The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

TableColumn.Total Property

Gets the cell that contains the column total.

Namespace: DevExpress.Spreadsheet

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

Declaration

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

Property Value

Type Description
CellRange

A CellRange object.

Property Value

Type Description
CellRange

A CellRange object.

Property Value

Type Description
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.

SpreadsheetControl_TableColumn_Total

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