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


In This Topic
    ResetLockForeColor Method (Column)
    In This Topic
    Resets the fore color for the locked column and makes the column inherit the fore color from the default column.
    Syntax
    'Declaration
     
    Public Sub ResetLockForeColor() 
    'Usage
     
    Dim instance As Column
     
    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