OVERVIEW
This module adds an extra layer of security to Excel reports by allowing users to protect sheets within the workbook. With this functionality, you can prevent unauthorized edits to data while still enabling users to view the content.
Key Features
- Sheet Protection: Automatically apply protection to sheets in Excel reports to safeguard critical data.
- Customizable Passwords: Define a password to secure the sheets, restricting modifications to users.
- Seamless Workflow: Integrated directly into Odooâs reporting system, maintaining a smooth user experience.
- Enhanced Security: Prevent accidental changes or intentional tampering with essential report data.
This module is perfect for businesses that need to share Excel reports while preserving the integrity of their critical data.
Usage:
-
Activate Developer Mode
- Go to Settings in your Odoo instance.
- Enable the Debug (Developer) mode from the settings page.
-
Configure Report Protection
- Navigate to Settings > Technical > Actions > Reports.
- Select the specific report you want to protect.
- Go to the Advanced Properties tab.
- Check the Protect Report checkbox.
- A password field will appear; enter the desired password to protect the sheet.
-
Generate Protected Report
- Print the report as usual.
- The resulting Excel file will have protected sheets with the password you configured.
-
Unprotect a Sheet
- Open the protected Excel sheet.
- Right-click on the locked sheet.
- Select Unprotect Sheet from the context menu.
- Enter the password to unlock the sheet.
SCREENSHOTS
SETTING PAGE

Repot action

Excel sheets

Unprotect sheet

SUPPORT
Please log in to comment on this module