[xsl] stylesheet templates for OpenOffice spreadsheets

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):

    <!-- and so on -->

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):

    <row><col number-columns-repeated="2"/><col>3</col></row>

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.


Current Thread