I ask for a cheatsheet of XML relevant nodes of a Calc spreadsheet.
Why? I am trying to write an XSLT filter from a Calc spreadsheet in order to produce clean no-styling HTML5 output with column names as data-attributes and as part of tags attributes. Something like this (the extra CSS is also needed):
A B C
1 title1 title2 title3
2 numer string date
3 data1 data2 data3
4 data4 data5 data6
<html>
<head>...</head>
<body>
<table>
<tr>
<td data-title="title1" class="numeric">data1</td>
<td data-title="title2" class="string">data2</td>
<td data-title="title3" class="date">data3</td>
</tr>
<tr>
<td data-title="title1" class="numeric">data4</td>
<td data-title="title2" class="string">data5</td>
<td data-title="title3" class="date">data6</td>
</tr>
</table>
</body>
I’m a novice with XSLT. I am looking for an overview of all relevant XML nodes that are “produced” when we save a table in Calc, so I can write a proper XSLT filter. The one that comes with LO Calc doesn’t add the column names (entered by the user of the spreadsheet) as data attributes, besides it doesn’t output a clean HTML code. I want this because I want to have a responsive table in my web site. There is a nice technique for making responsive tables that I want to use.
So, I ask if someone knows where I can find all the XML nodes (an schematic view) so I can have an idea of what to process through. Examples of these nodes are: office:table, office-table-row, etc. I know they are visible if I open content.xml of any Calc file (with content), but I am looking for a “cheatsheet” or a diagram or a map of the ODF spec exclusively for spreadsheet tables, if available.
Or if you know of an XSLT filter that produces clean no-styling HTML, please show me where is it, then I can modify it to add the data attributes needed.
(I hope I’m clear enough to make myself understood. If not, please bear with me and point me with questions.)