Jump to content
We've recently updated our Privacy Statement, available here ×

Can't export report to protected .xlsx spreadsheet


j.w.kijne

Recommended Posts


Hi there

I'm working in Jaspersoft Studio 5.6.0.

I need to be able to generate a protectd spreadsheet for my report design. To do this, I added the following property to my report:
<property name="net.sf.jasperreports.export.xls.password" value="MyPassword"/>
And to unlock and convert them into entry cells, I added to the corresponding report elements the following <reportElement /> property:
<property name="net.sf.jasperreports.export.xls.cell.locked" value="false"/>

When I export the report with these properties set to .xls the resulting sreadsheet is indeed protected as expected. But if I choose for the .xlsx output format the resulting spreadsheet isn't! This seems to be confirmed by the following stackoverflow article: https://stackoverflow.com/questions/8088738/how-to-protect-jasper-generated-report-when-using-xlsx-as-output

- Is there any other way to protect generated spreadsheet when choosing for .xlsx?
- If not, is this missing feature expected to be solved soon?

I hope for a solution.

Regards,
Jan Willem.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...