Before with the 1.9.4 version i have no problem but now with the 2.4.0 or 2.5.0 i have problem when i export a jasperreport document to XLS.
The numbers cells are always detected like a string and I have to convert cell numbers to be able to perform calculations such as sum.
In old forum i have find this message : "http://forge.ow2.org/forum/message.php?msg_id=10694", i have try to modify the 'net.sf.jasperreports.export.xls.detect.cell.type' to true but nothing.
In I-Report, if i try to export to XLS i have no problem so it's a spagobi problem.
Is it somebody have the same problem ?