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
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 Basic | Copy 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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
