support_26 Posted August 27, 2019 Share Posted August 27, 2019 Hi,I have made a report in IReport 5.2.0, whitch contains an excel formula made with "net.sf.jasperreports.export.xls.formula" property.It works ok with the preview using JExcelAPI in IReport or when I generate the report in the application, but if I copy the file in a internet temporary directory like .../AppDataLocalMicrosoftWindowsINetCacheIEWH8FHF7Y, Excel opens the file in a protected mode and the numbers displayed are wrong.The protected version :The unprotected version after clicking "Enable editing" juste after taking the snapshot above:Does someone have already seen the problem?A basic xls file doesn't have this problem.Thanks. Link to comment Share on other sites More sharing options...
swood_1 Posted August 30, 2019 Share Posted August 30, 2019 JasperReports use Apache POI to generate XLS and XLSX files.It looks like there is no option to force the formula evaluation in Protected Mode in the POI API.https://stackoverflow.com/questions/52730977/how-to-set-enable-edit-and-protected-mode-off-using-poi?rq=1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now