iReport: Numbers from Excel-Source are always 10x

I got an Excel-Source with a Simple Table:

Soda  Respondents

Coke   100

Pepsi  100

7-Up    33


On Import the Numbers appear as 10x theire expected value (Coke and Pepsi get the Respondents-Value 1000 and 7-Up gets 330)

I tried java.lang.Integer and java.lang.Number as Field Class for the field Respondents.

The Problem appears direktly when i do the Preview-Data in the Report-Query.

I tried formatting the Cells in Excel from standard to numeric


s.barzyk's picture
Joined: Mar 19 2013 - 10:21am
Last seen: 9 years 5 months ago

0 Answers:

No answers yet