Gets or sets whether cells in this row are marked as locked.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Locked As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Row
Dim value As Boolean
instance.Locked = value
value = instance.Locked |
| C# | |
|---|
public bool Locked {get; set;} |
Property Value
true if cells are marked as locked;
false otherwise
Remarks
Example
This example creates a multiple Row object and adjusts the alignment of the text in the row. The width of the second column is changed so that the alignment changes can be easily seen. The contents of the cells in the rows are locked to prevent editing.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Rowmyrow;
myrow=FpSpread1.ActiveSheetView.Rows[1,3];
myrow.HorizontalAlign=HorizontalAlign.Right;
myrow.VerticalAlign=VerticalAlign.Top;
myrow.Locked=true;
FpSpread1.ActiveSheetView.Columns[1].Width=140;
for(inti=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
}
TextBox1.Text=Convert.ToString(myrow.Index2); |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
DimmyrowAsFarPoint.Web.Spread.Row
Dimrow,row1,iAsInteger
row=1
row1=3
myrow=FpSpread1.ActiveSheetView.Rows(row,row1)
myrow.HorizontalAlign=HorizontalAlign.Right
myrow.VerticalAlign=VerticalAlign.Top
myrow.Locked=True
FpSpread1.ActiveSheetView.Columns(1).Width=140
Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
Nexti |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
