Excel cell auto adjustment with table element

[myusername01011]

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.

[darth_fader]

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.

[myusername01011]

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.

[myusername01011]

Appears to be working now.  Thanks darth_fader!

[darth_fader]

Glad it worked for you! I learned something too. This is a useful feature.