# HG changeset patch
# User Henry S. Thompson <ht@markup.co.uk>
# Date 1491022651 -28800
# Node ID 2c115aefde6bae26d4b83c2bd264c08290db7a53
# Parent  263a1935d37df1d3b9835aa736b916f702b1df62
beginning work on elaboration of worksheets

diff -r 263a1935d37d -r 2c115aefde6b fmt.xml
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fmt.xml	Sat Apr 01 12:57:31 2017 +0800
@@ -0,0 +1,31 @@
+<?xml version='1.0'?>
+<fmts>
+ <!-- Built-in Excel cell format codes, from ISO/IEC 29500-1:2016(E) 18.8.30 -->
+ <fmt i="0" class="gen">General</fmt>
+ <fmt i="2" class="num">0.00</fmt>
+ <fmt i="3" class="num">#,##0</fmt>
+ <fmt i="4" class="num">#,##0.00</fmt>
+ <fmt i="9" class="num">0%</fmt>
+ <fmt i="10" class="num">0.00%</fmt>
+ <fmt i="11" class="num">0.00E+00</fmt>
+ <fmt i="12" class="rat"># ?/?</fmt>
+ <fmt i="13" class="rat"># ??/??</fmt>
+ <fmt i="14" class="date">mm-dd-yy</fmt>
+ <fmt i="15" class="date">d-mmm-yy</fmt>
+ <fmt i="16" class="date">d-mmm</fmt>
+ <fmt i="17" class="date">mmm-yy</fmt>
+ <fmt i="18" class="time">h:mm AM/PM</fmt>
+ <fmt i="19" class="time">h:mm:ss AM/PM</fmt>
+ <fmt i="20" class="time">h:mm</fmt>
+ <fmt i="21" class="time">h:mm:ss</fmt>
+ <fmt i="22" class="num">m/d/yy h:mm</fmt>
+ <fmt i="37" class="num">#,##0 ;(#,##0)</fmt>
+ <fmt i="38" class="num">#,##0 ;[Red](#,##0)</fmt>
+ <fmt i="39" class="num">#,##0.00;(#,##0.00)</fmt>
+ <fmt i="40" class="num">#,##0.00;[Red](#,##0.00)</fmt>
+ <fmt i="45" class="time">mm:ss</fmt>
+ <fmt i="46" class="time">[h]:mm:ss</fmt>
+ <fmt i="47" class="time">mmss.0</fmt>
+ <fmt i="48" class="num">##0.0E+0</fmt>
+ <fmt i="49" class="at">@</fmt>
+</fmts>
diff -r 263a1935d37d -r 2c115aefde6b format.xsl
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/format.xsl	Sat Apr 01 12:57:31 2017 +0800
@@ -0,0 +1,10 @@
+<?xml version='1.0'?>
+<!DOCTYPE doc SYSTEM "../../../lib/xml/xsl.dtd" >
+<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0" xmlns:s="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
+ <xsl:variable name="xldir" select="replace(base-uri(),'/[^/]*/[^/]*$','')"/>
+ <xsl:variable name="styles" select="document(concat($xldir,'/styles.xml'))/*"></xsl:variable>
+ <xsl:variable name="cellXfs" select="$styles//s:cellXfs"/>
+ <xsl:template match="/">
+  <xsl:message>|<xsl:value-of select="count($cellXfs/s:xf)"/>|</xsl:message>
+ </xsl:template>
+</xsl:stylesheet>
diff -r 263a1935d37d -r 2c115aefde6b notes.txt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/notes.txt	Sat Apr 01 12:57:31 2017 +0800
@@ -0,0 +1,37 @@
+You can't depend on 
+  <f si="..." t="shared"/>
+ That is, it's _true_, but you can have a table with shared formulae
+  that doesn't use it.  Compare M17:T28 (see below, uses shared) and
+  C17:J28 (mostly no shared) in sample4
+
+Looks like the result of a sweep-and-copy-{right,down} results in the
+_new_ cells covered showing as 'shared':
+
+         [ ][1][1][1][1]...
+         [2][2][2][2][2]...
+         [2][2][2][2][2]...
+         ...
+
+Presumably that one was right-then-down, down-then-right would give a
+slightly different pattern
+--------
+Thinking about a pipeline...
+ 1) convert all variable references into (verbose!) elts:
+     <!ELEMENT R EMPTY>
+     <!ATTLIST R
+        ac CDATA IMPLIED
+        rc CDATA IMPLIED
+        ar CDATA IMPLIED
+        rr CDATA IMPLIED>
+
+     where e.g. ac is 'absolute column'
+    'D6' --> <R rc='D' rr='6'/>
+     and
+    '$E5' --> <R ac='E' rr='5'/>
+--------
+Identifying dates is . . . tedious.  They will be ints or floats (?),
+with s="<int>", where the int is a 0-origin index into the list of
+<xf...numFmtId="<bin>".../>
+children of <cellXfs> in styles.xml, and bin is a built-in date format
+code, see 18.8.30 numFmt (Number Format) in ISO/IEC 29500-1:2016(E) ==
+C071691e.pdf