a) not to recognize number formats (defined them as BigDecimal -- I have already set the JRXlsExporterParameter.IS_DETECT_CELL_TYPERXlsExporterParameter.IS_DETECT_CELL_TYPE property to TRUE, but no luck !)
b) not to recognize the functions/formula.
In my report, I am using a crosstab, which displays totals in its last row from the defined measures.
For instance, my actual_degree_qtyMeasure is defined as follows (exerpt from .jrxml):
Now, when I generate the excel file, the numbers are printed in the cells, but they are recognized as "general" format, not numbers, and obviously if I increase one of these data, the totals do not change.
I don't use these products but from what I've read in these forums the versions of libs you're using should make what you're trying to do possible. Is it that you're defining it as a <textField>?
Joined: Apr 26, 2010
I generated teh sample report "Groups" that comes with iReports 3.7.1, and the data you can see are rendered as Currency, and the total in "Total freight in this country" gives the correct total, but it is no longer a updatable formula that reflects the changes in the data it is supposed to sum.
I wonder whether there is a bug in 3.7.1