Problem with Excel report format generated by Jap

[psoma.cse]

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.xls size=22528]

[lucianc]

Try to set isSplitAllowed="false" for the detail band.

 

Regards,

Lucian

[psoma.cse]

Hi Lucian,

Thanks for your reply.

As a temporary fix, I changed the font,size and the stretch type to 'Tallest Object'. And the report came up fine in Linux also after the above change.

Let me try by setting the 'Issplitallowed' property also as I wish to know the reason for this behaviour.

 

 

Thanks Again...

:)

 

Somu