Mercurial > hg > ooxml
changeset 56:6f62777aaecf
add * for locale-specific, maybe
| author | Henry S. Thompson <ht@markup.co.uk> |
|---|---|
| date | Wed, 31 May 2017 17:40:39 +0100 |
| parents | 05cf88c20cc5 |
| children | a783afa2b109 |
| files | fmt.xml |
| diffstat | 1 files changed, 10 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/fmt.xml Tue May 30 09:52:49 2017 +0100 +++ b/fmt.xml Wed May 31 17:40:39 2017 +0100 @@ -1,24 +1,28 @@ <?xml version='1.0'?> <fmts> - <!-- Built-in Excel cell format codes, from ISO/IEC 29500-1:2016(E) 18.8.30 --> + <!-- Built-in Excel cell format codes, from ISO/IEC 29500-1:2016(E) 18.8.30 + * denotes locale-dependent forms, guessed indirectly as the spec + doesn't provide this info :( + In particular, I don't yet know whether the number formats change with + the OS/locale settings or not.--> <fmt i="0" class="gen">General</fmt> <fmt i="1" class="num">0</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="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="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="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>