summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/unnamed-parent-styles
diff options
context:
space:
mode:
Diffstat (limited to 'test/xls-xml/unnamed-parent-styles')
-rw-r--r--test/xls-xml/unnamed-parent-styles/check.txt37
-rw-r--r--test/xls-xml/unnamed-parent-styles/input.xml447
2 files changed, 484 insertions, 0 deletions
diff --git a/test/xls-xml/unnamed-parent-styles/check.txt b/test/xls-xml/unnamed-parent-styles/check.txt
new file mode 100644
index 0000000..0772827
--- /dev/null
+++ b/test/xls-xml/unnamed-parent-styles/check.txt
@@ -0,0 +1,37 @@
+Sheet #1/0/0:string:"Date"
+Sheet #1/0/1:string:"Pinnacle Inlet"
+Sheet #1/0/2:string:"Pinnacle Sales"
+Sheet #1/0/3:string:"Cryo Inlet"
+Sheet #1/0/4:string:"Cryo Sales"
+Sheet #1/0/5:string:"NGL Sales"
+Sheet #1/0/6:string:"Anadarko Sales"
+Sheet #1/0/7:string:"Combined"
+Sheet #1/0/8:string:"Capitan"
+Sheet #1/0/9:string:"+ / -"
+Sheet #1/1/0:string:"8/19/2021"
+Sheet #1/2/0:string:"8/20/2021"
+Sheet #1/3/0:string:"8/21/2021"
+Sheet #1/4/0:string:"8/22/2021"
+Sheet #1/5/0:string:"8/23/2021"
+Sheet #1/6/0:string:"8/24/2021"
+Sheet #1/7/0:string:"8/25/2021"
+Sheet #1/8/0:string:"Aug-2021"
+Sheet #1/8/1:numeric:0
+Sheet #1/8/2:numeric:0
+Sheet #1/8/3:numeric:0
+Sheet #1/8/4:numeric:0
+Sheet #1/8/5:numeric:0
+Sheet #1/8/6:numeric:0
+Sheet #1/8/7:numeric:0
+Sheet #1/8/8:numeric:0
+Sheet #1/8/9:numeric:0
+Sheet #1/10/0:string:"Grand totals"
+Sheet #1/10/1:numeric:0
+Sheet #1/10/2:numeric:0
+Sheet #1/10/3:numeric:0
+Sheet #1/10/4:numeric:0
+Sheet #1/10/5:numeric:0
+Sheet #1/10/6:numeric:0
+Sheet #1/10/7:numeric:0
+Sheet #1/10/8:numeric:0
+Sheet #1/10/9:numeric:0
diff --git a/test/xls-xml/unnamed-parent-styles/input.xml b/test/xls-xml/unnamed-parent-styles/input.xml
new file mode 100644
index 0000000..6f124b5
--- /dev/null
+++ b/test/xls-xml/unnamed-parent-styles/input.xml
@@ -0,0 +1,447 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<?mso-application progid="Excel.Sheet"?>
+<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http:www.w3.org/TR/REC-html40">
+ <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+ <WindowHeight>600</WindowHeight>
+ <WindowWidth>800</WindowWidth>
+ <WindowTopX>0</WindowTopX>
+ <WindowTopY>0</WindowTopY>
+ <ProtectStructure>False</ProtectStructure>
+ <ProtectWindows>False</ProtectWindows>
+ </ExcelWorkbook>
+ <Styles>
+ <Style ss:ID="Default" ss:Name="Normal">
+ <Alignment ss:Horizontal="Left"/>
+ <Font ss:FontName="Arial" ss:Size="10" ss:Color="#000000"/>
+ <Borders>
+ <Border ss:Position="Left" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="d" ss:Parent="Default">
+ <NumberFormat ss:Format="dd/mm/yyyy"/>
+ </Style>
+ <Style ss:ID="s" ss:Parent="Default">
+ <Alignment ss:Horizontal="Left"/>
+ </Style>
+ <Style ss:ID="sb" ss:Parent="s">
+ <Font ss:Bold="1"/>
+ </Style>
+ <Style ss:ID="sgrey" ss:Parent="s">
+ <Interior ss:Color="#e4e4e4" ss:Pattern="Solid"/>
+ </Style>
+ <Style ss:ID="n" ss:Parent="Default">
+ <NumberFormat ss:Format="#,##0"/>
+ <Alignment ss:Horizontal="Right"/>
+ <Interior ss:Pattern="None"/>
+ </Style>
+ <Style ss:ID="n1" ss:Parent="n">
+ <NumberFormat ss:Format="#,##0.0"/>
+ </Style>
+ <Style ss:ID="n2" ss:Parent="n">
+ <NumberFormat ss:Format="#,##0.00"/>
+ </Style>
+ <Style ss:ID="h" ss:Parent="Default">
+ <Font ss:Bold="1" ss:Size="10"/>
+ <Borders>
+ <Border ss:Position="Left" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="hc" ss:Parent="h">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ </Style>
+ <Style ss:ID="hr" ss:Parent="h">
+ <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
+ </Style>
+ </Styles>
+ <ss:Worksheet ss:Name="Sheet #1">
+ <Table>
+ <Column ss:Width="130.0000"/>
+ <Column ss:Width="118.0000"/>
+ <Column ss:Width="130.0000"/>
+ <Column ss:Width="88.0000"/>
+ <Column ss:Width="99.0000"/>
+ <Column ss:Width="97.0000"/>
+ <Column ss:Width="137.0000"/>
+ <Column ss:Width="93.0000"/>
+ <Column ss:Width="74.0000"/>
+ <Column ss:Width="50.0000"/>
+ <Row>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Date</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Pinnacle Inlet</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Pinnacle Sales</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Cryo Inlet</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Cryo Sales</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">NGL Sales</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Anadarko Sales</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Combined</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">Capitan</Data>
+ </Cell>
+ <Cell ss:StyleID="h">
+ <Data ss:Type="String">+ / -</Data>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/19/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/20/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/21/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/22/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/23/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/24/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="d">
+ <Data ss:Type="String">8/25/2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String">Aug-2021</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String"/>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="sb">
+ <Data ss:Type="String">Grand totals</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ <Cell ss:StyleID="n1">
+ <Data ss:Type="Number">0.0</Data>
+ </Cell>
+ </Row>
+ </Table>
+ <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+ <Selected/>
+ <FreezePanes/>
+ <FrozenNoSplit/>
+ <SplitHorizontal>1</SplitHorizontal>
+ <TopRowBottomPane>1</TopRowBottomPane>
+ <ActivePane>2</ActivePane>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ </Pane>
+ <Pane>
+ <Number>2</Number>
+ <ActiveRow>2</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </ss:Worksheet>
+</Workbook>
generated by cgit v1.2.3 (git 2.39.1) at 2025-02-17 09:28:26 +0000