DisplayBandedRows Property

Gets or sets the value which indicates whether the alternate row format should be applied to the appropriate rows of the WorksheetTable.

Syntax

Visual Basic

'Declaration
 
Public Property DisplayBandedRows As Boolean

C#

public bool DisplayBandedRows {get; set;}

Remarks

The row formats are defined by the WorksheetTableStyle applied to the WorksheetTable. These are stored in the WorksheetTableStyle.AreaFormats collection and keyed by the WorksheetTableStyleArea.RowStripe and WorksheetTableStyleArea.AlternateRowStripe values. If there is no area format applied for the AlternateRowStripe value, this property has no effect on the display of the table.

If this value is True and there is an area format for the alternate row stripe, the stripe widths are defined by the WorksheetTableStyle.RowStripeHeight and WorksheetTableStyle.AlternateRowStripeHeight values.

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