DisplayBandedColumns Property

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

Syntax

Visual Basic

'Declaration
 
Public Property DisplayBandedColumns As Boolean

C#

public bool DisplayBandedColumns {get; set;}

Remarks

The column formats are defined by the WorksheetTableStyle applied to the WorksheetTable. These are stored in the WorksheetTableStyle.AreaFormats collection and keyed by the WorksheetTableStyleArea.ColumnStripe and WorksheetTableStyleArea.AlternateColumnStripe values. If there is no area format applied for the AlternateColumnStripe 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 column stripe, the stripe widths are defined by the WorksheetTableStyle.ColumnStripeWidth and WorksheetTableStyle.AlternateColumnStripeWidth 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