Reduced cell size when exporting to excel.

0

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's picture
Joined: Jun 12 2012 - 4:58am
Last seen: 6 years 6 months ago
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?
laurencija - 6 years 6 months ago

0 Answers:

No answers yet
Feedback
randomness