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


In This Topic
    ColumnAxisModel Property
    In This Topic
    Gets or sets the column information for the sheet.
    Syntax
    'Declaration
     
    Public Property ColumnAxisModel As ISheetAxisModel
    'Usage
     
    Dim instance As SheetView
    Dim value As ISheetAxisModel
     
    instance.ColumnAxisModel = value
     
    value = instance.ColumnAxisModel
    public ISheetAxisModel ColumnAxisModel {get; set;}

    Property Value

    ISheetAxisModel object containing the column information for the sheet
    Remarks
    This property is available at run time only.
    Example
    This example places values in all the cells and, in a button click event, returns the type of sort indicator used in the first column in a sheet with only five columns and eight rows.
    private void Page_Load(object sender, System.EventArgs e)
    {
          if (this.IsPostBack) return;
    
          FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
          int i, j;
          sv.ColumnCount = 5;
          sv.PageSize = 8;
          sv.RowCount = 8;
          for (i = 0;  i <= 7; i++)
          {
               for (j = 0; j <= 4; j++)
                    sv.SetValue(i, j, 100 + i);
               sv.SetColumnSortIndicator(j, FarPoint.Web.Spread.Model.SortIndicator.Descending);
          }
          sv.AllowSort = true;        
    }
    
    private void Button1_Click(object sender, System.EventArgs e)
    {    
             FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
             ListBox1.Items.Add(Convert.ToString(sv.ColumnAxisModel.GetSortIndicator(0)));
    }
    
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    
          If (Me.IsPostBack) Then Return
    
          Dim sv As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
          Dim i, j As Integer
          sv.ColumnCount = 5
          sv.PageSize = 8
          sv.RowCount = 8
          For i = 0 To sv.RowCount - 1
               For j = 0 To sv.ColumnCount
                    sv.SetValue(i, j, 100 + i)
                    sv.SetColumnSortIndicator(j, FarPoint.Web.Spread.Model.SortIndicator.Descending)
               Next j
          Next i
          sv.AllowSort = True
    
    End Sub
    
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
             Dim sv As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
             ListBox1.Items.Add(Convert.ToString(sv.ColumnAxisModel.GetSortIndicator(0)))
    End Sub
    
    See Also