Jump to content
Changes to the Jaspersoft community edition download ×

XLSx Auto width

Go to solution Solved by montherz,

Recommended Posts


I'm using TIBCO Jaspersoft® Studio 6.6.0 - Visual Designer for JasperReports 6.6.0. for sometime now i been trying to auto fit width when exporting to XLSx.

My textField looks like this:

            <textField>                <reportElement x="600" y="0" width="190" height="39" uuid="ada9ab70-53c7-47f1-b25b-6c8ed7084657">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="dec2d24a-e1c9-450a-932c-397fd36a5c5d"/>                    <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/>                    <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>                </reportElement>                <textFieldExpression><![CDATA[$F{IML_POSITION}]]></textFieldExpression>            </textField>[/code]


when trying this it exports to XLS proberly but when trying XLSx it always takes the width specified for the textField (in my case width="190").

Am I missing something ??? been trying to find a solution for a while now and i've found alot of unanswered questions facing this particular problem.

Help guys :)


Thank You


Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...