Hi All, We have an excel report generated by Jasperreports(ver3.0), the format of which is uneven only in Linux.The problem is that after every 30 row, an additional line is generated and part of the data from previous row is displayed on the 31st row. This happens after every 30 rows.The same report looks good in Windows. http://www.nabble.com/file/p18394895/sample.xls sample.xls
I have set the following parameters in the code: xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE) xlsExporter.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE); Please let me know the reason for this format issue and the solution for the same. Environment: iReport3.0 & JasperReport3.0 Note: I have attached sample xls report.After every row, u can see a additional row with data overlapped from previous line. -- View this message in context: http://www.nabble.com/Problem-with-Excel-report-format-generated-by-Japserreports-3.0-in-Linux-tp18394895p18394895.html Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions