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


In This Topic
    ColumnFooterSpanModel Property
    In This Topic
    Gets or sets the spanned cells for the column footer.
    Syntax
    'Declaration
     
    Public Property ColumnFooterSpanModel As ISheetSpanModel
    'Usage
     
    Dim instance As SheetView
    Dim value As ISheetSpanModel
     
    instance.ColumnFooterSpanModel = value
     
    value = instance.ColumnFooterSpanModel
    public ISheetSpanModel ColumnFooterSpanModel {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