[#2795] - net.sf.jasperreports.export.xls.auto.fit.column not being respected when exporting as XLSX

Posted by mattinger_1 on March 6, 2013 - 6:40pm
Category:
Bug report
 Priority:
Normal
 Status:
Feedback Requested
Project:
JasperReports® Library
 Severity:
Major
 Resolution:
Open
Component: Reproducibility:
Always
 Assigned to:
teodord
Subscribe

When i add the following to a report element in my .jrxml file:

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

And then i export to standard XLS, columns are auto sized appropriately. However, if I export to XSLX, this property has no effect.
I have tried:

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

just to be sure, and that does not seem to do anything.

v5.0.0
mattinger_1's picture
mattinger_1
4
Joined: Oct 22 2012 - 12:33pm
Last seen: 9 years 6 months ago

8 Comments:

#1Posted by teodord on April 23, 2013 - 7:11am
  • Status:New» Assigned
  • Assigned:nobody» shertage
#2Posted by stefans24 on November 23, 2017 - 12:31pm

Hi all, I am also encountering same issue. It seems like property does not work when exporting to xlsx.
Any update on this?

#3Posted by joannm on May 31, 2018 - 2:21pm

5+ years and major versions later, and I'm still seeing this bug. Any updates on when this might be handled? User gut instinct is to export to xlsx.

#4Posted by derylspielman_1 on July 18, 2018 - 2:13pm

I'm having the same issue on 6.5.1. It appears net.sf.jasperreports.export.xls.auto.fit.column works with xls but not with xlsx.

#5Posted by montherz on December 15, 2018 - 10:33am

6.6 and it is still there :)

#6Posted by michael.ingrum_1 on March 25, 2020 - 10:13am
  • Assigned:nobody»

Hi there, this isn't a bug. The property is for the XLS exporter not the XLSX exporter. The XLSX exporter does not have these properties.

#7Posted by teodord on March 26, 2020 - 11:19pm
  • Assigned:nobody» teodord

Hi,

I have a different question for all of you who raise this problem.
Can any of you show us a screenshot of MS Excel where this property can be set with Excel software itself?

OK, I understand it does not work when we set it from our program. But putting JasperReports aside for a moment, can anybody show us this feature working with an XLSX file they created with Excel from scratch?

Thank you,
Teodor

#8Posted by teodord on March 26, 2020 - 11:20pm
  • Status:Assigned» Feedback Requested
Feedback
randomness