<property name=”net.sf.jasperreports.export.xls.detect.cell.type” value=”true”/> //导出时,保持Excel的Cell的数值类型
<property name=”net.sf.jasperreports.style.evaluation.time.enabled” value=”true”/> //当导出的报表中有evaluation time项时,需要启用该属性使style动态计算
<style name=”Base” isDefault=”true” hAlign=”Center” vAlign=”Middle” fontName=”Calibri” fontSize=”11″ pdfFontName=”Helvetica” pdfEncoding=”Cp1252″ isPdfEmbedded=”false”>
<box padding=”0″>
<topPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<leftPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<bottomPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<rightPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
</box>
</style>
<style name=”CellStyle” mode=”Opaque” hAlign=”Right” vAlign=”Middle” fontName=”Calibri” fontSize=”11″ pdfFontName=”Helvetica” pdfEncoding=”Cp1252″ isPdfEmbedded=”false”>
<box>
<topPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<leftPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<bottomPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<rightPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
</box>
<conditionalStyle>
<conditionExpression><![CDATA[new Boolean((($V{S1TP} + $V{S2TP}) – ($V{S1TS} + $V{S2TS})) + $V{D4SUM} < -(10E-6))]]></conditionExpression>
<style forecolor=”#FF0000″/>
</conditionalStyle>
<conditionalStyle>
<conditionExpression><![CDATA[new Boolean(($V{S1TP} + $V{S2TP}) – ($V{S1TS} + $V{S2TS}) < -(10E-6))]]></conditionExpression>
<style forecolor=”#FF0000″/>
</conditionalStyle>
</style>
<style name=”NumberStyle” mode=”Opaque” hAlign=”Right” vAlign=”Middle” fontName=”Calibri” fontSize=”11″ pdfFontName=”Helvetica” pdfEncoding=”Cp1252″ isPdfEmbedded=”false”>
<box padding=”0″>
<topPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<leftPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<bottomPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<rightPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
</box>
</style>
<style name=”LeftStyle” mode=”Opaque” hAlign=”Left” vAlign=”Middle” fontName=”Calibri” fontSize=”11″ pdfFontName=”Helvetica” pdfEncoding=”Cp1252″ isPdfEmbedded=”false”>
<box padding=”0″>
<topPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<leftPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<bottomPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<rightPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
</box>
</style>
<style name=”BoldStyle” mode=”Opaque” hAlign=”Center” vAlign=”Middle” fontName=”Calibri” fontSize=”11″ isBold=”true” pdfFontName=”Helvetica” pdfEncoding=”Cp1252″ isPdfEmbedded=”false”>
<box padding=”0″>
<topPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<leftPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<bottomPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
<rightPen lineWidth=”0.5″ lineStyle=”Solid” lineColor=”#000000″/>
</box>
</style>
<textField isBlankWhenNull=”true”>
<reportElement isPrintRepeatedValues=”false” x=”118″ y=”0″ width=”100″ height=”20″>
<property name=”net.sf.jasperreports.export.xls.formula” value=”SUM(C2:C5)”/> //开启Cell的单元格公式支持
</reportElement>
<textElement/>
<textFieldExpression class=”java.lang.Integer”><![CDATA[$V{Total Count}]]></textFieldExpression>
</textField>