Spread Windows Forms 12.0 Product Documentation
ResetLockBackColor Method (Row)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Row Class : ResetLockBackColor Method
Resets the background color for the locked row and makes the row inherit the background color from the default row.
Syntax
'Declaration
 
Public Sub ResetLockBackColor() 
'Usage
 
Dim instance As Row
 
instance.ResetLockBackColor()
public void ResetLockBackColor()
Example
This example uses the ResetLockBackColor 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

Reference

Row Class
Row Members