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


In This Topic
    AlternatingRows Property (SheetCorner)
    In This Topic
    Gets the alternating rows information for the sheet corner.
    Syntax
    'Declaration
     
    Public ReadOnly Property AlternatingRows As AlternatingRows
    'Usage
     
    Dim instance As SheetCorner
    Dim value As AlternatingRows
     
    value = instance.AlternatingRows
    public AlternatingRows AlternatingRows {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