Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / ColumnFooter Property
Example


In This Topic
    ColumnFooter Property (SheetView)
    In This Topic
    Gets the column footers for the sheet.
    Syntax
    '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());
    
    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())
    See Also