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

Category:
Bug report
Priority:
Normal
Status:
Feedback Requested
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
14

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
Joined: Oct 22 2012 - 12:33pm
Last seen: 6 years 3 months ago

8 Comments:

#1
  • Status:New» Assigned
  • Assigned:nobody» shertage
#2

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

#3

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.

#4

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.

#5

6.6 and it is still there :)

#6
  • 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.

#7
  • 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

#8
  • Status:Assigned» Feedback Requested
Feedback
randomness