Skip to Content
Menu

Protect XLSX report

by
Odoo

22.69

v 13.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Community Apps Dependencies
Lines of code 301
Technical Name protect_xlsx
LicenseAGPL-3
Versions 13.0 14.0 15.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Community Apps Dependencies
Lines of code 301
Technical Name protect_xlsx
LicenseAGPL-3
Versions 13.0 14.0 15.0 16.0 17.0 18.0
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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.