Excel Format Mapping

[supunthri]

 HI,

I have an JasperReport running on JasperServer 3.7 which has a percentage column with the following numeric pattern applied 

"#,##0.00 %"

But when you export the report to excel what I get is a value like below,

for example, for the value 25.0% shown on jasperserver what I see on the excel export is,

"0.25"

I saw that an entry should be put inside the formatPatternsMap bean bu I have no idea what values should be put in order to get this working

Can someone help me configuring this?

THanks a lot in advance!!

Supun.

[supunthri]

 Hi,

I figured out what was wrong, I had to make the "detectCellType" property of "xlsExportParameters" bean to false in order for my formatPatternsMap s to work. 

THis is the entry I have put as a mapping,

 

    <util:map id="formatPatternsMap">

        <!-- entry key="¤ #,##0.00" value="$ #,##0.00"/-->

<entry key="#,##0.0 %" value="0.00%"/>

    </util:map> 

 

Cheers!

Supun