Jump to content
We've recently updated our Privacy Statement, available here ×

Problem with Excel report format generated by Jap


psoma.cse

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...