How can I format a cell with a String as excel Text?

[tsukebumi]

I have a report with a field filled with a java.lang.String value. This report generates an excel file and I need to format it as text.

Currently using iReport 3.7.6 to generate de jrxml and jasper files and jasper 4.6.0 with a web application.

 

I tried setting pattern format for rhe cell in the jasper report to @, but I guess it is not valid.

On other 'numeric' fields with a given pattern I was able to use JRXlsAbstractExporterParameter.FORMAT_PATTERNS_MAP to give it a text format in excel with a map mapping the format '#,##0' to '@', but I have not been able to apply this way with the String field

How can I do it?

Could I do it with a newer jasper version ?

[hozawa]

You can't format text string with a "pattern". If the text field contains numeric, date, or currency, convert it to their respective data type and then do a format.