excelformula with decimal and comma

Hi

This is my text field expression.

$F{rate}==0 ? "_" : (new java.text.DecimalFormat("###0.0000;(###0.0000)")).format($F{rate})

Property name---->net.sf.jasperreports.export.xls.formula

I want to display 1 as 1.0000,but it shown as 1 only.

That means when applying excel formula,i am not getting comma seperation and decimal precision in excel.

liyak9@gmail.com

regards

Liya