auto resize cell width in excel export

[bhaskars_1]

Hi,

we have been using jasper reports library(6.0.0) for generating and exporting excel reports. I had a query regarding the same wherein we want to resize the width of columns according to the length of the data present within it. Have tried setting the following property but this  apparantly has no effect on the widths of the cells- 

<property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>

in addition to this, we are also disabling wrap text, which works fine, but the column width is not resized.

Any help regarding the same would be appreciated.

[hozawa]

Are you setting the property on the column. It may be a bug in Version 6.0.0 but I do know that it works.

[bhaskars_1]

I have tried setting it in the properties map in JasperPrint as well as in the TextColumnBuilder while defining columns.

 

Also, tried setting the property in the jrxml under reportElement. This doesn't seem to work either.

 

In which version is this property working? Might try it out. And would I set the property on each column?

 

Thanks!

[hozawa]

I'm using 6.3.0.

[derylspielman_1]

I am using 6.5.1 and still having this issue. Setting net.sf.jasperreports.export.xls.wrap.text=false with net.sf.jasperreports.export.xls.auto.fit.column=true seems to interfere with each other and the cell is formatted as wrap text = true even though the property was false.

Does anyone have any updates on this?