summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/table-offset
diff options
context:
space:
mode:
Diffstat (limited to 'test/xls-xml/table-offset')
-rw-r--r--test/xls-xml/table-offset/check.txt7
-rw-r--r--test/xls-xml/table-offset/input.xml50
2 files changed, 57 insertions, 0 deletions
diff --git a/test/xls-xml/table-offset/check.txt b/test/xls-xml/table-offset/check.txt
new file mode 100644
index 0000000..faf6c69
--- /dev/null
+++ b/test/xls-xml/table-offset/check.txt
@@ -0,0 +1,7 @@
+Sheet1/1/2:string:"Title"
+Sheet1/2/1:numeric:111
+Sheet1/2/2:string:"aaaa"
+Sheet1/2/3:numeric:36251
+Sheet1/3/1:numeric:2222
+Sheet1/3/2:string:"bbbb"
+Sheet1/3/3:numeric:36252
diff --git a/test/xls-xml/table-offset/input.xml b/test/xls-xml/table-offset/input.xml
new file mode 100644
index 0000000..b3770ad
--- /dev/null
+++ b/test/xls-xml/table-offset/input.xml
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<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">
+ <Styles>
+ <Style ss:ID="s1">
+ <Font ss:Bold="1" ss:Color="#008000"/>
+ <NumberFormat ss:Format="0.00_ ;[Red]\-0.00\ "/>
+ </Style>
+ <Style ss:ID="s2">
+ <Font ss:Color="red"/>
+ </Style>
+ <Style ss:ID="s3">
+ <Font ss:Color="blue"/>
+ <NumberFormat ss:Format="yyyy/mm\-dd;@"/>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+ <Table ss:TopCell="2" ss:LeftCell="2" ss:DefaultColumnWidth="20" ss:ExpandedColumnCount="3">
+ <Column ss:StyleID="s1" ss:AutoFitWidth="1"/>
+ <Column ss:StyleID="s2"/>
+ <Column ss:StyleID="s3" ss:Index="3" ss:AutoFitWidth="1"/>
+ <Row ss:StyleID="s1">
+ <Cell ss:Index="2">
+ <Data ss:Type="String">Title</Data>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell>
+ <Data ss:Type="Number">111</Data>
+ </Cell>
+ <Cell>
+ <Data ss:Type="String">aaaa</Data>
+ </Cell>
+ <Cell>
+ <Data ss:Type="DateTime">1999-04-01</Data>
+ </Cell>
+ </Row>
+ <Row>
+ <Cell>
+ <Data ss:Type="Number">2222</Data>
+ </Cell>
+ <Cell>
+ <Data ss:Type="String">bbbb</Data>
+ </Cell>
+ <Cell>
+ <Data ss:Type="DateTime">1999-04-02T00:00:00.000</Data>
+ </Cell>
+ </Row>
+ </Table>
+ </Worksheet>
+</Workbook>