Spread Windows Forms 8.0 Product Documentation
Columns Property (SheetCorner)
Example 


Gets a Columns object for the columns in the sheet corner.
Syntax
'Declaration
 
Public ReadOnly Property Columns As Columns
'Usage
 
Dim instance As SheetCorner
Dim value As Columns
 
value = instance.Columns
public Columns Columns {get;}
Example
This example changes certain aspects of the sheet corner.
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);
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

See Also

Reference

SheetCorner Class
SheetCorner Members

 

 


Copyright © GrapeCity, inc. All rights reserved.