format excel cells exported report

[danielkrol]

 Hi,

 

I have a report wich has some percentages in it. Whit setting "net.sf.jasperreports.export.xls.formula" I managed to let excel calculate the percentage (e.g. SUM(B1/A1) ). Assume A1 is filled with 100 and B1 with 10; in excel I get 0.10 with the mentioned formula.

Now I want to be able to set the format of the percentage cell to "0%". Excel will display this cell with the above example as "10%". Only, how can I set a parameter to force Excel to use format "0%" for the particular cells?

 

I hope someone can help me out!

Greetz, Daniel