Can't export report to protected .xlsx spreadsheet


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:

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

Jan Willem.

j.w.kijne's picture
Joined: May 23 2014 - 6:47am
Last seen: 11 months 1 week ago

0 Answers:

No answers yet