psoma.cse Posted July 11, 2008 Share Posted July 11, 2008 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. 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. Thanks, Somu [file name=sample-260b18a08e4f1445df009b6b4da3ac65.xls size=22528] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now