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


In This Topic
    HorizontalGridLine Property (SheetCorner)
    In This Topic
    Gets or sets the horizontal grid line for the sheet corner.
    Syntax
    'Declaration
     
    Public Property HorizontalGridLine As GridLine
    'Usage
     
    Dim instance As SheetCorner
    Dim value As GridLine
     
    instance.HorizontalGridLine = value
     
    value = instance.HorizontalGridLine
    public GridLine HorizontalGridLine {get; set;}
    Exceptions
    ExceptionDescription
    No value is specified (specified value is null)
    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