We use Jasper iReport Designer 5.5.0 to design reports and as plugin jasperreports-6.2.0.jar.
Jasper Reports has an option to create an Excel file instead of an PDF.
Today a customer reported that in such an Excel-output from a Jasper report, a number was missing in a specific column.
In the PDF, that number appeard.
I installed then the MS Office Excel Viewer and tried to do the same.
The Viewer then said when launching that file "File Error. Some number formats might got lost."
Did someone else experience such issues with the Excel-output from a Jasper report?
Because when that is not reliable and does not produce the same output as the PDF in all cases, we have to take away that option from our users.
The number in question was a quite normal "16.00", nothing special, while most (or all) other numbers showed as expected.