Problem with cells in Excel report

[pepa.nemecek]

Hi,

I have problem with report output in Excel. PDF output is OK.

I have created this layout only with Text Field and Static Text elements.

But in excel report cells and rows are messed up.

I have tried setting some properties for xls export but it didn´t help. Thanks for any advice.

 

[lisaws]

What is the layout of your report, i.e. are you using a table, or are theese text elements in the main report?  If in the main report, which bands?  Are 'Bankovky' and 'Mince' group values?

I've never tried having a row label extend down over several rows.  However I would think you could achieve this if you set the stretch type on that row label, then put the rows within it as a table element and pass the value for ex. Bankovky into the table datasource.  It would require two separate queries - one query in the main report to pull Bankovky and Mince, and one query in the table datasource that pulls the row details.

[hozawa]

Try setting the following property to "false" in your report.

net.sf.jasperreports.export.xls.collapse.row.span