posted 13 years ago
The .excel version of my report seems
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):
<measure name="ACTUAL_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
<measureExpression><![CDATA[$F{ACTUAL_DEGREE_QTY}]]></measureExpression>
</measure>
The total $V{actual_degree_qtyMeasure} is defined as follows in the .jrxml
<textField>
<reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-29" width="25" height="29" backcolor="#CCCCFF"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ? "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
</textField>
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.
Any help, please ?