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

1

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
13
Joined: Apr 9 2014 - 5:34am
Last seen: 4 years 10 months ago

1 Answer:

0

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
13
Joined: Apr 9 2014 - 5:34am
Last seen: 4 years 10 months ago
Feedback
randomness