Spread Windows Forms 8.0 Product Documentation
AllowTableCorner Property
Example 


Gets or sets whether the sheet corner can have a grid structure (table).
Syntax
'Declaration
 
Public Property AllowTableCorner As Boolean
'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.AllowTableCorner = value
 
value = instance.AllowTableCorner
public bool AllowTableCorner {get; set;}

Property Value

Boolean: true to allow a sheet corner with a table; otherwise, false
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

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.