Subject: [xsl] stylesheet templates for OpenOffice spreadsheets|
From: Stan <sgd@xxxxxxxxxxxx>
Date: Thu, 01 Sep 2005 08:44:34 -0700
I've been taking a look at the xml format that the latest OpenOffice spreadsheets produce and was trying to come up with a generalized template that would extract the value from the nth row and mth column.
In general, OpenOffice expresses a spreadsheet grid like this (removing the cruft for illustrative purposes):
<table> <row><col>1</col><col>2</col><col>3</col></row> <row><col>4</col><col>5</col><col>6</col></row> <!-- and so on --> <table>
A template for this is fairly easy to reproduce because the mth column of the nth row is just "table/row[n]/col[m]". The problem comes in for spreadsheet grids that are sparsely or reduntantly filled. In this case, presumably to save space, the format looks something like this (assuming the first two columns of the first row are empty):
<table> <row><col number-columns-repeated="2"/><col>3</col></row> <row><col>4</col><col>5</col><col>6</col></row> </table>
This makes things much more difficult since now we have to account for the number-columns-repeated attribute. A generalized approach will now have to add all the number-columns-repeated values to find the mth column.
I thought that before I started working on producing this, I'd see if anyone has tackled this before or perhaps there is some magic xpath statement that eludes me.