Sheet Protection

No password is required when ProOffice populates XML files directly. This is independent of the protection settings.

ProOffice for Microsoft Excel supports tables with protected sections. The password must be available for the automatic filling. The password set in the customizing will then be canceled temporarily and reset with the same password.

In case the form is protected without a password, „no password“ must be set as password in the customizing. This way the AddIn will cancel the form protection temporarily and reset it without password.
For documents without form protection, no special procedure is required (independent of customizing settings).

Microsoft Excel requires passwords in lower case letters. The PrOffice AddIn for Microsoft Excel will always convert the password set in the customizing in to lower case letters.

For customizing settings see OBJ | ProObjectLib | Customizing Manual.