Excel XLSX export issue

[PP Ocean]

Hi,

I am using 6.1 version. When I export the report to XLSX it is giving the message: "Excel found unreadable content....". When I click YES I can see the report in excel but the thing is I do not want to see that pop-up message. This is happening to XLSX only. XLS export is working fine.

These are the properties I have used in JRXML.

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.band.0" value="title"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.band.1" value="pageHeader"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.2" value="pageFooter"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.band.3" value="columnHeader"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.report.3" value="*"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.4" value="columnFooter"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.5" value="pageFooter"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.6" value="lastPageFooter"/>

<property name="net.sf.jasperreports.export.xlsx.remove.empty.space.between.rows" value="true"/>

<property name="net.sf.jasperreports.export.xlsx.remove.empty.space.between.columns" value="true"/>

<property name="net.sf.jasperreports.export.xlsx.detect.cell.type" value="true"/>

<property name="net.sf.jasperreports.export.xlsx.collapse.row.span" value="true"/>

<property name="net.sf.jasperreports.export.xlsx.ignore.page.margins=true"/>

<property name="net.sf.jasperreports.export.xlsx.one.page.per.sheet=true"/>

<property name="net.sf.jasperreports.export.xlsx.wrap.text" value="true"/>

<property name="net.sf.jasperreports.export.xlsx.column.width.ratio" value="1.10f"/>

<property name="net.sf.jasperreports.export.xlsx.auto.fit.column" value="true"/>

Any ideas please?

Thanks

[dnaboka]

Does this happen in Microsoft Excel? Try using LibreOffice to open the file, for example.

[PP Ocean]

Yes this happening in Microsoft excel. Unfortunately we can't change it to LibreOffice. I need a solution for Microsoft excel only.

[szaharia]

This kind of issues may have various causes, such as wrong defined names, improper formula results, wrong local anchor names, etc.

In order to identify the cause here, please post the JRXML file, and if possible, the generated XLSX workbook.