1 files changed, 244 insertions, 0 deletions
diff --git a/test/xls-xml/number-format/date-time.xml b/test/xls-xml/number-format/date-time.xml
new file mode 100644
index 0000000..45a56ec
--- /dev/null
+++ b/test/xls-xml/number-format/date-time.xml
@@ -0,0 +1,244 @@
+<?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>2019-08-26T12:53:11Z</Created>
+  <LastSaved>2019-08-26T12:59:50Z</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>10590</WindowHeight>
+  <WindowWidth>20550</WindowWidth>
+  <WindowTopX>32767</WindowTopX>
+  <WindowTopY>32767</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="s62">
+   <NumberFormat ss:Format="@"/>
+  </Style>
+  <Style ss:ID="s63">
+   <NumberFormat ss:Format="[$-F800]dddd\,\ mmmm\ dd\,\ yyyy"/>
+  </Style>
+  <Style ss:ID="s64">
+   <NumberFormat ss:Format="[ENG][$-409]mmmm\ d\,\ yyyy;@"/>
+  </Style>
+  <Style ss:ID="s65">
+   <NumberFormat ss:Format="m/d/yy;@"/>
+  </Style>
+  <Style ss:ID="s66">
+   <NumberFormat ss:Format="General Date"/>
+  </Style>
+  <Style ss:ID="s67">
+   <NumberFormat ss:Format="Medium Date"/>
+  </Style>
+  <Style ss:ID="s68">
+   <NumberFormat ss:Format="Short Time"/>
+  </Style>
+  <Style ss:ID="s70">
+   <NumberFormat ss:Format="Short Date"/>
+  </Style>
+  <Style ss:ID="s71">
+   <NumberFormat ss:Format="Long Time"/>
+  </Style>
+  <Style ss:ID="s72">
+   <NumberFormat ss:Format="Medium Time"/>
+  </Style>
+  <Style ss:ID="s73">
+   <NumberFormat ss:Format="Fixed"/>
+  </Style>
+  <Style ss:ID="s74">
+   <NumberFormat ss:Format="Standard"/>
+  </Style>
+  <Style ss:ID="s75">
+   <NumberFormat ss:Format="Percent"/>
+  </Style>
+  <Style ss:ID="s76">
+   <NumberFormat ss:Format="Scientific"/>
+  </Style>
+  <Style ss:ID="s77">
+   <NumberFormat ss:Format="Yes/No"/>
+  </Style>
+  <Style ss:ID="s78">
+   <NumberFormat ss:Format="True/False"/>
+  </Style>
+  <Style ss:ID="s79">
+   <NumberFormat ss:Format="On/Off"/>
+  </Style>
+  <Style ss:ID="s80">
+   <NumberFormat ss:Format="Currency"/>
+  </Style>
+  <Style ss:ID="s81">
+   <NumberFormat ss:Format="Euro Currency"/>
+  </Style>
+  <Style ss:ID="s91">
+   <NumberFormat/>
+  </Style>
+  <Style ss:ID="s92">
+   <Alignment ss:Vertical="Center"/>
+   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Color="#FFFFFF"/>
+   <NumberFormat ss:Format="[$€-2]\ #,##0.00;[Red]\-[$€-2]\ #,##0.00"/>
+  </Style>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+  <Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="19" x:FullColumns="1"
+   x:FullRows="1" ss:DefaultRowHeight="14.4375">
+   <Column ss:AutoFitWidth="0" ss:Width="123.75"/>
+   <Column ss:AutoFitWidth="0" ss:Width="168"/>
+   <Column ss:StyleID="s62" ss:Width="156"/>
+   <Column ss:AutoFitWidth="0" ss:Width="99.75"/>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Type</Data></Cell>
+    <Cell><Data ss:Type="String">Value</Data></Cell>
+    <Cell><Data ss:Type="String">String</Data></Cell>
+    <Cell><Data ss:Type="String">Format Name</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Date</Data></Cell>
+    <Cell ss:StyleID="s63"><Data ss:Type="DateTime">2003-09-24T00:00:00.000</Data></Cell>
+    <Cell><Data ss:Type="String">Wednesday, September 24, 2003</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Date</Data></Cell>
+    <Cell ss:StyleID="s64"><Data ss:Type="DateTime">2003-09-24T00:00:00.000</Data></Cell>
+    <Cell><Data ss:Type="String">September 24, 2003</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Date</Data></Cell>
+    <Cell ss:StyleID="s65"><Data ss:Type="DateTime">2003-09-24T00:00:00.000</Data></Cell>
+    <Cell><Data ss:Type="String">9/24/03</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Date &amp; Time</Data></Cell>
+    <Cell ss:StyleID="s66"><Data ss:Type="DateTime">2019-08-26T08:57:31.280</Data></Cell>
+    <Cell><Data ss:Type="String">8/26/2019 8:57</Data></Cell>
+    <Cell><Data ss:Type="String">General Date</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Date</Data></Cell>
+    <Cell ss:StyleID="s67"><Data ss:Type="DateTime">2019-08-26T08:57:31.280</Data></Cell>
+    <Cell><Data ss:Type="String">26-Aug-19</Data></Cell>
+    <Cell><Data ss:Type="String">Medium Date</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Time</Data></Cell>
+    <Cell ss:StyleID="s70"><Data ss:Type="DateTime">2019-08-26T08:57:31.280</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">8/26/2019</Data></Cell>
+    <Cell><Data ss:Type="String">Short Date</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Time</Data></Cell>
+    <Cell ss:StyleID="s71"><Data ss:Type="DateTime">2019-08-26T08:57:31.280</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">8:57:31 AM</Data></Cell>
+    <Cell><Data ss:Type="String">Long Time</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Time</Data></Cell>
+    <Cell ss:StyleID="s72"><Data ss:Type="DateTime">2019-08-26T08:57:31.280</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">8:57 AM</Data></Cell>
+    <Cell><Data ss:Type="String">Medium Time</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Time</Data></Cell>
+    <Cell ss:StyleID="s68"><Data ss:Type="DateTime">2019-08-26T08:57:31.280</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">8:57</Data></Cell>
+    <Cell><Data ss:Type="String">Short Time</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Number</Data></Cell>
+    <Cell ss:StyleID="s73"><Data ss:Type="Number">42</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">42.00</Data></Cell>
+    <Cell><Data ss:Type="String">Fixed</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Number</Data></Cell>
+    <Cell ss:StyleID="s74"><Data ss:Type="Number">42</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">42.00</Data></Cell>
+    <Cell><Data ss:Type="String">Standard</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Number</Data></Cell>
+    <Cell ss:StyleID="s75"><Data ss:Type="Number">42</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">4200.00%</Data></Cell>
+    <Cell><Data ss:Type="String">Percent</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Number</Data></Cell>
+    <Cell ss:StyleID="s76"><Data ss:Type="Number">42</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">4.20E+01</Data></Cell>
+    <Cell><Data ss:Type="String">Scientific</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Boolean</Data></Cell>
+    <Cell ss:StyleID="s77"><Data ss:Type="Number">1</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">Yes</Data></Cell>
+    <Cell><Data ss:Type="String">Yes/No</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Boolean</Data></Cell>
+    <Cell ss:StyleID="s78"><Data ss:Type="Number">1</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">True</Data></Cell>
+    <Cell><Data ss:Type="String">True/False</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Boolean</Data></Cell>
+    <Cell ss:StyleID="s79"><Data ss:Type="Number">1</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">On</Data></Cell>
+    <Cell><Data ss:Type="String">On/Off</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Currency</Data></Cell>
+    <Cell ss:StyleID="s80"><Data ss:Type="Number">1.52</Data></Cell>
+    <Cell><Data ss:Type="String" x:Ticked="1">$1.52</Data></Cell>
+    <Cell><Data ss:Type="String">Currency</Data></Cell>
+   </Row>
+   <Row ss:AutoFitHeight="0">
+    <Cell><Data ss:Type="String">Currency</Data></Cell>
+    <Cell ss:StyleID="s81"><Data ss:Type="Number">1.52</Data></Cell>
+    <Cell ss:StyleID="s92"/>
+    <Cell ss:StyleID="s91"><Data ss:Type="String">Euro Currency</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/>
+   <Print>
+    <ValidPrinterInfo/>
+    <HorizontalResolution>600</HorizontalResolution>
+    <VerticalResolution>600</VerticalResolution>
+   </Print>
+   <Selected/>
+   <Panes>
+    <Pane>
+     <Number>3</Number>
+     <ActiveRow>18</ActiveRow>
+     <ActiveCol>2</ActiveCol>
+    </Pane>
+   </Panes>
+   <ProtectObjects>False</ProtectObjects>
+   <ProtectScenarios>False</ProtectScenarios>
+  </WorksheetOptions>
+ </Worksheet>
+</Workbook>