Content Comparison

...

Command	Description	Examples
`layer -lw n`	set worksheet write access flags	`lay -lw hex(82);//set active sheet to protect data and structure` `lay -lw;//protect everything` `lay -lw 2;// protect only data` `lay -lw hex(180);//no insert/del col/rows, no worksheet rename` `lay -lw 0;//remove all the protections on the current sheet`
`layer -lt`	print out current protection flags
`page -lw n`	set workbook write access flags	//the following will prepare the book for locking active sheet but allow analysis results added to book `lay -lw hex(582);//no del, no rename, no add/insert/move col/rows, no edit` `page -lw hex(400);//no del book` //other examples `page -lw;`//lock book and all sheets, nothing can be change changed and cannot delete book or sheets `page -lw hex(400);`//prevent user deleting the book `page -lw;` //lock the book completely, cannot even delete `page -lw hex(482);` //lock delete, structure change and data edit
`page -lt`	print out the current protection flags

...

The following is a listing of the currently supported doc commands control the Admin mode. Text inside square brackets indicateis optional.

...

Command	Description	Examples
`doc -pwa [password]`	Add Admin password password to the project. You will still need to login after adding password to turn on Admin mode. When you do not specify a password, then "origin" is assumed. Not using password will help situation where security is not so much of a concern and not running the risk of forgetting the password used.	`doc -pwa` `doc -pwa test`
`doc -pw [password]`	login with password, if no Admin password added yet, error message will be shown	doc -pw; doc -pw test;
`doc -pwx`	logout, once logout, cannot change anything related to protections
`doc -pwta`	list all the book/sheets with protection turned on
`doc -pwr [password]`	remove password, if no password specified, then must login first to do so, otherwise must give correct password	doc -pwr;

...

Versions Compared