2 files changed, 122 insertions, 0 deletions
diff --git a/test/xls-xml/formula-array-1/check.txt b/test/xls-xml/formula-array-1/check.txt
new file mode 100644
index 0000000..2f2eacf
--- /dev/null
+++ b/test/xls-xml/formula-array-1/check.txt
@@ -0,0 +1,23 @@
+Sheet1/0/0:numeric:1
+Sheet1/0/2:numeric:4
+Sheet1/0/3:numeric:5
+Sheet1/0/4:numeric:6
+Sheet1/1/0:numeric:2
+Sheet1/2/0:numeric:3
+Sheet1/4/2:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:4
+Sheet1/4/3:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:5
+Sheet1/4/4:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:6
+Sheet1/5/2:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:8
+Sheet1/5/3:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:10
+Sheet1/5/4:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:12
+Sheet1/6/2:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:12
+Sheet1/6/3:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:15
+Sheet1/6/4:formula:{MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])}:18
+Sheet1/8/0:numeric:2
+Sheet1/8/2:numeric:10
+Sheet1/8/3:numeric:12
+Sheet1/8/5:formula:{MMULT(RC[-5]:R[1]C[-5],RC[-3]:RC[-2])}:20
+Sheet1/8/6:formula:{MMULT(RC[-5]:R[1]C[-5],RC[-3]:RC[-2])}:24
+Sheet1/9/0:numeric:4
+Sheet1/9/5:formula:{MMULT(RC[-5]:R[1]C[-5],RC[-3]:RC[-2])}:40
+Sheet1/9/6:formula:{MMULT(RC[-5]:R[1]C[-5],RC[-3]:RC[-2])}:48
diff --git a/test/xls-xml/formula-array-1/input.xml b/test/xls-xml/formula-array-1/input.xml
new file mode 100644
index 0000000..206c810
--- /dev/null
+++ b/test/xls-xml/formula-array-1/input.xml
@@ -0,0 +1,99 @@
+<?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-04-05T01:00:20Z</Created>
+  <LastSaved>2018-04-08T03:39:54Z</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>12225</WindowHeight>
+  <WindowWidth>28800</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">
+  <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="10" x:FullColumns="1"
+   x:FullRows="1" ss:DefaultRowHeight="15">
+   <Row>
+    <Cell><Data ss:Type="Number">1</Data></Cell>
+    <Cell ss:Index="3"><Data ss:Type="Number">4</Data></Cell>
+    <Cell><Data ss:Type="Number">5</Data></Cell>
+    <Cell><Data ss:Type="Number">6</Data></Cell>
+   </Row>
+   <Row>
+    <Cell><Data ss:Type="Number">2</Data></Cell>
+   </Row>
+   <Row>
+    <Cell><Data ss:Type="Number">3</Data></Cell>
+   </Row>
+   <Row ss:Index="5">
+    <Cell ss:Index="3" ss:ArrayRange="RC:R[2]C[2]"
+     ss:Formula="=MMULT(R[-4]C[-2]:R[-2]C[-2],R[-4]C:R[-4]C[2])"><Data
+      ss:Type="Number">4</Data></Cell>
+    <Cell><Data ss:Type="Number">5</Data></Cell>
+    <Cell><Data ss:Type="Number">6</Data></Cell>
+   </Row>
+   <Row>
+    <Cell ss:Index="3"><Data ss:Type="Number">8</Data></Cell>
+    <Cell><Data ss:Type="Number">10</Data></Cell>
+    <Cell><Data ss:Type="Number">12</Data></Cell>
+   </Row>
+   <Row>
+    <Cell ss:Index="3"><Data ss:Type="Number">12</Data></Cell>
+    <Cell><Data ss:Type="Number">15</Data></Cell>
+    <Cell><Data ss:Type="Number">18</Data></Cell>
+   </Row>
+   <Row ss:Index="9">
+    <Cell><Data ss:Type="Number">2</Data></Cell>
+    <Cell ss:Index="3"><Data ss:Type="Number">10</Data></Cell>
+    <Cell><Data ss:Type="Number">12</Data></Cell>
+    <Cell ss:Index="6" ss:ArrayRange="RC:R[1]C[1]"
+     ss:Formula="=MMULT(RC[-5]:R[1]C[-5],RC[-3]:RC[-2])"><Data ss:Type="Number">20</Data></Cell>
+    <Cell><Data ss:Type="Number">24</Data></Cell>
+   </Row>
+   <Row>
+    <Cell><Data ss:Type="Number">4</Data></Cell>
+    <Cell ss:Index="6"><Data ss:Type="Number">40</Data></Cell>
+    <Cell><Data ss:Type="Number">48</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>
+   <Selected/>
+   <Panes>
+    <Pane>
+     <Number>3</Number>
+     <ActiveRow>11</ActiveRow>
+    </Pane>
+   </Panes>
+   <ProtectObjects>False</ProtectObjects>
+   <ProtectScenarios>False</ProtectScenarios>
+  </WorksheetOptions>
+ </Worksheet>
+</Workbook>