"File error. Some number formats may have been lost" when exporting report with chart to Excel

When I my report to Excel in iReport, all goes well and apart from my data I get a nice image of my chart. But as soon as I upload my report to Jasperserver and export my report to Excel I get this error saying "File error. Some number formats may have been lost". Even my print date will turn into some strange number.

Can somebody please tell me what I am doing wrong?

Maine's picture
17
Joined: Apr 9 2014 - 5:34am
Last seen: 8 years 7 months ago

1 Answer:

It seems that the error was a bit misleading. The server could not handle the date format "EEEEE dd MMMMM yyyy". Hence the error. When that format was changed there was no error message left. That was a completely different situation! Then the parameter "ignoreGraphics" of the file  "WEB-INF/applicationContext.xml" on the server was checked and indeed...this was set to true. When changed to false the graphics finally appeared in Excel on the server as well as locally.

Maine's picture
17
Joined: Apr 9 2014 - 5:34am
Last seen: 8 years 7 months ago
Feedback