How to control currency pattern with CSV export

[kent.vickery]

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?

[kent.vickery]

Note at the top of my jrxml I am setting the property:

    <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 

[tstuser]

 set pattern as ,###,##,##0.00 in properties

[kent.vickery]

Using the pattern suggested above made no difference.  When the CSV opens up the (red for negative) ($1,1234.10) pattern is still what is set for the column.  

[kent.vickery]

Oh - I see you meant setting that pattern for the actual textField atrribute, as a Custom Format.  That does change things, but then I am not getting the amount as a currency on any output (PDF, CSV).  I need the dollar sign.