Extra columns in excel report

[javalogan]

Hi, I'm using JasperReports 4.0.1. When I export a report to EXCEL, there seems to be many extra columns and rows if the reports elements are not aligned perfectly.

I have tried using the following code but the extra columns and rows still show. I'm trying to use the same report for PDF exporting as well as EXCEL exporting but I'm sure there must be an easier way to get rid of the extra columns than to align ALLLLL of the elements perfectly.

Anyone have any suggestions? :)

Code:

exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);exporter .setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);[/code]

[cmatthews]

See this related post,

http://community.jaspersoft.com/questions/543494/unwanted-merged-rows-excel-export

I have been using Jasper Reports for 5+ years now and haven't found a solid way to directly deal with this, work arounds are your best bet I think.

[techogre]

I found the same issue when creating a report and didn't allign the text boxes perfectly. Any missalignment, even by a single pixle, will add extra tabs and rows.