IsTotalsRowVisible Property

Gets or sets the value which indicates whether the row containing column totals should be displayed.

Syntax

Visual Basic

'Declaration
 
Public Property IsTotalsRowVisible As Boolean

C#

public bool IsTotalsRowVisible {get; set;}

Property Value

True if the row containing column totals is visible; False if it is hidden.

Exceptions

Exception	Description
System.InvalidOperationException	The value is set to True and the table occupies the last row of the worksheet.

Remarks

When the totals row is visible, the cell below each column of data will contain either a calculated value, a text value, or nothing. To display a calculated value in the cell, set the WorksheetTableColumn.TotalFormula. To display a text label, set the WorksheetTableColumn.TotalLabel. If both are set, the calculated value takes precedence.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2