Skip to content

Instantly share code, notes, and snippets.

@fwilhe2

fwilhe2/flat-ods.diff

Created January 15, 2023 20:49
Show Gist options
  • Save fwilhe2/02333b23673f80c866375f309bf90866 to your computer and use it in GitHub Desktop.
Save fwilhe2/02333b23673f80c866375f309bf90866 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
flat-ods.diff
diff --git Yearly-Sold-Units.fods Yearly-Sold-Units.fods
index 70fd852..12b3941 100644
--- Yearly-Sold-Units.fods
+++ Yearly-Sold-Units.fods
@@ -1,19 +1,19 @@
<?xml version="1.0" encoding="UTF-8"?>
<office:document xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:rpt="http://openoffice.org/2005/report" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" office:version="1.3" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
- <office:meta><meta:creation-date>2023-01-15T21:31:25.595825980</meta:creation-date><dc:date>2023-01-15T21:37:56.580183159</dc:date><meta:editing-duration>PT6M33S</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOffice/7.4.4.2$Linux_X86_64 LibreOffice_project/4eb4660f0b3234c9c640fffa203ebed9f9db1745</meta:generator><meta:document-statistic meta:table-count="1" meta:cell-count="24" meta:object-count="0"/></office:meta>
+ <office:meta><meta:creation-date>2023-01-15T21:31:25.595825980</meta:creation-date><dc:date>2023-01-15T21:44:12.017214011</dc:date><meta:editing-duration>PT8M14S</meta:editing-duration><meta:editing-cycles>2</meta:editing-cycles><meta:generator>LibreOffice/7.4.4.2$Linux_X86_64 LibreOffice_project/4eb4660f0b3234c9c640fffa203ebed9f9db1745</meta:generator><meta:document-statistic meta:table-count="1" meta:cell-count="29" meta:object-count="0"/></office:meta>
<office:settings>
<config:config-item-set config:name="ooo:view-settings">
<config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item>
<config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item>
- <config:config-item config:name="VisibleAreaWidth" config:type="int">11289</config:config-item>
+ <config:config-item config:name="VisibleAreaWidth" config:type="int">13547</config:config-item>
<config:config-item config:name="VisibleAreaHeight" config:type="int">2709</config:config-item>
<config:config-item-map-indexed config:name="Views">
<config:config-item-map-entry>
<config:config-item config:name="ViewId" config:type="string">view1</config:config-item>
<config:config-item-map-named config:name="Tables">
<config:config-item-map-entry config:name="Sheet1">
- <config:config-item config:name="CursorPositionX" config:type="int">1</config:config-item>
+ <config:config-item config:name="CursorPositionX" config:type="int">5</config:config-item>
<config:config-item config:name="CursorPositionY" config:type="int">6</config:config-item>
<config:config-item config:name="ActiveSplitRange" config:type="short">2</config:config-item>
<config:config-item config:name="PositionLeft" config:type="int">0</config:config-item>
@@ -74,9 +74,9 @@
<config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item>
<config:config-item config:name="LinkUpdateMode" config:type="short">3</config:config-item>
<config:config-item config:name="LoadReadonly" config:type="boolean">false</config:config-item>
- <config:config-item config:name="PrinterName" config:type="string"/>
+ <config:config-item config:name="PrinterName" config:type="string">Generic Printer</config:config-item>
<config:config-item config:name="PrinterPaperFromSetup" config:type="boolean">false</config:config-item>
- <config:config-item config:name="PrinterSetup" config:type="base64Binary"/>
+ <config:config-item config:name="PrinterSetup" config:type="base64Binary">lAH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAtQAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCmNvbGxhdGU9ZmFsc2UKbWFyZ2luYWRqdXN0bWVudD0wLDAsMCwwCmNvbG9yZGVwdGg9MjQKcHNsZXZlbD0wCnBkZmRldmljZT0xCmNvbG9yZGV2aWNlPTAKUFBEQ29udGV4dERhdGEKUGFnZVNpemU6QTQAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY=</config:config-item>
<config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item>
<config:config-item config:name="RasterResolutionX" config:type="int">1000</config:config-item>
<config:config-item config:name="RasterResolutionY" config:type="int">1000</config:config-item>
@@ -216,7 +216,7 @@
<office:spreadsheet>
<table:table table:name="Sheet1" table:style-name="ta1">
<table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
- <table:table-column table:style-name="co1" table:number-columns-repeated="4" table:default-cell-style-name="ce1"/>
+ <table:table-column table:style-name="co1" table:number-columns-repeated="5" table:default-cell-style-name="ce1"/>
<table:table-row table:style-name="ro1">
<table:table-cell/>
<table:table-cell table:style-name="Default" office:value-type="float" office:value="2019" calcext:value-type="float">
@@ -231,6 +231,9 @@
<table:table-cell table:style-name="Default" office:value-type="float" office:value="2022" calcext:value-type="float">
<text:p>2022</text:p>
</table:table-cell>
+ <table:table-cell table:style-name="Default" office:value-type="float" office:value="2023" calcext:value-type="float">
+ <text:p>2023</text:p>
+ </table:table-cell>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="string" calcext:value-type="string">
@@ -248,6 +251,9 @@
<table:table-cell office:value-type="float" office:value="23577" calcext:value-type="float">
<text:p>23.577</text:p>
</table:table-cell>
+ <table:table-cell office:value-type="float" office:value="91761" calcext:value-type="float">
+ <text:p>91.761</text:p>
+ </table:table-cell>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="string" calcext:value-type="string">
@@ -265,6 +271,9 @@
<table:table-cell office:value-type="float" office:value="43194" calcext:value-type="float">
<text:p>43.194</text:p>
</table:table-cell>
+ <table:table-cell office:value-type="float" office:value="72794" calcext:value-type="float">
+ <text:p>72.794</text:p>
+ </table:table-cell>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="string" calcext:value-type="string">
@@ -282,10 +291,13 @@
<table:table-cell office:value-type="float" office:value="13048" calcext:value-type="float">
<text:p>13.048</text:p>
</table:table-cell>
+ <table:table-cell office:value-type="float" office:value="133684" calcext:value-type="float">
+ <text:p>133.684</text:p>
+ </table:table-cell>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell/>
- <table:table-cell table:style-name="Default" table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="Default" table:number-columns-repeated="5"/>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="string" calcext:value-type="string">
@@ -303,6 +315,9 @@
<table:table-cell table:formula="of:=SUM(_Y2022)" office:value-type="float" office:value="79819" calcext:value-type="float">
<text:p>79.819</text:p>
</table:table-cell>
+ <table:table-cell table:formula="of:=SUM(_Y2023)" office:value-type="float" office:value="298239" calcext:value-type="float">
+ <text:p>298.239</text:p>
+ </table:table-cell>
</table:table-row>
</table:table>
<table:named-expressions>
@@ -310,6 +325,7 @@
<table:named-range table:name="_Y2020" table:base-cell-address="$Sheet1.$C$2" table:cell-range-address="$Sheet1.$C$2:.$C$4"/>
<table:named-range table:name="_Y2021" table:base-cell-address="$Sheet1.$D$2" table:cell-range-address="$Sheet1.$D$2:.$D$4"/>
<table:named-range table:name="_Y2022" table:base-cell-address="$Sheet1.$E$2" table:cell-range-address="$Sheet1.$E$2:.$E$4"/>
+ <table:named-range table:name="_Y2023" table:base-cell-address="$Sheet1.$F$2" table:cell-range-address="$Sheet1.$F$2:.$F$4"/>
</table:named-expressions>
</office:spreadsheet>
</office:body>
Raw
pretty-xml.diff
diff --git Yearly-Sold-Units.fods Yearly-Sold-Units.fods
index 70fd852..12b3941 100644
--- Yearly-Sold-Units.fods
+++ Yearly-Sold-Units.fods
@@ -6,6 +6,7 @@
<cell R="1" C="3" value="2020" type="float"> <text><![CDATA[2020]]></text> </cell>
<cell R="1" C="4" value="2021" type="float"> <text><![CDATA[2021]]></text> </cell>
<cell R="1" C="5" value="2022" type="float"> <text><![CDATA[2022]]></text> </cell>
+ <cell R="1" C="6" value="2023" type="float"> <text><![CDATA[2023]]></text> </cell>
</row>
<row>
<cell R="2" C="1" type="string"> <text><![CDATA[Item A]]></text> </cell>
@@ -13,6 +14,7 @@
<cell R="2" C="3" value="77224" type="float"> <text><![CDATA[77.224]]></text> </cell>
<cell R="2" C="4" value="15264" type="float"> <text><![CDATA[15.264]]></text> </cell>
<cell R="2" C="5" value="23577" type="float"> <text><![CDATA[23.577]]></text> </cell>
+ <cell R="2" C="6" value="91761" type="float"> <text><![CDATA[91.761]]></text> </cell>
</row>
<row>
<cell R="3" C="1" type="string"> <text><![CDATA[Item B]]></text> </cell>
@@ -20,6 +22,7 @@
<cell R="3" C="3" value="60575" type="float"> <text><![CDATA[60.575]]></text> </cell>
<cell R="3" C="4" value="38667" type="float"> <text><![CDATA[38.667]]></text> </cell>
<cell R="3" C="5" value="43194" type="float"> <text><![CDATA[43.194]]></text> </cell>
+ <cell R="3" C="6" value="72794" type="float"> <text><![CDATA[72.794]]></text> </cell>
</row>
<row>
<cell R="4" C="1" type="string"> <text><![CDATA[Item C]]></text> </cell>
@@ -27,6 +30,7 @@
<cell R="4" C="3" value="26467" type="float"> <text><![CDATA[26.467]]></text> </cell>
<cell R="4" C="4" value="33109" type="float"> <text><![CDATA[33.109]]></text> </cell>
<cell R="4" C="5" value="13048" type="float"> <text><![CDATA[13.048]]></text> </cell>
+ <cell R="4" C="6" value="133684" type="float"> <text><![CDATA[133.684]]></text> </cell>
</row>
<row>
<cell R="5" C="1" />
@@ -38,6 +42,7 @@
<cell R="6" C="3" value="164266" formula="of:=SUM(_Y2020)" type="float"> <text><![CDATA[164.266]]></text> </cell>
<cell R="6" C="4" value="87040" formula="of:=SUM(_Y2021)" type="float"> <text><![CDATA[87.04]]></text> </cell>
<cell R="6" C="5" value="79819" formula="of:=SUM(_Y2022)" type="float"> <text><![CDATA[79.819]]></text> </cell>
+ <cell R="6" C="6" value="298239" formula="of:=SUM(_Y2023)" type="float"> <text><![CDATA[298.239]]></text> </cell>
</row>
<named-expressions>
</named-expressions>
@@ -47,6 +52,7 @@
<named-range name="_Y2020" base-cell-address="$Sheet1.$C$2" cell-range-address="$Sheet1.$C$2:.$C$4" />
<named-range name="_Y2021" base-cell-address="$Sheet1.$D$2" cell-range-address="$Sheet1.$D$2:.$D$4" />
<named-range name="_Y2022" base-cell-address="$Sheet1.$E$2" cell-range-address="$Sheet1.$E$2:.$E$4" />
+ <named-range name="_Y2023" base-cell-address="$Sheet1.$F$2" cell-range-address="$Sheet1.$F$2:.$F$4" />
</named-expressions>
</spreadsheet>
Raw
pretty-yaml.diff
diff --git Yearly-Sold-Units.fods Yearly-Sold-Units.fods
index 70fd852..12b3941 100644
--- Yearly-Sold-Units.fods
+++ Yearly-Sold-Units.fods
@@ -24,6 +24,11 @@ tables:
text: 2022
R: 1
C: 5
+ - value: "2023"
+ type: float
+ text: 2023
+ R: 1
+ C: 6
- cells:
- type: string
text: Item A
@@ -49,6 +54,11 @@ tables:
text: 23.577
R: 2
C: 5
+ - value: "91761"
+ type: float
+ text: 91.761
+ R: 2
+ C: 6
- cells:
- type: string
text: Item B
@@ -74,6 +84,11 @@ tables:
text: 43.194
R: 3
C: 5
+ - value: "72794"
+ type: float
+ text: 72.794
+ R: 3
+ C: 6
- cells:
- type: string
text: Item C
@@ -99,6 +114,11 @@ tables:
text: 13.048
R: 4
C: 5
+ - value: "133684"
+ type: float
+ text: 133.684
+ R: 4
+ C: 6
- cells:
- R: 5
C: 1
@@ -133,6 +153,12 @@ tables:
formula: of:=SUM(_Y2022)
R: 6
C: 5
+ - value: "298239"
+ type: float
+ text: 298.239
+ formula: of:=SUM(_Y2023)
+ R: 6
+ C: 6
namedExpressions:
namedRanges:
- name: _Y2019
@@ -147,4 +173,7 @@ namedExpressions:
- name: _Y2022
baseCellAddress: $Sheet1.$E$2
cellRangeAddress: $Sheet1.$E$2:.$E$4
+ - name: _Y2023
+ baseCellAddress: $Sheet1.$F$2
+ cellRangeAddress: $Sheet1.$F$2:.$F$4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment