Conversion of data in text format to number format in downloaded excel sheet

Issue:

[toc on_off::hide=1]

While downloading an Excel sheet using JExcelApiExporter object. We are able to get the data in text format.

Is there any way to get the data in number format so that it can be used in excel sheet formula?

Resolution:

In JasperReports Server's file:

WEB-INF/applicationContext.xml

There is a bean named "xlsExportParameters", please

1. change the "detectCellType" property's value to "true",
2. save the file and
3. restart JasperReports Server.

Ref. Case #00020702 -- 14:33, 22 June 2011 (UTC)