Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / LockForeColor Property
Example


In This Topic
    LockForeColor Property (Column)
    In This Topic
    Gets or sets the default forecolor for locked's cells in this column.
    Syntax
    'Declaration
     
    Public Property LockForeColor As Color
    'Usage
     
    Dim instance As Column
    Dim value As Color
     
    instance.LockForeColor = value
     
    value = instance.LockForeColor
    public Color LockForeColor {get; set;}
    Example
    This example sets the LockForeColor property.
    fpSpread1.ActiveSheet.Cells[1, 1].LockBackColor = Color.Tomato;
    fpSpread1.ActiveSheet.Cells[1, 1].LockForeColor = Color.DarkBlue;
    fpSpread1.ActiveSheet.Cells[1, 1].LockFont = new Font("Calibri", 11);
    fpSpread1.ActiveSheet.Cells[1, 1].Text = "Locked";
    fpSpread1.ActiveSheet.Cells[1, 1].Locked = true;
    
    fpSpread1.ActiveSheet.Columns[3].LockBackColor = Color.Bisque;
    fpSpread1.ActiveSheet.Columns[3].LockForeColor = Color.DarkBlue;
    fpSpread1.ActiveSheet.Columns[3].LockFont = new Font("Calibri", 11);
    fpSpread1.ActiveSheet.Cells[0, 3, 10, 3].Text = "Locked";
    fpSpread1.ActiveSheet.Columns[3].Locked = true;
    
    fpSpread1.ActiveSheet.Rows[3].LockBackColor = Color.LemonChiffon;
    fpSpread1.ActiveSheet.Rows[3].LockForeColor = Color.DarkBlue;
    fpSpread1.ActiveSheet.Rows[3].LockFont = new Font("Calibri", 11);
    fpSpread1.ActiveSheet.Cells[3, 0, 3, 10].Text = "Locked";
    fpSpread1.ActiveSheet.Rows[3].Locked = true;
    
    FarPoint.Win.Spread.NamedStyle style = new FarPoint.Win.Spread.NamedStyle();
    style.Locked = true;
    style.LockBackColor = Color.Beige;
    style.LockForeColor = Color.Black;
    style.LockFont = new Font("Calibri", 11);
    style.Name = "lockstyle";
    fpSpread1.ActiveSheet.Cells[5, 5].Text = "Locked";
    fpSpread1.NamedStyles.Add(style);
    fpSpread1.ActiveSheet.Cells[5, 5].StyleName = "lockstyle";
    
    //fpSpread1.ActiveSheet.Cells[1, 1].ResetLockBackColor();
    //fpSpread1.ActiveSheet.Columns[3].ResetLockBackColor();
    //fpSpread1.ActiveSheet.Rows[3].ResetLockBackColor();
    //style.ResetLockBackColor();
    //fpSpread1.ActiveSheet.Cells[1, 1].ResetLockForeColor();
    //fpSpread1.ActiveSheet.Columns[3].ResetLockForeColor();
    //fpSpread1.ActiveSheet.Rows[3].ResetLockForeColor();
    //style.ResetLockForeColor();
    //fpSpread1.ActiveSheet.Cells[1, 1].ResetLockFont();
    //fpSpread1.ActiveSheet.Columns[3].ResetLockFont();
    //fpSpread1.ActiveSheet.Rows[3].ResetLockFont();
    //style.ResetLockFont();
    FpSpread1.ActiveSheet.Cells(1, 1).LockBackColor = Color.Tomato
    FpSpread1.ActiveSheet.Cells(1, 1).LockForeColor = Color.DarkBlue
    FpSpread1.ActiveSheet.Cells(1, 1).LockFont = New Font("Calibri", 11)
    FpSpread1.ActiveSheet.Cells(1, 1).Text = "Locked"
    FpSpread1.ActiveSheet.Cells(1, 1).Locked = True
    
    FpSpread1.ActiveSheet.Columns(3).LockBackColor = Color.Bisque
    FpSpread1.ActiveSheet.Columns(3).LockForeColor = Color.DarkBlue
    FpSpread1.ActiveSheet.Columns(3).LockFont = New Font("Calibri", 11)
    FpSpread1.ActiveSheet.Cells(0, 3, 10, 3).Text = "Locked"
    FpSpread1.ActiveSheet.Columns(3).Locked = True
    
    FpSpread1.ActiveSheet.Rows(3).LockBackColor = Color.LemonChiffon
    FpSpread1.ActiveSheet.Rows(3).LockForeColor = Color.DarkBlue
    FpSpread1.ActiveSheet.Rows(3).LockFont = New Font("Calibri", 11)
    FpSpread1.ActiveSheet.Cells(3, 0, 3, 10).Text = "Locked"
    FpSpread1.ActiveSheet.Rows(3).Locked = True
    
    Dim style = New FarPoint.Win.Spread.NamedStyle()
    style.Locked = True
    style.LockBackColor = Color.Beige
    style.LockForeColor = Color.Black
    style.LockFont = New Font("Calibri", 11)
    style.Name = "lockstyle"
    FpSpread1.ActiveSheet.Cells(5, 5).Text = "Locked"
    FpSpread1.NamedStyles.Add(style)
    FpSpread1.ActiveSheet.Cells(5, 5).StyleName = "lockstyle"
    
    'FpSpread1.ActiveSheet.Cells(1, 1).ResetLockBackColor()
    'FpSpread1.ActiveSheet.Columns(3).ResetLockBackColor()
    'FpSpread1.ActiveSheet.Rows(3).ResetLockBackColor()
    'style.ResetLockBackColor()
    'FpSpread1.ActiveSheet.Cells(1, 1).ResetLockForeColor()
    'FpSpread1.ActiveSheet.Columns(3).ResetLockForeColor()
    'FpSpread1.ActiveSheet.Rows(3).ResetLockForeColor()
    'style.ResetLockForeColor()
    'FpSpread1.ActiveSheet.Cells(1, 1).ResetLockFont()
    'FpSpread1.ActiveSheet.Columns(3).ResetLockFont()
    'FpSpread1.ActiveSheet.Rows(3).ResetLockFont()
    'style.ResetLockFont()
    See Also