Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / ResetLockForeColor Method
Example


In This Topic
    ResetLockForeColor Method (Cell)
    In This Topic
    Resets the text color for the locked cell and makes the cell inherit the fore color from the default cell.
    Syntax
    'Declaration
     
    Public Sub ResetLockForeColor() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetLockForeColor()
    public void ResetLockForeColor()
    Example
    This example uses the ResetLockForeColor method.
    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