Jump to content
Changes to the Jaspersoft community edition download ×

Problem with double value format


Recommended Posts

I use iReport 1.3.0 and create java application with jasperreports-1.3.0.jar for building reports and export data to MS Excel. I've got a report template file (*.jrxml). In "Pattern" property of the text field I set format "0.00" for represent double value. When I get the report in MS Excel then all double values has "0" format.

What I should to do that to win this problem?

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

The problem is that the data is being placed into cells that are have 'General' formatting (the Excel default)applied. That means that Microsoft Excel will look at the incoming data and apply what it thinks is the best display formatting for what it sees.


You have to come in afterwards and reformat the cells at 'Number' with x decimal places if Excel make an inappropriate decision.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...