myusername01011 Posted August 22, 2017 Share Posted August 22, 2017 Hi,I'm using (Luna Eclipse and) TIBCO Jaspersoft® Studio - Visual Designer for JasperReports: . JasperReports Library and Tools 6.4.0.final (without the server) with both preview and export being set to XLSx with my table element. Unfortunately, all my columns' data is truncated. How do I set this up to auto adjust based upon cell data width (contents)? Back in 2011, I saw where this was supposed to be in the next release? I will gladly take either a solution or a workaround. But, hopefully a workaround that would be much more effective than modifying hundreds of individual Jasper Elements. Link to comment Share on other sites More sharing options...
Solution darth_fader Posted August 22, 2017 Solution Share Posted August 22, 2017 The <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> should be functional, but it looks like it has to go on the reportElement level, so you'd have to place it on each column in your table. Curious to see if this works for you. Link to comment Share on other sites More sharing options...
myusername01011 Posted August 22, 2017 Author Share Posted August 22, 2017 property was removed by Studio when entered manually through source tab. property does not appear as an option through "Edit Properties" for Column1's TextField nor Column1. All attempts to remove/delete the default width for the column have failed. Please advise. Link to comment Share on other sites More sharing options...
myusername01011 Posted August 22, 2017 Author Share Posted August 22, 2017 Appears to be working now. Thanks darth_fader! Link to comment Share on other sites More sharing options...
darth_fader Posted August 23, 2017 Share Posted August 23, 2017 Glad it worked for you! I learned something too. This is a useful feature. 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