summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/named-expression-sheet-local
diff options
context:
space:
mode:
Diffstat (limited to 'test/xls-xml/named-expression-sheet-local')
-rw-r--r--test/xls-xml/named-expression-sheet-local/check.txt22
-rw-r--r--test/xls-xml/named-expression-sheet-local/input.xml131
2 files changed, 153 insertions, 0 deletions
diff --git a/test/xls-xml/named-expression-sheet-local/check.txt b/test/xls-xml/named-expression-sheet-local/check.txt
new file mode 100644
index 0000000..321f221
--- /dev/null
+++ b/test/xls-xml/named-expression-sheet-local/check.txt
@@ -0,0 +1,22 @@
+Sheet1/0/0:numeric:1
+Sheet1/0/1:numeric:6
+Sheet1/1/0:numeric:2
+Sheet1/1/1:numeric:7
+Sheet1/2/0:numeric:3
+Sheet1/2/1:numeric:8
+Sheet1/3/0:numeric:4
+Sheet1/3/1:numeric:9
+Sheet1/4/0:numeric:5
+Sheet1/4/1:numeric:10
+Sheet1/6/0:formula:SUM(MyRange):27
+Sheet2/0/0:numeric:10
+Sheet2/0/1:numeric:20
+Sheet2/1/0:numeric:11
+Sheet2/1/1:numeric:21
+Sheet2/2/0:numeric:12
+Sheet2/2/1:numeric:22
+Sheet2/3/0:numeric:13
+Sheet2/3/1:numeric:23
+Sheet2/4/0:numeric:14
+Sheet2/4/1:numeric:24
+Sheet2/6/0:formula:SUM(MyRange):74
diff --git a/test/xls-xml/named-expression-sheet-local/input.xml b/test/xls-xml/named-expression-sheet-local/input.xml
new file mode 100644
index 0000000..46f110b
--- /dev/null
+++ b/test/xls-xml/named-expression-sheet-local/input.xml
@@ -0,0 +1,131 @@
+<?xml version="1.0"?>
+<?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">
+ <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
+ <Author>Kohei Yoshida</Author>
+ <LastAuthor>Kohei Yoshida</LastAuthor>
+ <Created>2017-02-08T02:38:34Z</Created>
+ <LastSaved>2017-02-08T02:41:56Z</LastSaved>
+ <Version>15.00</Version>
+ </DocumentProperties>
+ <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
+ <AllowPNG/>
+ </OfficeDocumentSettings>
+ <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+ <WindowHeight>14385</WindowHeight>
+ <WindowWidth>24000</WindowWidth>
+ <WindowTopX>0</WindowTopX>
+ <WindowTopY>0</WindowTopY>
+ <ProtectStructure>False</ProtectStructure>
+ <ProtectWindows>False</ProtectWindows>
+ </ExcelWorkbook>
+ <Styles>
+ <Style ss:ID="Default" ss:Name="Normal">
+ <Alignment ss:Vertical="Bottom"/>
+ <Borders/>
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
+ <Interior/>
+ <NumberFormat/>
+ <Protection/>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+ <Names>
+ <NamedRange ss:Name="MyRange" ss:RefersTo="=Sheet1!R1C1:R3C2"/>
+ </Names>
+ <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="7" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">1</Data><NamedCell ss:Name="MyRange"/></Cell>
+ <Cell><Data ss:Type="Number">6</Data><NamedCell ss:Name="MyRange"/></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">2</Data><NamedCell ss:Name="MyRange"/></Cell>
+ <Cell><Data ss:Type="Number">7</Data><NamedCell ss:Name="MyRange"/></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">3</Data><NamedCell ss:Name="MyRange"/></Cell>
+ <Cell><Data ss:Type="Number">8</Data><NamedCell ss:Name="MyRange"/></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">4</Data></Cell>
+ <Cell><Data ss:Type="Number">9</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">5</Data></Cell>
+ <Cell><Data ss:Type="Number">10</Data></Cell>
+ </Row>
+ <Row ss:Index="7" ss:AutoFitHeight="0">
+ <Cell ss:Formula="=SUM(MyRange)"><Data ss:Type="Number">27</Data></Cell>
+ </Row>
+ </Table>
+ <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+ <PageSetup>
+ <Header x:Margin="0.3"/>
+ <Footer x:Margin="0.3"/>
+ <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
+ </PageSetup>
+ <Unsynced/>
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>6</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+ <Worksheet ss:Name="Sheet2">
+ <Names>
+ <NamedRange ss:Name="MyRange" ss:RefersTo="=Sheet2!R4C1:R5C2"/>
+ </Names>
+ <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="7" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">10</Data></Cell>
+ <Cell><Data ss:Type="Number">20</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">11</Data></Cell>
+ <Cell><Data ss:Type="Number">21</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">12</Data></Cell>
+ <Cell><Data ss:Type="Number">22</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">13</Data><NamedCell ss:Name="MyRange"/></Cell>
+ <Cell><Data ss:Type="Number">23</Data><NamedCell ss:Name="MyRange"/></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell><Data ss:Type="Number">14</Data><NamedCell ss:Name="MyRange"/></Cell>
+ <Cell><Data ss:Type="Number">24</Data><NamedCell ss:Name="MyRange"/></Cell>
+ </Row>
+ <Row ss:Index="7" ss:AutoFitHeight="0">
+ <Cell ss:Formula="=SUM(MyRange)"><Data ss:Type="Number">74</Data></Cell>
+ </Row>
+ </Table>
+ <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+ <PageSetup>
+ <Header x:Margin="0.3"/>
+ <Footer x:Margin="0.3"/>
+ <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
+ </PageSetup>
+ <Unsynced/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>6</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>