Array Formulas
An array-entered formula shall be represented in XML just like other formulas, except that the array-entered formula’s <f>
element shall contain an attribute @t
, whose value shall be array
.
For a single-cell formula, the
@r
attribute shall designate that cell. example: : Consider the array formula
SUM(C11:C12*D11:D12)
. The corresponding XML might be as follows:<row r="11" spans="2:4" ht="300"> <c r="B11" s="16"> <f t="array" r="B11">SUM(C11:C12*D11:D12)</f> <v>110</v> </c> <c r="C11" s="4"> <v>10</v> </c> <c r="D11" s="0"> <v>3</v> </c> </row> <row r="12" spans="2:4" ht="285"> <c r="C12" s="4"> <v>20</v> </c> <c r="D12" s="0"> <v>4</v> </c> </row>
As this formula is a single-cell formula, the @r
attribute contains the name of that cell, B11
. ]
For a multi-cell formula, the
@r
attribute of the top-left cell of the range of cells to which that formula applies shall designate the range of cells to which that formula applies. The <c>
elements for all cells except the top-left cell in that range shall not have an @f
element; however, they shall each have a <v>
element. example: : Consider the array formula
A1:A3*B1:B3
, which is applied to the cell range C1:C3
. The corresponding XML might be as follows:<row r="1" spans="1:3"> <c r="A1" s="0"> <v>112</v> </c> <c r="B1" s="0"> <v>2.34</v> </c> <c r="C1" s="0"> <f t="array" r="C1:C3">A1:A3*B1:B3</f> <v>262.08</v> </c> </row> <row r="2" spans="1:3"> <c r="A2" s="0"> <v>209</v> </c> <c r="B2" s="0"> <v>1.28</v> </c> <c r="C2" s="0"> <v>267.52</v> </c> </row> <row r="3" spans="1:3"> <c r="A3" s="0"> <v>128</v> </c> <c r="B3" s="0"> <v>3.12</v> </c> <c r="C3" s="0"> <v>399.36</v> </c> </row>
As this formula is a multi-cell formula, the @r
attribute of cell C1
contains the name of that cell range, C1:C3
, and cells C2
and C3
do not have an <f>
element. ]