diff notes.txt @ 27:8309dcfce613

preparing for variable deref
author Henry S. Thompson <ht@markup.co.uk>
date Mon, 10 Apr 2017 17:29:24 +0100
parents 87e0d620deea
children c56a2e6990bd
line wrap: on
line diff
--- a/notes.txt	Fri Apr 07 18:42:47 2017 +0100
+++ b/notes.txt	Mon Apr 10 17:29:24 2017 +0100
@@ -28,22 +28,34 @@
     'D6' --> <R rc='D' rr='6'/>
      and
     '$E5' --> <R ac='E' rr='5'/>
+No, in fact -- absolute vs. 'variable' isn't relevant for our purposes.
+What we probably _do_ want is to add to every reference a _relative_
+version, i.e. +/-columnDelta, +/-rowDelta
 --------
 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
+C071691e.pdf  DONE
 ---------
 Decided to distinguish between type (num, date, str, err, ...) and
-class (cur, others to come?).  If non-standard code, just record that.
+class (cur(rency), others to come?).  If non-standard code, just record
+that.
+  The current pipe has two main steps, followed by an optional
+  prettifying step:
+    format.xsl (extracts type={bool,date,num,str,err}
+                         class={cur,[nothing else yet]}
+                         code={raw format code if not recognised}
+    rect.xsl   (fills in gaps, cuts down size, using only bdnse for
+                <t>[ype] with attrs c[lass]={c,...} and [co]d[e]=...
+ For now, just using first letters of type, class DONE
 ----------
 Hmm, looking at real data (kenneth_lay__19506), I see _lots_ of cells
 with (numerical) formats, but no content.  Where do I throw those
 away?  Can throw away empty _rows_ in rect.xsl, but for _cells_ have
 to wait for ascii.xsl or html.xsl.  But only copy type in in rect if
-there was content before.
+there was content before. DONE
 -----------
 Using attributes to hold space-separated lists is risky, as in
 refs.xsl output, is risky!  Fixed, see below.
@@ -56,11 +68,11 @@
   Sheet name to filename mapping for locals is in workbook.xml sheets/sheet[@name=$sname]/@sheetId
 -----------
 Switch to default namespace in order to reduce size and improve
-readability, and to elements instead of attributes
+readability, and to elements instead of attributes DONE
 -----------
 Should put another step after refs.xsl to compute a map from
 distinct-values of all targets to all the cells which use them
-(likewise ranges).  That really does mean we should move to elts for
+(likewise ranges) DONE. That really does mean we should move to elts for
 each ref or range, since at this point we want to compute vector
 representation as well, so we can identify projections