cutebluangel Posted January 27, 2015 Share Posted January 27, 2015 I have a report with the following layout:[section 1 - Summary that can span more than 1 A4 size paper on print][break][section 2 - Details that can span more than 1 A4 size paper on print] The report can be exported to PDF and Excel. PDF export was a breeze. For Excel export, I utilized ignore pagination, one page per sheet and page break properties. The resulting Excel document had two sheets but the column widths were identical. Ideally, since they are different sheets, I was expecting their column widths to be independent of each other. I tried removing the ignore pagination setting and the resulting Excel document had, as expected, more than two sheets but with different column widths (a surprise!). I would like to know if there is a way to implement to restrict the Excel output to the two sheets/sections as designed but have independent columns widths from each other? Is this a bug in the implementation of the library? Or am I missing some setting here? Link to comment Share on other sites More sharing options...
Solution cutebluangel Posted January 27, 2015 Author Solution Share Posted January 27, 2015 The links on the right side of my question lead me to the solution.I did not use anymore the xls.break.after.row property. Instead, I used the page break element (as I was doing to PDF output) and set the "net.sf.jasperreports.page.break.no.pagination" to apply in the actual report template. The setting does not seem to be honored when set programmatically. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now