Spread Silverlight Documentation
BandedColumns Property
Example 


Gets or sets a value that indicates whether to display an alternating column style.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property BandedColumns As System.Boolean
'Usage
 
Dim instance As SheetTable
Dim value As System.Boolean
 
instance.BandedColumns = value
 
value = instance.BandedColumns
[System.ComponentModel.DefaultValue()]
public System.bool BandedColumns {get; set;}
Example
This example creates a table.
//Add data
for (var col = 1; col < 6; col++) {
    for (var row = 2; row < 11; row++) {
        GcSpreadSheet1.Sheets[0].SetValue(row, col, row + col);
    }
}

var sTable = GcSpreadSheet1.Sheets[0].AddTable("table1", 1, 1, 10, 5, GrapeCity.Windows.SpreadSheet.Data.TableStyles.Medium2);
sTable.BandedColumns = true;
sTable.BandedRows=true;
'Add data
For col As Integer = 1 To 5
    For row As Integer = 2 To 10
        GcSpreadSheet1.Sheets(0).SetValue(row, col, row + col)
    Next
Next

Dim sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, GrapeCity.Windows.SpreadSheet.Data.TableStyles.Medium2)
sTable.BandedColumns = True
sTable.BandedRows = True
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

SheetTable Class
SheetTable Members

 

 


Copyright © GrapeCity, inc. All rights reserved.