CoolSpools Spool Converter User Guide V6R1
Excel worksheet protection
Note that CVTSPLXL has two extra elements compared with
CVTSPLXLS. Note also that columns can now be optionally left
unlocked when a worksheet is protected by using a named style
with the locking attribute set appropriately.
Specifies protection options for the spreadsheet.
The default is the single value:
No protection options are specified.
The worksheet(s) created will be protected so that
they cannot be modified.
Worksheet protection password
No password will be required to unprotect the
worksheet. The user who opens the file will be
able to unprotect the worksheet simply by
selecting the appropriate menu option.
Specify the password that must be entered to
unprotect the worksheet.
Encrypted password supplied
The element does not exist for CVTSPLXLS.
Whether or not the password supplied on the previous element is supplied in the
ed form returned by CoolSpools’
DSPENCPWD (Display Encrypted
Password) command. See the discussion of encrypted passwords
DSPENCPWD applies an encryption algorithm to a password and returns a
scrambled version of that password to you. If you specify the scrambled password
on the previous element, and specify *YES here, CoolSpools Spool Converter will
unscramble the password for you before using it. The main purpose of this facility is
to avoid the need to hold passwords in plain text form in source code.
The password supplied on the previous element is
in plain text format and not scrambled.
The password supplied on the previous is in the
scrambled form returned by DSPENCPWD. It will
be automatically unscrambled before being used.
Defines the actions that can be applied to locked items on a protected worksheet.