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


In This Topic
    ColumnFooterVisible Property
    In This Topic
    Gets or sets whether the column footers are visible.
    Syntax
    'Declaration
     
    Public Property ColumnFooterVisible As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.ColumnFooterVisible = value
     
    value = instance.ColumnFooterVisible
    public bool ColumnFooterVisible {get; set;}
    Example
    This example sets the models for a column footer.
    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