Spread Silverlight Documentation
HighlightFirstColumn Property
Example 


Gets or sets a value that indicates whether to highlight the first column.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property HighlightFirstColumn As System.Boolean
'Usage
 
Dim instance As SheetTable
Dim value As System.Boolean
 
instance.HighlightFirstColumn = value
 
value = instance.HighlightFirstColumn
[System.ComponentModel.DefaultValue()]
public System.bool HighlightFirstColumn {get; set;}
Example
This example sets the HighlightFirstColumn property.
gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "Last Name";
gcSpreadSheet1.Sheets[0].Cells[1, 2].Text = "Value";
gcSpreadSheet1.Sheets[0].Cells[2, 1].Text = "Smith";
gcSpreadSheet1.Sheets[0].Cells[2, 2].Value = 50;
gcSpreadSheet1.Sheets[0].Cells[3, 1].Text = "Vil";
gcSpreadSheet1.Sheets[0].Cells[3, 2].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[4, 1].Text = "Press";
gcSpreadSheet1.Sheets[0].Cells[4, 2].Value = 78;
gcSpreadSheet1.Sheets[0].AddTable("Table1", 1, 1, 5, 2);  

GrapeCity.Windows.SpreadSheet.Data.SheetTable ntable = new GrapeCity.Windows.SpreadSheet.Data.SheetTable();
ntable = gcSpreadSheet1.Sheets[0].FindTable("Table1");
ntable.ShowFooter = true;
ntable.HighlightFirstColumn = true;
gcSpreadSheet1.Sheets[0].MoveTable(ntable, 3, 3);
GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "Last Name"
GcSpreadSheet1.Sheets(0).Cells(1, 2).Text = "Value"
GcSpreadSheet1.Sheets(0).Cells(2, 1).Text = "Smith"
GcSpreadSheet1.Sheets(0).Cells(2, 2).Value = 50
GcSpreadSheet1.Sheets(0).Cells(3, 1).Text = "Vil"
GcSpreadSheet1.Sheets(0).Cells(3, 2).Value = 10
GcSpreadSheet1.Sheets(0).Cells(4, 1).Text = "Press"
GcSpreadSheet1.Sheets(0).Cells(4, 2).Value = 78
GcSpreadSheet1.Sheets(0).AddTable("Table1", 1, 1, 5, 2)

Dim ntable As New GrapeCity.Windows.SpreadSheet.Data.SheetTable()
ntable = GcSpreadSheet1.Sheets(0).FindTable("Table1")
ntable.ShowFooter = True
ntable.HighlightFirstColumn = True
GcSpreadSheet1.Sheets(0).MoveTable(ntable, 3, 3)
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.