Gets or sets the number of rows in the column footers for the sheet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property ColumnFooterRowCount As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As Integer
instance.ColumnFooterRowCount = value
value = instance.ColumnFooterRowCount |
| C# | |
|---|
public int ColumnFooterRowCount {get; set;} |
Exceptions
Example
This example creates a column footer.
| C# | Copy Code |
|---|
fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooterVisible = true;
fpSpread1.Sheets[0].ColumnFooterRowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();
FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Crimson, Color.Goldenrod, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterHorizontalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterVerticalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterSheetCornerHorizontalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterSheetCornerVerticalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood); |
| Visual Basic | Copy Code |
|---|
FpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 15
FpSpread1.Sheets(0).ColumnFooterVisible = True
FpSpread1.Sheets(0).ColumnFooterRowCount = 2
FpSpread1.Sheets(0).ColumnFooter.DefaultStyle.Renderer = New FarPoint.Win.Spread.CellType.ColumnHeaderRenderer()
Dim gl As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Crimson, Color.Goldenrod, Color.BurlyWood)
FpSpread1.Sheets(0).ColumnFooterHorizontalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
FpSpread1.Sheets(0).ColumnFooterVerticalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood)
FpSpread1.Sheets(0).ColumnFooterSheetCornerHorizontalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
FpSpread1.Sheets(0).ColumnFooterSheetCornerVerticalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
