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