comparison rect.xsl @ 20:104ef815b0b0

fix false negs, add mouseover to show refs
author Henry S. Thompson <ht@markup.co.uk>
date Tue, 04 Apr 2017 18:04:13 +0100
parents 9b1b169dc8db
children 87e0d620deea
comparison
equal deleted inserted replaced
19:9b1b169dc8db 20:104ef815b0b0
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" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xpf="http://www.w3.org/2005/xpath-functions"> 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" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xpf="http://www.w3.org/2005/xpath-functions">
4 <xsl:strip-space elements="s:sheetData"/> 4 <xsl:strip-space elements="s:sheetData"/>
5 5
6 <xsl:variable name="refs" select="collection()[2]/*"/> 6 <xsl:variable name="refs" select="collection()[2]/*"/>
7 7
8 <xsl:key name="ref" match="e:ref" use="@r"/> 8 <xsl:key name="ref" match="e:ref" use="tokenize(@r)"/>
9 9
10 <xsl:function name="e:a2n" as="xs:integer"> 10 <xsl:function name="e:a2n" as="xs:integer">
11 <!-- Convert an alphabetic excel column 'index' into a number, 11 <!-- Convert an alphabetic excel column 'index' into a number,
12 a sort of base 26 + 1, since 'A' is 1 and 'AA' is 27 --> 12 a sort of base 26 + 1, since 'A' is 1 and 'AA' is 27 -->
13 <xsl:param name="aa" as="xs:string"/> 13 <xsl:param name="aa" as="xs:string"/>