Export Excel problem

[imams]

Hi,

I am using JasperReports 1.2.7 in my J2EE project. I am able to export the generated report with Jasper API. My problem is the generated excel is not properly formatted- if the cell cannot accomodate the text content, then it does not warp. Any suggestions would be really appreciated. size=183]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/JasperExcel__Problem.JPG

[ns69]

I too had the same problem. I used the following code before calling the exporter.exportReport() function. Hope this solves your problem too. Please let me know if it worked or not.

 

 

Code:

exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED,Boolean.TRUE);

[imams]

Thanks for your advise. I tried same, but still problem remains. I think your code snippet would make the font-size to fixed. However, the problem is not with word wrap entirely; it's breaking words to lines which is good. The problem is the last line in cell is NOT entirely visible, but gets cut down. I feel this is caused due to FIXED Row Height. Any thoughts?

[ns69]

Sorry, my bad. Try and change the vertical align to "Top" and see if that helps.

[ns69]

Also try this:

 

Code:

exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE);

[imams]

Na, unfortunately even this didn't work! I tried 'Vertical' & your code snippet. Any more bright sparks? :)