Spread Silverlight Documentation
ShowFooter Property
Example 


Gets or sets a value that indicates whether to display a footer.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property ShowFooter As System.Boolean
'Usage
 
Dim instance As SheetTable
Dim value As System.Boolean
 
instance.ShowFooter = value
 
value = instance.ShowFooter
[System.ComponentModel.DefaultValue()]
public System.bool ShowFooter {get; set;}
Example
This example sets the ShowFooter 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.