Jump to content
Changes to the Jaspersoft community edition download ×

How to control currency pattern with CSV export


kent.vickery

Recommended Posts

I am using Jasper Reports Library 6.0.0.

I am trying to export currency values to a CSV file.  In Jasper, I have the BigDecimal textField using pattern "$ #,##0.00", with the following properties added:

                    <property name="net.sf.jasperreports.export.csv.column.name" value="ChangeOverallBalance"/>
                    <property name="net.sf.jasperreports.export.xls.pattern" value="$ #,##0.00"/>

But when I export to CSV the cell is formatted as Currency, but using the (red for negative) ($1,1234.10) pattern - what I want is the -$(1,234.10) pattern.

I've tried different patterns with net.sf.jasperreports.export.xls.pattern, but nothing seems to make any difference to how the CSV ends up.

What am I doing wrong?

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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