Mercurial > hg > ooxml
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