<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="XlsFormulaReport" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
	<title>
		<band height="250">
			<staticText>
				<reportElement x="0" y="0" width="595" height="150"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="22"/>
				</textElement>
				<text><![CDATA[XLS Formula Report]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-1" x="0" y="150" width="280" height="23">
					<property name="net.sf.jasperreports.export.xls.formula" value="7"/>
				</reportElement>
				<box rightPadding="5">
					<topPen lineWidth="4.0" lineColor="#C0C0C0"/>
					<leftPen lineWidth="4.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="1.0" lineColor="#C0C0C0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[Integer.valueOf(7)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="280" y="150" width="315" height="23"/>
				<box leftPadding="5">
					<topPen lineWidth="4.0" lineColor="#C0C0C0"/>
					<leftPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="2.0" lineColor="#C0C0C0"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[ =   A2 cell content]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-2" x="0" y="173" width="280" height="23">
					<property name="net.sf.jasperreports.export.xls.formula" value="4"/>
				</reportElement>
				<box rightPadding="5">
					<leftPen lineWidth="4.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="1.0" lineColor="#C0C0C0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[Integer.valueOf(4)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="280" y="173" width="315" height="23"/>
				<box leftPadding="5">
					<leftPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="2.0" lineColor="#C0C0C0"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[ =   A3 cell content]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-3" x="0" y="196" width="280" height="23">
					<property name="net.sf.jasperreports.export.xls.formula" value="SUM(A2,A3)"/>
				</reportElement>
				<box rightPadding="5">
					<leftPen lineWidth="4.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="1.0" lineColor="#C0C0C0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[Integer.valueOf(0)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="280" y="196" width="315" height="23"/>
				<box leftPadding="5">
					<leftPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="2.0" lineColor="#C0C0C0"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[ =   SUM(A2,A3)  in xls,  or 0 in pdf/html/rtf/txt/csv format]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-4" x="0" y="219" width="280" height="23">
					<propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA["A" + Integer.valueOf(2).intValue() + "-A" + 3]]></propertyExpression>
				</reportElement>
				<box rightPadding="5">
					<leftPen lineWidth="4.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="2.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="1.0" lineColor="#C0C0C0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[Integer.valueOf(0)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="280" y="219" width="315" height="23"/>
				<box leftPadding="5">
					<leftPen lineWidth="1.0" lineColor="#C0C0C0"/>
					<bottomPen lineWidth="2.0" lineColor="#C0C0C0"/>
					<rightPen lineWidth="2.0" lineColor="#C0C0C0"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[ =   A2 - A3  in xls,  or 0 in pdf/html/rtf/txt/csv format]]></text>
			</staticText>
		</band>
	</title>
</jasperReport>
