Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
2Data: This include all the cells in a worksheet, data cells or label cells
4Style: Display style, like the color of the cell, or the cell formatting, this is currently not yet fully implemented
 10Formula: 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

 
CommandDescription          Examples       

layer -lw n

set worksheet write access bitsflags 

lay -lw hex(82);//set active sheet to protect data and structure

lay -lw;//protect everything

lay -lw 2;// protect only data

layer -lt print out current protection flags 
page -lw nset 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