Mercurial > hg > ooxml
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2:263a1935d37d | 3:2c115aefde6b |
|---|---|
| 1 You can't depend on | |
| 2 <f si="..." t="shared"/> | |
| 3 That is, it's _true_, but you can have a table with shared formulae | |
| 4 that doesn't use it. Compare M17:T28 (see below, uses shared) and | |
| 5 C17:J28 (mostly no shared) in sample4 | |
| 6 | |
| 7 Looks like the result of a sweep-and-copy-{right,down} results in the | |
| 8 _new_ cells covered showing as 'shared': | |
| 9 | |
| 10 [ ][1][1][1][1]... | |
| 11 [2][2][2][2][2]... | |
| 12 [2][2][2][2][2]... | |
| 13 ... | |
| 14 | |
| 15 Presumably that one was right-then-down, down-then-right would give a | |
| 16 slightly different pattern | |
| 17 -------- | |
| 18 Thinking about a pipeline... | |
| 19 1) convert all variable references into (verbose!) elts: | |
| 20 <!ELEMENT R EMPTY> | |
| 21 <!ATTLIST R | |
| 22 ac CDATA IMPLIED | |
| 23 rc CDATA IMPLIED | |
| 24 ar CDATA IMPLIED | |
| 25 rr CDATA IMPLIED> | |
| 26 | |
| 27 where e.g. ac is 'absolute column' | |
| 28 'D6' --> <R rc='D' rr='6'/> | |
| 29 and | |
| 30 '$E5' --> <R ac='E' rr='5'/> | |
| 31 -------- | |
| 32 Identifying dates is . . . tedious. They will be ints or floats (?), | |
| 33 with s="<int>", where the int is a 0-origin index into the list of | |
| 34 <xf...numFmtId="<bin>".../> | |
| 35 children of <cellXfs> in styles.xml, and bin is a built-in date format | |
| 36 code, see 18.8.30 numFmt (Number Format) in ISO/IEC 29500-1:2016(E) == | |
| 37 C071691e.pdf |