Eliminating 'few lines' in Jasper report (.JRXML) when output is saved as .xls ouput but the lines should be intact when output is exported to PDF

[mrunkind]

Hi,

We have used lines in place of cell borders while developing Jasper tabular report. The PDF output comes perfectly fine but when the Output is exported to Xls format , a whole row( in Xl sheet) gets hidden where ever line appears. How to avoid this ? any workaround ?

Regards,

karthik.M

[carlos2015]

This problem occurs because you have 2 o more objects in the same position (or this overlapping) , this means that only one view when exported to Excel.