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


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