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


In This Topic
    ResetLockFont Method (Cell)
    In This Topic
    Resets the font for the locked cell and makes the cell in herit the font from the default cell.
    Syntax
    'Declaration
     
    Public Sub ResetLockFont() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetLockFont()
    public void ResetLockFont()
    Example
    This example sets the ResetLockFont 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