Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetCorner Class / Cells Property
Example


In This Topic
    Cells Property (SheetCorner)
    In This Topic
    Gets a Cells object for the cells in the sheet corner.
    Syntax
    'Declaration
     
    Public ReadOnly Property Cells As Cells
    'Usage
     
    Dim instance As SheetCorner
    Dim value As Cells
     
    value = instance.Cells
    public Cells Cells {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)
    
    See Also