Spread Windows Forms 11.0 Product Documentation
TotalCellStyle Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > TableViewColumn Class : TotalCellStyle Property
Gets or sets the style in the total cell of the table.
Syntax
'Declaration
 
Public Property TotalCellStyle As StyleInfo
'Usage
 
Dim instance As TableViewColumn
Dim value As StyleInfo
 
instance.TotalCellStyle = value
 
value = instance.TotalCellStyle
public StyleInfo TotalCellStyle {get; set;}
Example
This example sets a style for a cell in the total row.
fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith";
fpSpread1.Sheets[0].Cells[2, 2].Value = 50;
fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil";
fpSpread1.Sheets[0].Cells[3, 2].Value = 10;
fpSpread1.Sheets[0].Cells[4, 1].Text = "Press";
fpSpread1.Sheets[0].Cells[4, 2].Value = 78;
FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2);
table.TotalRowVisible = true;
FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo();
si.BackColor = Color.LightYellow;
si.ForeColor = Color.Gray;
table.TableColumns[0].TotalCellStyleName = "Style1";
table.TableColumns[0].TotalCellStyle = si;
fpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name"
fpSpread1.Sheets(0).Cells(1, 2).Text = "Value"
fpSpread1.Sheets(0).Cells(2, 1).Text = "Smith"
fpSpread1.Sheets(0).Cells(2, 2).Value = 50
fpSpread1.Sheets(0).Cells(3, 1).Text = "Vil"
fpSpread1.Sheets(0).Cells(3, 2).Value = 10
fpSpread1.Sheets(0).Cells(4, 1).Text = "Press"
fpSpread1.Sheets(0).Cells(4, 2).Value = 78
Dim table As FarPoint.Win.Spread.TableView = fpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2)
table.TotalRowVisible = True
Dim si As New FarPoint.Win.Spread.StyleInfo
si.BackColor = Color.LightYellow
si.ForeColor = Color.Gray
table.TableColumns(0).TotalCellStyleName = "Style1"
table.TableColumns(0).TotalCellStyle = si
See Also

Reference

TableViewColumn Class
TableViewColumn Members