Reduced cell size when exporting to excel.

Posted on April 23, 2013 at 5:03am

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?

 

 

Attachments: 
PDF icon report.pdf
File report.docx
Office spreadsheet icon report.xls
Binary Data taskprocessingreport.jrxml
iReport Designer
JasperReports® Library
laurencija's picture
laurencija
1
Joined: Jun 12 2012 - 4:58am
Last seen: 9 years 11 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 11 months ago
add comment

0 Answers:

No answers yet
Feedback
randomness