Jump to content
Changes to the Jaspersoft community edition download ×

Format does not work in Excel display??


Recommended Posts

I have several cells with Oracle.BigDecimal fields that I have set the 'Pattern' to #,##0.00



I was under the impression that I would always get two decimal places in the output, but I do not.



If the number is a whole number, I get no decimal places.


If the number is like 10.50, I get 10.5 (only one decimal place).




What is wrong with this?

Is it a quirk for Excel or is it in Jasper?

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

If you are exporting this report to Excel, then I'm willing to bet that Excel is the problem!

Try outputting your report to another format, such as PDF, and have a look at the results. If the numbers are formatted as you originally specified, then the problem is Excel trying to be clever.

The only solution I can find to this annoying behaviour is to export the report to CSV, and then import it into Excel, making sure it treats each column as text.

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...