[#10626] - While exporting jasper report to excel numericals values are detected as text.

Category:
Bug report
Priority:
Immediate
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

While exporting jasper report to excel numericals values are detected as text.
I have also added the property net.sf.jasperreports.export.xls.detect.cell.type="true" in my report but still it is not converted into number field.

AttachmentSize
Image icon properties.png200.46 KB
lokesh6694's picture
Joined: Mar 12 2018 - 1:51am
Last seen: 8 months 2 weeks ago

1 Comment:

#1

Not sure if this will help you, but we found we had to add the property 'net.sf.jasperreports.export.xls.pattern' to the numeric fields. We typically used a value of '#,##0', but you should be able tailor it to your needs.

Feedback
randomness