Reduced cell size when exporting to excel.

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email with questions or issues requiring TIBCO review or response.

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


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: 9 years 2 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 - 9 years 2 months ago

0 Answers:

No answers yet