Gets or sets whether cells in this column are marked as locked.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Locked As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As Boolean
instance.Locked = value
value = instance.Locked |
| C# | |
|---|
public bool Locked {get; set;} |
Property Value
Boolean:
true if cells are marked as locked from editing;
false otherwise
Remarks
Example
This example creates a multiple Column object and adjusts the alignment of the text in the column. The height of the rows are changed so that the alignment changes can be easily seen. The contents of the cells in the column are locked to prevent editing.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1,3];
mycol.HorizontalAlign=HorizontalAlign.Right;
mycol.VerticalAlign=VerticalAlign.Top;
mycol.Locked=true;
for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Rows[i].Height=80;
}
TextBox1.Text=Convert.ToString(mycol.Index2); |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
Dim i As Integer
mycol=FpSpread1.ActiveSheetView.Columns(1,3)
mycol.HorizontalAlign=HorizontalAlign.Right
mycol.VerticalAlign=VerticalAlign.Top
mycol.Locked=True
For i= 0 To FpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Rows(i).Height=80
Next i |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
