Subscribers,

For those unaware, Gnumeric is an Xml-based spreadsheet (see below, edited for brevity).

The objective is to use a web browser to transform the xml spreadsheet file into text output (\t=keyboard tab), i.e.:

text test1 \t other textx \t 100
text test2 \t other texty \t 200
text test2 \t other texty \t 700
text test2 \t other texty \t 300
text test2 \t other texty \t 250
text test3 \t other textz \t 400

An Xslt file was created:

<?xml version="1.0"?>
<xsl:stylesheet
	version="2.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns='http://www.w3.org/1999/xhtml'>
	<xsl:output
		method="text"
		encoding="utf-8"
		indent="no"
		omit-xml-declaration="yes"
		media-type="text/plain"
		standalone="yes"
		/>
	<xsl:template match='Cells'>
		<xsl:apply-templates select='Cell'/>
	</xsl:template>
</xsl:stylesheet>

The Jedit text editor was used with the plugin XLST processor (uses Xalan Java), which produces the text file (below). Why does the text file contain text from nodes outside the nodes 'Cells' and 'Cell'?

      4
      WorkbookView::show_horizontal_scrollbar
      TRUE

      4
      WorkbookView::show_vertical_scrollbar
      TRUE

      4
      WorkbookView::show_notebook_tabs
      TRUE

      4
      WorkbookView::do_auto_completion
      TRUE

      4
      WorkbookView::is_protected
      FALSE

      2014-09-12T09:56:44Z
      2014-09-12T09:53:41Z

    Sheet1
    Sheet2
    Sheet3

      Sheet1
      2
      6
      1

          Print_Area
          #REF!
          A1

          Sheet_Title
          "Sheet1"
          A1

        d_then_r
        portrait

iso_a4




Sans

        columnnamea
        columnnameb
        columnnamec
        text test1
        other textx
        100
        text test2
        other texty
        200
        text test2
        other texty
        700
        text test2
        other texty
        300
        text test2
        other texty
        250
        text test3
        other textz
        400

      Sheet2
      -1
      -1
      1

          Print_Area
          #REF!
          A1

          Sheet_Title
          "Sheet2"
          A1

        d_then_r
        portrait

iso_a4




Sans

      Sheet3
      -1
      -1
      1

          Print_Area
          #REF!
          A1

          Sheet_Title
          "Sheet3"
          A1

        d_then_r
        portrait

iso_a4




Sans















Gnumeric Xml file (named test.gnumeric in the Xhtml further below):

<?xml version="1.0" encoding="UTF-8"?>
<!--attempted to add a stylesheet but unable to view transformed document in web browser
<?xml-stylesheet type="text/xsl" href="testgnumeric.xslt"?>
-->
<gnm:Workbook xmlns:gnm="http://www.gnumeric.org/v10.dtd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.gnumeric.org/v9.xsd">
<gnm:Version Epoch="1" Major="10" Minor="2" Full="1.10.2"/>
<gnm:Attributes>
...
</gnm:Attributes>
<office:document-meta
...
</office:document-meta>
<gnm:Calculation ManualRecalc="0" EnableIteration="1" MaxIterations="100" IterationTolerance="0.001" FloatRadix="2" FloatDigits="53"/>
<gnm:SheetNameIndex>
...
</gnm:SheetNameIndex>
<gnm:Geometry Width="1080" Height="586"/>
<gnm:Sheets>
<gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
<gnm:Name>Sheet1</gnm:Name>
<gnm:MaxCol>2</gnm:MaxCol>
<gnm:MaxRow>6</gnm:MaxRow>
<gnm:Zoom>1</gnm:Zoom>
<gnm:Names>
<gnm:Name>
...
</gnm:Name>
</gnm:Names>
<gnm:PrintInformation>
...
</gnm:PrintInformation>
<gnm:Styles>
...
</gnm:Styles>
<gnm:Cols DefaultSizePts="48">
<gnm:ColInfo No="0" Unit="48" Count="3"/>
</gnm:Cols>
<gnm:Rows DefaultSizePts="12.75">
<gnm:RowInfo No="0" Unit="13.5" Count="7"/>
</gnm:Rows>
<gnm:Selections CursorCol="0" CursorRow="0">
<gnm:Selection startCol="0" startRow="0" endCol="0" endRow="0"/>
</gnm:Selections>
<gnm:Cells>
<gnm:Cell Row="0" Col="0" ValueType="60">columnnamea</gnm:Cell>
<gnm:Cell Row="0" Col="1" ValueType="60">columnnameb</gnm:Cell>
<gnm:Cell Row="0" Col="2" ValueType="60">columnnamec</gnm:Cell>
<gnm:Cell Row="1" Col="0" ValueType="60">text test1</gnm:Cell>
<gnm:Cell Row="1" Col="1" ValueType="60">other textx</gnm:Cell>
<gnm:Cell Row="1" Col="2" ValueType="40">100</gnm:Cell>
<gnm:Cell Row="2" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="2" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="2" Col="2" ValueType="40">200</gnm:Cell>
<gnm:Cell Row="3" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="3" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="3" Col="2" ValueType="40">700</gnm:Cell>
<gnm:Cell Row="4" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="4" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="4" Col="2" ValueType="40">300</gnm:Cell>
<gnm:Cell Row="5" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="5" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="5" Col="2" ValueType="40">250</gnm:Cell>
<gnm:Cell Row="6" Col="0" ValueType="60">text test3</gnm:Cell>
<gnm:Cell Row="6" Col="1" ValueType="60">other textz</gnm:Cell>
<gnm:Cell Row="6" Col="2" ValueType="40">400</gnm:Cell>
</gnm:Cells>
<gnm:SheetLayout TopLeft="A1"/>
<gnm:Solver ProblemType="0" MaxTime="30" MaxIter="100" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0"/>
</gnm:Sheet>
</gnm:Sheets>
<gnm:UIData SelectedTab="0"/>
</gnm:Workbook>

An Xhtml file was created (below): is it possible to use a web browser to perform the transformation, via linking to both the Xslt and Xml files?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML Basic 1.1//EN" "http://www.w3.org/TR/xhtml-basic/xhtml-basic11.dtd">
<html xmlns='http://www.w3.org/1999/xhtml' lang='en' xml:lang='en'>
<head>
<title>spreadsheet transformation</title>
<link rel="stylesheet" type="application/xslt+xml" href="testgnumeric.xslt" media="screen"/>
<link rel='stylesheet' href='styles.css' type='text/css' media='screen' />
</head>
<body>
<form
action="test.gnumeric"
method='post'
name=''
>
<p>
<select
name=''
>
<option>
...
</option>
</select>
<input
type="submit"
value='send'
/>
</p>
</form>
</body>
</html>
<!--

-->