nicolaken 02/04/18 09:36:15
Modified: src/webapp/samples/poi/content samples.xml
src/webapp/samples/poi sitemap.xmap
Added: src/webapp/samples/poi/stylesheets statetax-esql2xls.xsl
statetax-sql2xls.xsl
src/webapp/samples/poi/content/dynamic statetax.xml
statetax2.xsp
Log:
Patch 8057 and 8062 from [EMAIL PROTECTED]
"[PATCH] new samples for HSSF Serializer."
Revision Changes Path
1.2 +10 -2 xml-cocoon2/src/webapp/samples/poi/content/samples.xml
Index: samples.xml
===================================================================
RCS file: /home/cvs/xml-cocoon2/src/webapp/samples/poi/content/samples.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- samples.xml 6 Mar 2002 17:00:28 -0000 1.1
+++ samples.xml 18 Apr 2002 16:36:14 -0000 1.2
@@ -9,6 +9,14 @@
<sample name="Xls serialized Hello World" href="hello.xls">Source is obtained
from original Cocoon demo (parent sitemap) and serialized with Poi Serializer after
being converted in Gnumeric xml format.</sample>
</group>
+ <group name="Dynamic Reporting samples">
+ <sample name="State Taxes Report" href="statetax.xls">Statistics from the
Ohio state revenue survice's <link
href="http://www.state.oh.us/tax/Publications/2001_Annual%20Report/8-revenue.pdf";>Revenue
Report</link> are queried from a database and shown in an XLS report.
+ </sample>
+
+ <sample name="ESQL State Taxes Report" href="statetax2.xls">A new report that
uses the newer <link href="http://xml.apache.org/cocoon/userdocs/xsp/esql.html";>ESQL
generator</link> and demonstrates groupings and other good stuff.
+ </sample>
+ </group>
+
<group name="Static xls serialization samples">
<sample name="web_page_sample" href="web_page_sample.xls">Web Page</sample>
<sample name="hypothetical-sales" href="hypothetical-sales.xls">Hypothetical
Sales</sample>
@@ -20,11 +28,11 @@
<sample name="test-math" href="test-math.xls">Math test</sample>
</group>
-<!--
+
<group name="Dynamic xls serialization samples">
<sample name="SQL query from Cocoon samples transformed in Gnumeric format
and serialized to xls." href="sql-xls/sql-page.xls">Source is obtained from Cocoon
original sql sample in parent sitemap.</sample>
</group>
--->
+
</samples>
1.2 +59 -3 xml-cocoon2/src/webapp/samples/poi/sitemap.xmap
Index: sitemap.xmap
===================================================================
RCS file: /home/cvs/xml-cocoon2/src/webapp/samples/poi/sitemap.xmap,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- sitemap.xmap 6 Mar 2002 17:00:28 -0000 1.1
+++ sitemap.xmap 18 Apr 2002 16:36:14 -0000 1.2
@@ -2,8 +2,14 @@
<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";>
<map:components>
- <map:generators default="file"/>
- <map:transformers default="xslt"/>
+ <map:generators default="file">
+
+ <map:generator label="content,data" logger="sitemap.generator.serverpages"
name="serverpages" pool-grow="2" pool-max="32" pool-min="4"
src="org.apache.cocoon.generation.ServerPagesGenerator"/>
+
+ </map:generators>
+ <map:transformers default="xslt">
+ <map:transformer logger="sitemap.transformer.sql" name="sql"
src="org.apache.cocoon.transformation.SQLTransformer"/>
+ </map:transformers>
<map:readers default="resource"/>
<map:serializers default="html">
<map:serializer name="xls" src="org.apache.cocoon.serialization.HSSFSerializer"
mime-type="application/vnd.ms-excel"/>
@@ -31,6 +37,40 @@
<map:serialize type="xls"/>
</map:match>
+ <map:match pattern="statetax-sql.xml">
+ <map:generate src="content/dynamic/statetax.xml"/>
+ <map:transform type="sql">
+ <map:parameter name="use-connection" value="personnel"/>
+ </map:transform>
+ <map:serialize type="xml"/>
+ </map:match>
+
+ <map:match pattern="statetax.xml">
+ <map:generate src="content/dynamic/statetax.xml"/>
+ <map:transform type="sql">
+ <map:parameter name="use-connection" value="personnel"/>
+ </map:transform>
+ <map:transform src="stylesheets/statetax-sql2xls.xsl"/>
+ <map:serialize type="xml"/>
+ </map:match>
+
+ <map:match pattern="statetax.xls">
+ <map:generate src="content/dynamic/statetax.xml"/>
+ <map:transform type="sql">
+ <map:parameter name="use-connection" value="personnel"/>
+ </map:transform>
+ <map:transform src="stylesheets/statetax-sql2xls.xsl"/>
+ <map:serialize type="xls"/>
+ </map:match>
+
+ <map:match pattern="statetax2.xls">
+ <map:generate src="content/dynamic/statetax2.xsp" type="serverpages"/>
+ <map:transform src="stylesheets/statetax-esql2xls.xsl"/>
+ <map:serialize type="xls"/>
+ </map:match>
+
+
+
<map:match pattern="*.xls">
<map:generate src="content/static/{1}.xml"/>
<map:serialize type="xls"/>
@@ -39,12 +79,28 @@
<map:match pattern="sql-xls/*.xls">
<map:generate src="context://docs/samples/sql/{1}.xml"/>
<map:transform type="sql">
- <map:parameter name="use-connection" value="personnel"/>
+ <map:parameter name="use-connecton" value="personnel"/>
</map:transform>
<map:transform src="stylesheets/simple-sql2xls.xsl"/>
<map:serialize type="xls"/>
</map:match>
+
+ <map:match pattern="xsp/*">
+ <map:generate src="content/dynamic/{1}.xsp" type="serverpages"/>
+<!-- <map:transform src="stylesheets/dynamic-page2html.xsl">
+ <map:parameter name="view-source" value="docs/samples/xsp/{1}.xsp"/>
+ </map:transform>-->
+ <map:serialize type="xml"/>
+ </map:match>
+
+
+ <map:match pattern="xspxml/*">
+ <map:generate src="content/dynamic/{1}.xsp" type="serverpages"/>
+ <map:transform src="stylesheets/statetax-esql2xls.xsl"/>
+ <map:serialize type="html"/>
+ </map:match>
+
<!-- ========================= Resources ================================ -->
1.1
xml-cocoon2/src/webapp/samples/poi/stylesheets/statetax-esql2xls.xsl
Index: statetax-esql2xls.xsl
===================================================================
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";
xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
<xsl:param name="view-source"/>
<xsl:template match="page">
<gmr:Workbook xmlns:gmr="http://www.gnumeric.org/v10.dtd";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.gnumeric.org/v8.xsd";>
<gmr:Attributes>
<gmr:Attribute>
<gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
<gmr:Attribute>
<gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
<gmr:Attribute>
<gmr:name>WorkbookView::show_notebook_tabs</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
<gmr:Attribute>
<gmr:name>WorkbookView::do_auto_completion</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
</gmr:Attributes>
<gmr:Summary>
<gmr:Item>
<gmr:name>application</gmr:name>
<gmr:val-string>gnumeric</gmr:val-string>
</gmr:Item>
</gmr:Summary>
<gmr:SheetNameIndex>
<gmr:SheetName>Sheet1</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Names/>
<gmr:Geometry Width="1166" Height="752"/>
<gmr:Sheets>
<gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
<gmr:Name>Sheet1</gmr:Name>
<gmr:MaxCol>9</gmr:MaxCol>
<gmr:MaxRow>12</gmr:MaxRow>
<gmr:Zoom>1.000000</gmr:Zoom>
<gmr:Names/>
<gmr:PrintInformation>
<gmr:Margins>
<gmr:top Points="28.3" PrefUnit="cm"/>
<gmr:bottom Points="28.3" PrefUnit="cm"/>
<gmr:left Points="28.3" PrefUnit="cm"/>
<gmr:right Points="28.3" PrefUnit="cm"/>
<gmr:header Points="14.2" PrefUnit="cm"/>
<gmr:footer Points="14.2" PrefUnit="cm"/>
</gmr:Margins>
<gmr:Scale type="percentage" percentage="100"/>
<gmr:vcenter value="0"/>
<gmr:hcenter value="0"/>
<gmr:grid value="0"/>
<gmr:even_if_only_styles value="0"/>
<gmr:monochrome value="0"/>
<gmr:draft value="0"/>
<gmr:titles value="0"/>
<gmr:repeat_top value=""/>
<gmr:repeat_left value=""/>
<gmr:order>r_then_d</gmr:order>
<gmr:orientation>landscape</gmr:orientation>
<gmr:Header Left="" Middle="&[TAB]" Right=""/>
<gmr:Footer Left="" Middle="Page &[PAGE]" Right=""/>
<gmr:paper>A4</gmr:paper>
</gmr:PrintInformation>
<gmr:Styles>
<gmr:StyleRegion startCol="0" startRow="5" endCol="4" endRow="5">
<gmr:Style HAlign="8" VAlign="2" WrapText="1" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="2" Color="0:0:0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="3" startRow="1" endCol="3" endRow="3">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="0" startRow="0" endCol="4" endRow="0">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="0" startRow="1" endCol="0" endRow="4">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="1" endCol="1" endRow="4">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="2" startRow="1" endCol="4" endRow="4">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="0" startRow="6" endCol="0" endRow="40">
<gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="10" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Times</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="2" Color="0:0:0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="6" endCol="1" endRow="40">
<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>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="2" startRow="6" endCol="2" endRow="40">
<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>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="3" startRow="6" endCol="3" endRow="40">
<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>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="4" startRow="6" endCol="4" endRow="40">
<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>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
</gmr:Styles>
<gmr:Cols DefaultSizePts="60">
<gmr:ColInfo No="0" Unit="128" MarginA="2" MarginB="2" HardSize="1"/>
<gmr:ColInfo No="1" Unit="120" MarginA="2" MarginB="2"/>
<gmr:ColInfo No="2" Unit="120" MarginA="2" MarginB="2" HardSize="1"/>
<gmr:ColInfo No="3" Unit="120" MarginA="2" MarginB="2" HardSize="1"/>
<gmr:ColInfo No="4" Unit="120" MarginA="2" MarginB="2" HardSize="1"/>
</gmr:Cols>
<gmr:Rows DefaultSizePts="12.8">
<gmr:RowInfo No="0" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"/>
<gmr:RowInfo No="1" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"
Count="5"/>
<gmr:RowInfo No="6" Unit="22.5" MarginA="1" MarginB="0" HardSize="1"/>
<gmr:RowInfo No="7" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"/>
<gmr:RowInfo No="8" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"
Count="1438"/>
</gmr:Rows>
<gmr:Selections CursorCol="0" CursorRow="1">
<gmr:Selection startCol="0" startRow="1" endCol="0" endRow="1"/>
</gmr:Selections>
<gmr:Cells>
<gmr:Cell Col="0" Row="0" ValueType="60">State: Ohio</gmr:Cell>
<gmr:Cell Col="4" Row="0" ValueType="60">Created 04/13/2002</gmr:Cell>
<gmr:Cell Col="2" Row="1" ValueType="60">State Revenue Report</gmr:Cell>
<gmr:Cell Col="2" Row="2" ValueType="60">by Category</gmr:Cell>
<gmr:Cell Col="2" Row="3" ValueType="60">01/01/2000 to 12/31/2001</gmr:Cell>
<gmr:Cell Col="1" Row="4" ValueType="60">2000</gmr:Cell>
<gmr:Cell Col="3" Row="4" ValueType="60">2001</gmr:Cell>
<gmr:Cell Col="0" Row="5" ValueType="60">Category</gmr:Cell>
<gmr:Cell Col="1" Row="5" ValueType="60">Gross Tax Collected</gmr:Cell>
<gmr:Cell Col="2" Row="5" ValueType="60">Net Tax Collected</gmr:Cell>
<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:Cells>
<gmr:SheetLayout TopLeft="A2"/>
<gmr:Solver TargetCol="-1" TargetRow="-1" ProblemType="1" Inputs=""/>
</gmr:Sheet>
</gmr:Sheets>
<gmr:UIData SelectedTab="0"/>
</gmr:Workbook>
</xsl:template>
<xsl:template match="content">
<xsl:for-each select="category">
<xsl:variable name="rownumber"><xsl:number value="position() +
7"/></xsl:variable>
<gmr:Cell Col="0" ValueType="60">
<xsl:attribute name="Row">
<xsl:value-of select="$rownumber"/>
</xsl:attribute>
<xsl:value-of select="name"/>
</gmr:Cell>
<xsl:for-each select="year">
<xsl:variable name="year"><xsl:number value="position()-1"/></xsl:variable>
<gmr:Cell ValueType="40">
<xsl:attribute name="Row">
<xsl:value-of select="$rownumber"/>
</xsl:attribute>
<xsl:attribute name="Col">
<xsl:value-of select="$year*2+1"/>
</xsl:attribute>
<xsl:value-of select="gross"/>
</gmr:Cell>
<gmr:Cell ValueType="40">
<xsl:attribute name="Row">
<xsl:value-of select="$rownumber"/>
</xsl:attribute>
<xsl:attribute name="Col">
<xsl:value-of select="$year*2+2"/>
</xsl:attribute>
<xsl:value-of select="net"/>
</gmr:Cell>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
<xsl:template match="sql:category">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="sql:grosstax_collected">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="sql:nettax_collected">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="sql:year">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="para"></xsl:template>
<xsl:template match="title"></xsl:template>
</xsl:stylesheet>
1.1
xml-cocoon2/src/webapp/samples/poi/stylesheets/statetax-sql2xls.xsl
Index: statetax-sql2xls.xsl
===================================================================
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";
xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
<xsl:param name="view-source"/>
<xsl:template match="page">
<gmr:Workbook xmlns:gmr="http://www.gnumeric.org/v10.dtd";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.gnumeric.org/v8.xsd";>
<gmr:Attributes>
<gmr:Attribute>
<gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
<gmr:Attribute>
<gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
<gmr:Attribute>
<gmr:name>WorkbookView::show_notebook_tabs</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
<gmr:Attribute>
<gmr:name>WorkbookView::do_auto_completion</gmr:name>
<gmr:type>4</gmr:type>
<gmr:value>TRUE</gmr:value>
</gmr:Attribute>
</gmr:Attributes>
<gmr:Summary>
<gmr:Item>
<gmr:name>application</gmr:name>
<gmr:val-string>gnumeric</gmr:val-string>
</gmr:Item>
</gmr:Summary>
<gmr:SheetNameIndex>
<gmr:SheetName>Sheet1</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Names/>
<gmr:Geometry Width="1166" Height="752"/>
<gmr:Sheets>
<gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
<gmr:Name>Sheet1</gmr:Name>
<gmr:MaxCol>9</gmr:MaxCol>
<gmr:MaxRow>12</gmr:MaxRow>
<gmr:Zoom>1.000000</gmr:Zoom>
<gmr:Names/>
<gmr:PrintInformation>
<gmr:Margins>
<gmr:top Points="28.3" PrefUnit="cm"/>
<gmr:bottom Points="28.3" PrefUnit="cm"/>
<gmr:left Points="28.3" PrefUnit="cm"/>
<gmr:right Points="28.3" PrefUnit="cm"/>
<gmr:header Points="14.2" PrefUnit="cm"/>
<gmr:footer Points="14.2" PrefUnit="cm"/>
</gmr:Margins>
<gmr:Scale type="percentage" percentage="100"/>
<gmr:vcenter value="0"/>
<gmr:hcenter value="0"/>
<gmr:grid value="0"/>
<gmr:even_if_only_styles value="0"/>
<gmr:monochrome value="0"/>
<gmr:draft value="0"/>
<gmr:titles value="0"/>
<gmr:repeat_top value=""/>
<gmr:repeat_left value=""/>
<gmr:order>r_then_d</gmr:order>
<gmr:orientation>landscape</gmr:orientation>
<gmr:Header Left="" Middle="&[TAB]" Right=""/>
<gmr:Footer Left="" Middle="Page &[PAGE]" Right=""/>
<gmr:paper>A4</gmr:paper>
</gmr:PrintInformation>
<gmr:Styles>
<gmr:StyleRegion startCol="0" startRow="5" endCol="3" endRow="5">
<gmr:Style HAlign="8" VAlign="2" WrapText="1" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="2" Color="0:0:0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="3" startRow="1" endCol="3" endRow="3">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">Comic Sans MS</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="0" startRow="0" endCol="3" endRow="0">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="0" startRow="1" endCol="0" endRow="4">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="1" endCol="1" endRow="4">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="2" startRow="1" endCol="3" endRow="4">
<gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="9" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="0" startRow="6" endCol="0" endRow="40">
<gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:CCCC:FFFF" PatternColor="0:0:0"
Format="General">
<gmr:Font Unit="10" Bold="1" Italic="1" Underline="0"
StrikeThrough="0">Times</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="2" Color="0:0:0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="6" endCol="1" endRow="40">
<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>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="2" startRow="6" endCol="2" endRow="40">
<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>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="3" startRow="6" endCol="3" endRow="40">
<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="General">
<gmr:Font Unit="10" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
<gmr:StyleBorder>
<gmr:Top Style="0"/>
<gmr:Bottom Style="0"/>
<gmr:Left Style="0"/>
<gmr:Right Style="0"/>
<gmr:Diagonal Style="0"/>
<gmr:Rev-Diagonal Style="0"/>
</gmr:StyleBorder>
</gmr:Style>
</gmr:StyleRegion>
</gmr:Styles>
<gmr:Cols DefaultSizePts="60">
<gmr:ColInfo No="0" Unit="128" MarginA="2" MarginB="2" HardSize="1"/>
<gmr:ColInfo No="1" Unit="84.8" MarginA="2" MarginB="2"/>
<gmr:ColInfo No="2" Unit="140" MarginA="2" MarginB="2" HardSize="1"/>
<gmr:ColInfo No="3" Unit="88.5" MarginA="2" MarginB="2" HardSize="1"/>
</gmr:Cols>
<gmr:Rows DefaultSizePts="12.8">
<gmr:RowInfo No="0" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"/>
<gmr:RowInfo No="1" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"
Count="5"/>
<gmr:RowInfo No="6" Unit="22.5" MarginA="1" MarginB="0" HardSize="1"/>
<gmr:RowInfo No="7" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"/>
<gmr:RowInfo No="8" Unit="12.8" MarginA="1" MarginB="0" HardSize="1"
Count="1438"/>
</gmr:Rows>
<gmr:Selections CursorCol="0" CursorRow="1">
<gmr:Selection startCol="0" startRow="1" endCol="0" endRow="1"/>
</gmr:Selections>
<gmr:Cells>
<gmr:Cell Col="0" Row="0" ValueType="60">State: Ohio</gmr:Cell>
<gmr:Cell Col="3" Row="0" ValueType="60">Created 04/13/2002</gmr:Cell>
<gmr:Cell Col="2" Row="1" ValueType="60">State Revenue Report</gmr:Cell>
<gmr:Cell Col="2" Row="2" ValueType="60">by Category</gmr:Cell>
<gmr:Cell Col="2" Row="3" ValueType="60">01/01/2000 to 12/31/2001</gmr:Cell>
<gmr:Cell Col="0" Row="5" ValueType="60">Category</gmr:Cell>
<gmr:Cell Col="1" Row="5" ValueType="60">Gross Tax Collected</gmr:Cell>
<gmr:Cell Col="2" Row="5" ValueType="60">Net Tax Collected</gmr:Cell>
<gmr:Cell Col="3" Row="5" ValueType="60">Year</gmr:Cell>
<xsl:apply-templates/>
</gmr:Cells>
<gmr:SheetLayout TopLeft="A2"/>
<gmr:Solver TargetCol="-1" TargetRow="-1" ProblemType="1" Inputs=""/>
</gmr:Sheet>
</gmr:Sheets>
<gmr:UIData SelectedTab="0"/>
</gmr:Workbook>
</xsl:template>
<xsl:template match="sql:rowset">
<xsl:for-each select="sql:row">
<xsl:variable name="rownumber"><xsl:number value="position() +
7"/></xsl:variable>
<gmr:Cell Col="0" ValueType="60">
<xsl:attribute name="Row">
<xsl:value-of select="position() + 5"/>
</xsl:attribute>
<xsl:value-of select="sql:category"/>
</gmr:Cell>
<gmr:Cell Col="1" ValueType="40">
<xsl:attribute name="Row">
<xsl:value-of select="position() + 5"/>
</xsl:attribute>
<xsl:apply-templates select="sql:grosstax_collected"/>
</gmr:Cell>
<gmr:Cell Col="2" ValueType="40">
<xsl:attribute name="Row">
<xsl:value-of select="position() + 5"/>
</xsl:attribute>
<xsl:value-of select="sql:nettax_collected"/>
</gmr:Cell>
<gmr:Cell Col="3" ValueType="40">
<xsl:attribute name="Row">
<xsl:value-of select="position() + 5"/>
</xsl:attribute>
<xsl:apply-templates select="sql:year"/>
</gmr:Cell>
<xsl:apply-templates select="sql:rowset"/>
</xsl:for-each>
</xsl:template>
<xsl:template match="sql:category">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="sql:grosstax_collected">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="sql:nettax_collected">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="sql:year">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="para"></xsl:template>
<xsl:template match="title"></xsl:template>
</xsl:stylesheet>
1.1 xml-cocoon2/src/webapp/samples/poi/content/dynamic/statetax.xml
Index: statetax.xml
===================================================================
<?xml version="1.0"?>
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<title>Ohio Tax</title>
<content>
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
<query>
select * from state_tax
</query>
</execute-query>
</content>
</page>
1.1 xml-cocoon2/src/webapp/samples/poi/content/dynamic/statetax2.xsp
Index: statetax2.xsp
===================================================================
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- CVS: $Id: statetax2.xsp,v 1.1 2002/04/18 16:36:15 nicolaken Exp $ -->
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<page>
<title>State Taxes</title>
<content>
<esql:connection>
<esql:pool>personnel</esql:pool>
<esql:execute-query>
<esql:query>
SELECT * FROM state_tax order by category, year
</esql:query>
<esql:results>
<esql:row-results>
<esql:group group-on="category">
<category><name><esql:get-string column='category'/></name>
<esql:member>
<esql:group group-on="year">
<year><number><esql:get-string column='year'/></number>
<esql:member>
<gross><esql:get-bigdecimal column='grosstax_collected'
format="##00.0#"/></gross>
<net><esql:get-bigdecimal column='nettax_collected'
format="##00.0#"/></net>
</esql:member>
</year>
</esql:group>
</esql:member>
</category>
</esql:group>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</content>
</page>
</xsp:page>
----------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
