diff notes.txt @ 3:2c115aefde6b

beginning work on elaboration of worksheets
author Henry S. Thompson <ht@markup.co.uk>
date Sat, 01 Apr 2017 12:57:31 +0800
parents
children 01e80c7a9575
line wrap: on
line diff
--- /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