The General tab of the Sheet Settings dialog provides the settings that apply to the entire sheet and correspond to the SheetView properties for row and column count and operation mode. Refer to the properties in the SheetView class.
For more information on operation mode, refer to Specifying What the User Can Select in the Developer’s Guide.
This tab provides the following items:
| Sheet Settings | Description and Reference |
|---|---|
|
Column Count Row Count |
Select the amount of columns and rows to be displayed. |
|
Restrict Columns Restrict Rows |
Set restrictions on entering data into columns or rows. |
|
Frozen Column Count Frozen Row Count |
Sets the number of columns or rows that cannot be scrolled at the top and left of the view. |
|
Trailing Frozen Column Count Trailing Frozen Row Count |
Sets the number of columns or rows that cannot be scrolled at the bottom and right of the view. |
|
Protect |
If set to true, selected cells are not editable. |
|
Operation Mode |
Setting that determines the mode of selections; specifies what the user can select in the data area. For more information, refer to the OperationMode enumeration and the SheetView OperationMode property in the Assembly Reference. |