Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxCustomSpreadSheet.OnGetPassword Event

In This Article

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

Delphi
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.

See Also