Jasper related querstion:XLSX formatting issue: number displayed as text

[Vinny Menon]

Hi Fellow Ranchers
i am using jasperreports-4.1.2.jar,poi-3.7-20101029.jar in one of my projects.I have to generate xlsx report using Jasper. I have ireports 4.1.1 for report designing.
the report is getting generated fine.But all the numeric values are appearing as Text.
i have used following in my code where i export the report via JRXlsxExporter.
:

setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, true);

But still the issue exists.Can you please explain why this is happening or how this can be resolved? is it a problem with jar version?

Cheers
Vinny M
proud fan of European Champion Chelsea F.C.