Because of work requirement that mandates that i have to use iReports and jasperreports for reporting, i gained some fresh hands on experience with the great reporting tool and visual IDE. By the way, iReports is the visual IDE for the API jasperreports.
So the question is, is your jasper reports generated Excel not showing you the cell border as usual? Are you getting this?
Well, and if only this were your own project and you could turn a blind eye to it and say “ar its fine, doesn’t make a difference to me, shouldn’t make a difference for my users.”.
But when there are people in your company looking at you to deliver, you couldn’t just smirk and ask them “what lines? what do you need the lines for again?”. Here’s the solution i found, and as it turns out, its quite simple, but rather “hidden” for something we quite use everyday.
1. Navigate to the “Options” option from the “tools” menu.
2. Navigate to the “JasperReports Properties” tab.
3. Find the “net.sf.jasperreports.export.xls.ignore.cell.border” property, change from false to true.
Once done, click on, refresh and you should see the border back on the Excel files generated.
Jasper generated Excel with cell border.