XLSx Auto width

[montherz]

Hi,

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

Monty

[montherz]

It seems that it is a reported issue

[#2795]

and it is still open .... I will export my report as XLS and manully save it as XLSx until this is fixed

 

Thank You

Monty