GrapeCity.Xaml.SpreadSheet.Data
FirstFooterCellStyle Property
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > TableStyle Class : FirstFooterCellStyle Property
The style of the first footer cell.
Syntax
'Declaration
 
Public Property FirstFooterCellStyle As TableStyleInfo
'Usage
 
Dim instance As TableStyle
Dim value As TableStyleInfo
 
instance.FirstFooterCellStyle = value
 
value = instance.FirstFooterCellStyle
public TableStyleInfo FirstFooterCellStyle {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);
    }
}

GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo tablestyle = new GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo();
tablestyle.Background = new SolidColorBrush(Windows.UI.Colors.Azure); 
tablestyle.BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Purple);
tablestyle.BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkGray);
tablestyle.BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick);
tablestyle.BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick);

GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo tablestylerow = new GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo();
tablestylerow.BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick);
tablestylerow.Background = new SolidColorBrush(Windows.UI.Colors.Green);

GrapeCity.Xaml.SpreadSheet.Data.TableStyle testtable = new GrapeCity.Xaml.SpreadSheet.Data.TableStyle();
testtable.WholeTableStyle = tablestyle;
testtable.FirstFooterCellStyle = tablestylerow;
testtable.LastFooterCellStyle = tablestylerow;

var sTable = GcSpreadSheet1.Sheets[0].AddTable("table1", 1, 1, 10, 5, testtable);
sTable.ShowFooter = true;
//set footer value
sTable.SetColumnName(0, "Total");
//set footer formula
sTable.SetColumnFormula(4, "SUM(F3:F11)");
sTable.HighlightFirstColumn = true;
sTable.HighlightLastColumn = 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 tablestyle As New GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo()
tablestyle.Background = New SolidColorBrush(Windows.UI.Colors.Azure)
tablestyle.BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Purple)
tablestyle.BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkGray)
tablestyle.BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick)
tablestyle.BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick)

Dim tablestylerow As New GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo()
tablestylerow.BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick)
tablestylerow.Background = New SolidColorBrush(Windows.UI.Colors.Green)

Dim testtable As New GrapeCity.Xaml.SpreadSheet.Data.TableStyle()
testtable.WholeTableStyle = tablestyle
testtable.FirstFooterCellStyle = tablestylerow
testtable.LastFooterCellStyle = tablestylerow
Dim sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, testtable)
sTable.ShowFooter = True
'set footer value
sTable.SetColumnName(0, "Total")
'set footer formula
sTable.SetColumnFormula(4, "SUM(F3:F11)")
sTable.HighlightFirstColumn = True
sTable.HighlightLastColumn = True
See Also

Reference

TableStyle Class
TableStyle Members