riodavid Posted July 3, 2018 Share Posted July 3, 2018 Hi folks,I have a crosstab report which looks beautiful in html.But if I download it to excel or doc, the format becomes ugly, lots of things are missing.Please check the screenshot:https://postimg.cc/image/uhxcx0tm5/Do you have any idea why it happens?BRD Link to comment Share on other sites More sharing options...
hozawa Posted July 4, 2018 Share Posted July 4, 2018 When exporting to xlsx, you'll need to set several properties such as net.sf.jasperreports.export.xls.remove.empty.space.between.columns=trueto make the export look correctly.http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.remove.empty.space.between.columns Link to comment Share on other sites More sharing options...
riodavid Posted July 4, 2018 Author Share Posted July 4, 2018 @HozawaThanks for the sharing.Are these "xls" properties also working for xlsx too? Link to comment Share on other sites More sharing options...
hozawa Posted July 4, 2018 Share Posted July 4, 2018 Yes. Link to comment Share on other sites More sharing options...
Solution riodavid Posted July 6, 2018 Author Solution Share Posted July 6, 2018 Root cause found, elements were covered by elements.https://postimg.cc/image/55upabtsd/ 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