Reduced cell size when exporting to excel.

[laurencija]

Can anyone help me? I have a problem when exporting to excel. The problem is that all cells are smaller in width and height then they should be. That's why text does not fit into cells.

When exporting to pdf and docx formats everything looks fine.

I use JasperReports 5.0.0

Also,

JRXlsExporter xlsExporter = new JRXlsExporter();

xlsExporter.setParameter(JRExporterParameter.IGNORE_PAGE_MARGINS, Boolean.TRUE);

Attaching pdf, docx and xsl files. Also adding jrxml file.

How can I solve this problem and make excel cell width and height be the same as in pdf or docx?

 

 

[laurencija]

Property net.sf.jasperreports.export.xls.column.width.ratio with value 1.7 helped a bit and column width looks acceptable. But how can I fix row height?