burferd Posted April 16, 2007 Share Posted April 16, 2007 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 More sharing options...
scottmacpherson Posted April 19, 2007 Share Posted April 19, 2007 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now