froehlich 02/05/05 10:57:46
Modified: src/webapp/samples/poi/stylesheets statetax-esql2xls.xsl
Log:
applied patch from [EMAIL PROTECTED] (Andy Oliver).
Formula support for HSSF Serializer.
Revision Changes Path
1.2 +8 -4
xml-cocoon2/src/webapp/samples/poi/stylesheets/statetax-esql2xls.xsl
Index: statetax-esql2xls.xsl
===================================================================
RCS file:
/home/cvs/xml-cocoon2/src/webapp/samples/poi/stylesheets/statetax-esql2xls.xsl,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- statetax-esql2xls.xsl 18 Apr 2002 16:36:14 -0000 1.1
+++ statetax-esql2xls.xsl 5 May 2002 17:57:46 -0000 1.2
@@ -173,7 +173,7 @@
</gmr:Style>
</gmr:StyleRegion>
- <gmr:StyleRegion startCol="1" startRow="6" endCol="1" endRow="40">
+ <gmr:StyleRegion startCol="1" startRow="6" endCol="1" endRow="41">
<gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="0"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="#,##0.00_);[Red](#,##0.00)">
<gmr:Font Unit="10" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
@@ -187,7 +187,7 @@
</gmr:Style>
</gmr:StyleRegion>
- <gmr:StyleRegion startCol="2" startRow="6" endCol="2" endRow="40">
+ <gmr:StyleRegion startCol="2" startRow="6" endCol="2" endRow="41">
<gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="0"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="#,##0.00_);[Red](#,##0.00)">
<gmr:Font Unit="10" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
@@ -202,7 +202,7 @@
</gmr:StyleRegion>
- <gmr:StyleRegion startCol="3" startRow="6" endCol="3" endRow="40">
+ <gmr:StyleRegion startCol="3" startRow="6" endCol="3" endRow="41">
<gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="0"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="#,##0.00_);[Red](#,##0.00)">
<gmr:Font Unit="10" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
@@ -216,7 +216,7 @@
</gmr:Style>
</gmr:StyleRegion>
- <gmr:StyleRegion startCol="4" startRow="6" endCol="4" endRow="40">
+ <gmr:StyleRegion startCol="4" startRow="6" endCol="4" endRow="41">
<gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="0"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="#,##0.00_);[Red](#,##0.00)">
<gmr:Font Unit="10" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
@@ -266,6 +266,10 @@
<gmr:Cell Col="3" Row="5" ValueType="60">Gross Tax Collected</gmr:Cell>
<gmr:Cell Col="4" Row="5" ValueType="60">Net Tax Collected</gmr:Cell>
<xsl:apply-templates/>
+ <gmr:Cell Col="1" Row="40">=SUM(B7:B40)</gmr:Cell>
+ <gmr:Cell Col="2" Row="40">=SUM(C7:C40)</gmr:Cell>
+ <gmr:Cell Col="3" Row="40">=SUM(D7:D40)</gmr:Cell>
+ <gmr:Cell Col="4" Row="40">=SUM(E7:E40)</gmr:Cell>
</gmr:Cells>
<gmr:SheetLayout TopLeft="A2"/>
<gmr:Solver TargetCol="-1" TargetRow="-1" ProblemType="1" Inputs=""/>
----------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
