1 files changed, 290 insertions, 0 deletions
diff --git a/test/xls-xml/text-alignment/input.xml b/test/xls-xml/text-alignment/input.xml
new file mode 100644
index 0000000..c66e45d
--- /dev/null
+++ b/test/xls-xml/text-alignment/input.xml
@@ -0,0 +1,290 @@
+<?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>2018-01-06T03:30:32Z</Created>
+  <LastSaved>2018-01-11T02:10:53Z</LastSaved>
+  <Version>16.00</Version>
+ </DocumentProperties>
+ <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
+  <AllowPNG/>
+ </OfficeDocumentSettings>
+ <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+  <WindowHeight>9855</WindowHeight>
+  <WindowWidth>11580</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>
+  <Style ss:ID="s16">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
+  </Style>
+  <Style ss:ID="s17">
+   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+  </Style>
+  <Style ss:ID="s18">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
+  </Style>
+  <Style ss:ID="s19">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom" ss:Indent="2"/>
+  </Style>
+  <Style ss:ID="s20">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom" ss:Indent="1"/>
+  </Style>
+  <Style ss:ID="s21">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Bottom" ss:Indent="1"/>
+  </Style>
+  <Style ss:ID="s22">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Bottom" ss:Indent="2"/>
+  </Style>
+  <Style ss:ID="s23">
+   <Alignment ss:Vertical="Center"/>
+  </Style>
+  <Style ss:ID="s24">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
+  </Style>
+  <Style ss:ID="s25">
+   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
+  </Style>
+  <Style ss:ID="s26">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Center"/>
+  </Style>
+  <Style ss:ID="s27">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:Indent="1"/>
+  </Style>
+  <Style ss:ID="s28">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:Indent="2"/>
+  </Style>
+  <Style ss:ID="s29">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Center" ss:Indent="1"/>
+  </Style>
+  <Style ss:ID="s30">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Center" ss:Indent="2"/>
+  </Style>
+  <Style ss:ID="s31">
+   <Alignment ss:Vertical="Top"/>
+  </Style>
+  <Style ss:ID="s32">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>
+  </Style>
+  <Style ss:ID="s33">
+   <Alignment ss:Horizontal="Center" ss:Vertical="Top"/>
+  </Style>
+  <Style ss:ID="s34">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>
+  </Style>
+  <Style ss:ID="s35">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:Indent="1"/>
+  </Style>
+  <Style ss:ID="s36">
+   <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:Indent="2"/>
+  </Style>
+  <Style ss:ID="s37">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:Indent="1"/>
+  </Style>
+  <Style ss:ID="s38">
+   <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:Indent="2"/>
+  </Style>
+  <Style ss:ID="s39">
+   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+    ss:Bold="1"/>
+  </Style>
+  <Style ss:ID="s40">
+   <Alignment ss:Vertical="Justify" ss:WrapText="1"/>
+  </Style>
+  <Style ss:ID="s41">
+   <Alignment ss:Horizontal="Justify" ss:Vertical="Bottom" ss:WrapText="1"/>
+  </Style>
+  <Style ss:ID="s119">
+   <Alignment ss:Horizontal="Distributed" ss:Vertical="Distributed" ss:WrapText="1"/>
+  </Style>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+  <Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="28" x:FullColumns="1"
+   x:FullRows="1" ss:DefaultRowHeight="15">
+   <Column ss:AutoFitWidth="0" ss:Width="74.25"/>
+   <Column ss:AutoFitWidth="0" ss:Width="68.25"/>
+   <Column ss:AutoFitWidth="0" ss:Width="135"/>
+   <Row>
+    <Cell ss:StyleID="s39"><Data ss:Type="String">Horizontal</Data></Cell>
+    <Cell ss:StyleID="s39"><Data ss:Type="String">Vertical</Data></Cell>
+    <Cell ss:StyleID="s39"><Data ss:Type="String">Content</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">General</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s16"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s17"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s18"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left Indent 1</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s20"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left Indent 2</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s19"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right Indent 1</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s21"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right Indent 2</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s22"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">General</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s23"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s24"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s25"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s26"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left Indent 1</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s27"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left Indent 2</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s28"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right Indent 1</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s29"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right Indent 2</Data></Cell>
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell ss:StyleID="s30"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">General</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s31"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s32"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Center</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s33"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s34"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left Indent 1</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s35"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Left Indent 2</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s36"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right Indent 1</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s37"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="24.9375">
+    <Cell><Data ss:Type="String">Right Indent 2</Data></Cell>
+    <Cell><Data ss:Type="String">Top</Data></Cell>
+    <Cell ss:StyleID="s38"><Data ss:Type="String">Text</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="52.5">
+    <Cell><Data ss:Type="String">General</Data></Cell>
+    <Cell><Data ss:Type="String">Justify</Data></Cell>
+    <Cell ss:StyleID="s40"><Data ss:Type="String">Vertical justification looks like this.</Data></Cell>
+   </Row>
+   <Row ss:Height="45">
+    <Cell><Data ss:Type="String">Justify</Data></Cell>
+    <Cell><Data ss:Type="String">Bottom</Data></Cell>
+    <Cell ss:StyleID="s41"><Data ss:Type="String">Horizontal justification looks like this.</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0" ss:Height="43.5">
+    <Cell><Data ss:Type="String">Distributed</Data></Cell>
+    <Cell><Data ss:Type="String">Distributed</Data></Cell>
+    <Cell ss:StyleID="s119"><Data ss:Type="String">Both horizontally and vertically distributed.</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>
+   <Print>
+    <ValidPrinterInfo/>
+    <HorizontalResolution>600</HorizontalResolution>
+    <VerticalResolution>600</VerticalResolution>
+   </Print>
+   <Selected/>
+   <TopRowVisible>18</TopRowVisible>
+   <Panes>
+    <Pane>
+     <Number>3</Number>
+     <ActiveRow>27</ActiveRow>
+     <ActiveCol>2</ActiveCol>
+    </Pane>
+   </Panes>
+   <ProtectObjects>False</ProtectObjects>
+   <ProtectScenarios>False</ProtectScenarios>
+  </WorksheetOptions>
+ </Worksheet>
+</Workbook>