Mercurial > hg > ooxml
annotate html.xsl @ 22:ca98c74a7cb1
towards var handling, no lookup yet
author | Henry S. Thompson <ht@markup.co.uk> |
---|---|
date | Wed, 05 Apr 2017 11:57:00 +0100 |
parents | 104ef815b0b0 |
children | 93fd0d532754 |
rev | line source |
---|---|
15
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
1 <?xml version='1.0'?> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
2 <!DOCTYPE doc SYSTEM "../../../lib/xml/xsl.dtd" > |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
3 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="3.0" xmlns:s="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:e="http://markup.co.uk/excel" exclude-result-prefixes="xs s xpf e" xmlns="http://www.w3.org/1999/xhtml" xmlns:xpf="http://www.w3.org/2005/xpath-functions"> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
4 <xsl:strip-space elements="e:a"/> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
5 <xsl:output omit-xml-declaration="yes"/> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
6 |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
7 <xsl:template match="/"> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
8 <html> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
9 <head> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
10 <style> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
11 body {font-family: 'DejaVu Sans Mono' , monospace} |
16
2bbd067529b6
improve efficiency, detect blank rows, don't type empty cells
Henry S. Thompson <ht@markup.co.uk>
parents:
15
diff
changeset
|
12 td {padding: 0} |
15
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
13 .e {color: red} |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
14 .formula {font-style: italic} |
19
9b1b169dc8db
use refs, but broken: doesn't deal with ranges (false negs) or external refs (false pos), and not finding things it should (e.g. kenneth_lay X88)
Henry S. Thompson <ht@markup.co.uk>
parents:
16
diff
changeset
|
15 .reffed {border: solid 1px black} |
15
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
16 </style> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
17 </head> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
18 <body> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
19 <xsl:apply-templates/> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
20 </body> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
21 </html> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
22 </xsl:template> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
23 |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
24 <xsl:template match="e:a"> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
25 <table> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
26 <thead/> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
27 <tbody><xsl:apply-templates/></tbody> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
28 </table> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
29 </xsl:template> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
30 |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
31 <xsl:template match="e:r"> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
32 <tr><xsl:apply-templates/></tr> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
33 <xsl:text> </xsl:text> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
34 </xsl:template> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
35 |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
36 <xsl:template match="e:c"> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
37 <td> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
38 <xsl:choose> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
39 <xsl:when test="text()"> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
40 <xsl:attribute name="class"> |
19
9b1b169dc8db
use refs, but broken: doesn't deal with ranges (false negs) or external refs (false pos), and not finding things it should (e.g. kenneth_lay X88)
Henry S. Thompson <ht@markup.co.uk>
parents:
16
diff
changeset
|
41 <xsl:value-of select="(., |
9b1b169dc8db
use refs, but broken: doesn't deal with ranges (false negs) or external refs (false pos), and not finding things it should (e.g. kenneth_lay X88)
Henry S. Thompson <ht@markup.co.uk>
parents:
16
diff
changeset
|
42 if (@f) then 'formula' else (), |
9b1b169dc8db
use refs, but broken: doesn't deal with ranges (false negs) or external refs (false pos), and not finding things it should (e.g. kenneth_lay X88)
Henry S. Thompson <ht@markup.co.uk>
parents:
16
diff
changeset
|
43 if (@r) then 'reffed' else ())"/> |
15
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
44 </xsl:attribute> |
20
104ef815b0b0
fix false negs, add mouseover to show refs
Henry S. Thompson <ht@markup.co.uk>
parents:
19
diff
changeset
|
45 <xsl:if test="@r"><xsl:attribute name="title"><xsl:value-of select="@r"/></xsl:attribute></xsl:if> |
15
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
46 <xsl:value-of select="."/></xsl:when> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
47 <xsl:otherwise><xsl:text> </xsl:text></xsl:otherwise> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
48 </xsl:choose> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
49 </td> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
50 </xsl:template> |
e767bef35bb9
default to ascii, but accept html.xsl for pretty
Henry S. Thompson <ht@markup.co.uk>
parents:
diff
changeset
|
51 </xsl:stylesheet> |