Mercurial > hg > ooxml
changeset 57:a783afa2b109
much richer annotatation as json-formatted comment
author | Henry S. Thompson <ht@markup.co.uk> |
---|---|
date | Wed, 31 May 2017 17:41:18 +0100 |
parents | 6f62777aaecf |
children | adeb9575b273 |
files | sample2y.xlsx sample2y/workbook_indented.xml |
diffstat | 2 files changed, 105 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sample2y/workbook_indented.xml Wed May 31 17:41:18 2017 +0100 @@ -0,0 +1,105 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<workbook mc:Ignorable="x15" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"> +<fileVersion appName="xl" lastEdited="6" lowestEdited="5" rupBuild="14420"/> +<workbookPr defaultThemeVersion="124226"/> +<mc:AlternateContent xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"> +<mc:Choice Requires="x15"> +<x15ac:absPath url="C:\C64\home\ht\MT\sonra\OOXML\" xmlns:x15ac="http://schemas.microsoft.com/office/spreadsheetml/2010/11/ac"/> +</mc:Choice> +</mc:AlternateContent> +<bookViews> +<workbookView windowHeight="1890" windowWidth="11475" xWindow="120" yWindow="150"/> +</bookViews> +<sheets> +<sheet name="Sheet1" r:id="rId1" sheetId="1"/> +</sheets> +<definedNames> +<definedName + name="_R000" + comment="{type:row, + content:{type:string,static:yes,unique:no,nulls:yes}, + rel:{label:down,parent:_T000}}"> + "Sheet1!$A$1:$H$1" +</definedName> +<definedName + name="_R001" + comment="{type:column, + content:{type:date, static:yes,unique:no,nulls:no}, + format:{nf:14}, + rel:{parent:_T000}}"> + "Sheet1!$A$2:$A$61" +</definedName> +<definedName + name="_R002" + comment="{type:column, + content:{type:integer, static:yes,unique:no,nulls:no}, + format:{nf:1}, + rel:{parent:_T000,reffed:[_R003]}}"> + "Sheet1!$B$2:$B$61" +</definedName> +<definedName + name="_R003" + comment="{type:column, + content:{type:integer, static:yes,unique:yes,nulls:no}, + format:{nf:1}, + rel:{parent:_T000}}"> + "Sheet1!$D$2:$D$61" +</definedName> +<definedName + name="_R004" + comment="{type:column, + content:{type:integer, static:yes,unique:no,nulls:no}, + format:{nf:1}, + rel:{parent:_T000,reffed:[_R009]}}"> + "Sheet1!$E$2:$E$61" +</definedName> +<definedName + name="_R005" + comment="{type:column, + content:{type:integer, static:yes,unique:no,nulls:yes}, + format:{nf:1}, + rel:{parent:_T000,reffed:[_R003]}}"> + "Sheet1!$F$2:$F$61" +</definedName> +<definedName + name="_R006" + comment="{type:column, + content:{type:text, static:yes,unique:no,nulls:no}, + format:{nf:1}, + rel:{parent:_T000}}"> + "Sheet1!$H$2:$H$61" +</definedName> +<definedName + name="_R007" + comment="{type:column, + content:{type:text, static:yes,unique:no,nulls:no}, + format:{nf:1}, + rel:{parent:_T000}}"> + "Sheet1!$J$2:$J$61" +</definedName> +<definedName + name="_R008" + comment="{type:column, + content:{type:integer, static:no,unique:no,nulls:no}, + format:{nf:1}, + rel:{parent:_T000,refs:[_R001,_R005]}}"> + "Sheet1!$C$2:$C$61" +</definedName> +<definedName + name="_R009" + comment="{type:column, + content:{type:float, static:no,unique:no,nulls:yes}, + format:{nf:164,code:0.0%}, + rel:{parent:_T000,refs:[_R004,_R005]}}"> + "Sheet1!$G$2:$G$61" +</definedName> +<definedName + name="_T000" + comment="{type:table, + columns:{labels:_R000, + data:[_R001,_R002,_R008,_R003,_R004,_R005,_R009,_R006,_R007]}}"> + Sheet1!$A$1:$J$61 +</definedName> +</definedNames> +<calcPr calcId="162913"/> +</workbook>