Spread ASP.NET 6.0 Product Documentation
ColumnCount Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : ColumnCount Property


Glossary Item Box

Gets or sets the number of columns in the sheet.

Syntax

Visual Basic (Declaration) 
Public Overridable Property ColumnCount As Integer
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As Integer
 
instance.ColumnCount = value
 
value = instance.ColumnCount
C# 
public virtual int ColumnCount {get; set;}

Property Value

Integer number of columns in the sheet

Remarks

To get or set the number of rows in the sheet, use the RowCount property.

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.
C#Copy Code
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 BasicCopy Code
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

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.