ColumnFooter Property (SheetView)

In This Topic

Gets the column footers for the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property ColumnFooter As ColumnFooter

'Usage
 
Dim instance As SheetView
Dim value As ColumnFooter
 
value = instance.ColumnFooter

public ColumnFooter ColumnFooter {get;}

Example

This example uses the ColumnFooter property.

FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.StyleInfo info = new FarPoint.Web.Spread.StyleInfo();
info.Border = new FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Teal, 2);
sv.ColumnFooterVisible = true;
sv.ColumnFooterHeight = 100;
sv.ColumnFooter.Rows.Count = 3;
sv.ColumnFooterSpanModel.Add(0, 0, 2, 2);
sv.ColumnFooterStyleModel.SetDirectInfo(0, 0, info);
sv.ColumnFooterRowAxisModel.SetSize(0, 50);
ListBox1.Items.Add(sv.ColumnFooterDataModel.ColumnCount.ToString());
ListBox1.Items.Add(sv.ColumnFooterDataModel.RowCount.ToString());

VB.NET

Dim sv As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
Dim info As New FarPoint.Web.Spread.StyleInfo()
info.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, System.Drawing.Color.Teal, 2)
sv.ColumnFooterVisible = True
sv.ColumnFooterHeight = 100
sv.ColumnFooter.Rows.Count = 3
sv.ColumnFooterSpanModel.Add(0, 0, 2, 2)
sv.ColumnFooterStyleModel.SetDirectInfo(0, 0, info)
sv.ColumnFooterRowAxisModel.SetSize(0, 50)
ListBox1.Items.Add(sv.ColumnFooterDataModel.ColumnCount.ToString())
ListBox1.Items.Add(sv.ColumnFooterDataModel.RowCount.ToString())

Reference

SheetView Class
SheetView Members

Product Support Forum | Print this page