...
After a command is entered, you App title will change accordingly, so will the status bar to indicate current status.
Protection Flags
Various objects like worksheet, workbooks can be assigned different protection flags. These flags are listed in the following table
Hex Value | Description |
---|---|
2 | Data: This include all the cells in a worksheet, data cells or label cells |
4 | Style: Display style, like the color of the cell, or the cell formatting, this is currently not yet fully implemented |
10 | Formula: Column Formula, Analysis Operation, Codes attached to Project etc. |
80 | Structure: This include like the number of rows and columns in a worksheet. inserting, deleting etc. |
Workbook Worksheet Protection Commands
Multiple protection flags can be combined
Command | Description | Examples | ||
---|---|---|---|---|
| set worksheet write access bitsflags |
| ||
layer -lt | print out current protection flags | |||
page -lw n | set workbook write access bitsflags | |||
page -lt | print out the current protection flags | page -lw; //lock book and all sheets, nothing can be change and cannot delete book or sheets |