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


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