GrapeCity.Xaml.SpreadSheet.Data Namespace > TableStyle Class : LastFooterCellStyle Property |
'Declaration Public Property LastFooterCellStyle As TableStyleInfo
'Usage Dim instance As TableStyle Dim value As TableStyleInfo instance.LastFooterCellStyle = value value = instance.LastFooterCellStyle
public TableStyleInfo LastFooterCellStyle {get; set;}
//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
Target Platforms: Windows Server 2012, Windows RT