Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property ColumnCount As Integer | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetCorner Dim value As Integer instance.ColumnCount = value value = instance.ColumnCount | |
| C# | |
|---|---|
public int ColumnCount {get; set;} | |
Exceptions
| Exception | Description |
|---|---|
| System.ArgumentOutOfRangeException | Specified column count is less than 0 or greater than 256. |
Example
This example changes certain aspects of the sheet corner.
| C# | Copy Code |
|---|---|
fpSpread1.ActiveSheet.AllowTableCorner = true; fpSpread1.ActiveSheet.SheetCorner.RowCount = 6; fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 6; fpSpread1.ActiveSheet.SheetCorner.AlternatingRows[0].BackColor = Color.Beige; fpSpread1.ActiveSheet.SheetCorner.Cells[0, 0].Text = "Test"; fpSpread1.ActiveSheet.SheetCorner.Columns[0].Border = new FarPoint.Win.LineBorder(Color.Green); fpSpread1.ActiveSheet.SheetCorner.Rows[1].Border = new FarPoint.Win.LineBorder(Color.Green); fpSpread1.ActiveSheet.SheetCorner.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None); fpSpread1.ActiveSheet.SheetCorner.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None); fpSpread1.ActiveSheet.SheetCorner.DefaultStyle.VisualStyles = FarPoint.Win.VisualStyles.Off; MessageBox.Show(fpSpread1.ActiveSheet.SheetCorner.DefaultStyleName); | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheet.AllowTableCorner = True FpSpread1.ActiveSheet.SheetCorner.RowCount = 6 FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 6 FpSpread1.ActiveSheet.SheetCorner.AlternatingRows(0).BackColor = Color.Beige FpSpread1.ActiveSheet.SheetCorner.Cells(0, 0).Text = "Test" FpSpread1.ActiveSheet.SheetCorner.Columns(0).Border = New FarPoint.Win.LineBorder(Color.Green) FpSpread1.ActiveSheet.SheetCorner.Rows(1).Border = New FarPoint.Win.LineBorder(Color.Green) FpSpread1.ActiveSheet.SheetCorner.HorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None) FpSpread1.ActiveSheet.SheetCorner.VerticalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None) FpSpread1.ActiveSheet.SheetCorner.DefaultStyle.VisualStyles = FarPoint.Win.VisualStyles.Off MsgBox(FpSpread1.ActiveSheet.SheetCorner.DefaultStyleName) | |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8