ColumnAxisModel Property

Visual Basic
C#

'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

This property is available at run time only.

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.

C#

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)));
}

Visual Basic

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

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
RowAxisModel Property

User-Task Documentation

Understanding the Axis Model