jasper reports export to excel number format is not correct in formaula bar

[versha]

I am using

JasperReport 5.6.1

java 1.8

Ms-office 2007

Exporting to MS excel

I have set exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

Patternn used --> #,##0.000

Cell display --> 1.700

Formula Bar display --> 1.70000004768371

But it should show --> 1.700

Float data type is used in java.

Excel file extension used--> ".xls"

content type --> "application/vnd.ms-excel"

I have also tried --> ".xlsx" and content type --> "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

What's wrong?

[zh3ntil]

Actually nothing seems wrong about that. The actual value is 1.70000004768371 on report and report show that value 1.700 because of the pattern you use. So exported excel has the same behavior. actual value ise 1700...71 and formula bar shows that value but in cell, it shows 1.700 like there is a pattern. Everyting seems perfect to me :)

[versha]

Thanks for quick reply.

But report is for customer who wants same data on formula bar as in cell content to avoid any confusion.

There should be some way to get out of it.

[zh3ntil]

Then you have to scale this value in textfield expression editor. Use sth like  $F{field}.setScale(int newScale, RoundingMode roundingMode) 

[versha]

Thanks.

It worked fine.