TdxCustomSpreadSheet.OnGetPassword Event

Enables you to respond to the password request when an encrypted XLS, XLSX, XLT, or XLTX document is being loaded by the Spreadsheet or Report Designer control.

Declaration

property OnGetPassword: TdxGetPasswordEvent read; write;

Remarks

Handle this event to prevent the standard Password Protection dialog from displaying when both attempts (by using the Password property value and the default spreadsheet password) to load an encrypted document automatically have failed. For instance, you can handle this event to provide a password via code as shown in the code example listed in the Spreadsheet Document Encryption topic.

The Sender parameter specifies the Spreadsheet or Report Designer control that raised the OnGetPassword event.

The Password parameter specifies the password required to decrypt the loaded spreadsheet document.