Message-ID: <1179654677.9827.1711704173930.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9826_2016330791.1711704173914" ------=_Part_9826_2016330791.1711704173914 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Sets or returns an array entered formula. An array entered formula is a = formula that can have multiple output values. To set an array entered formu= la, surround the formula string with a '{' and '}'.
=20public System.String ArrayFormula{ get; set; }=20
Public Property ArrayFormula() As String=20
//--- Get ArrayFormula string formula =3D a.ArrayFormula; //--- Set ArrayFormula Area a =3D ws.CreateArea(10,0,10,1); a.ArrayFormula =3D "{=3DTREND(A1:A10,B1:B10)}";=20
'--- Get ArrayFormula Dim formula As String =3D a.ArrayFormula '--- Set ArrayFormula Dim a As Area =3D ws.CreateArea(10,0,10,1) a.ArrayFormula =3D "{=3DTREND(A1:A10,B1:B10)}"=20