Gets or sets whether users are restricted from typing data in a column on this sheet that is more than one column beyond the last column that contains data.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property RestrictColumns As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As Boolean
instance.RestrictColumns = value
value = instance.RestrictColumns |
| C# | |
|---|
public bool RestrictColumns {get; set;} |
Property Value
Boolean:
true to restrict users from those columns;
false otherwise
Example
This example restricts users so they cannot type data in the columns or rows that are more than one column or row beyond the last one containing data.
| C# | Copy Code |
|---|
fpSpread1.ActiveSheet.RestrictColumns = true;
fpSpread1.ActiveSheet.RestrictRows = true; |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheet.RestrictColumns = True
FpSpread1.ActiveSheet.RestrictRows = True |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
