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 Area.ArrayFormula

Area.ArrayFormula

Description

=20

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 '}'.

=20
C#
=20
 public System.String ArrayFormula{ get; set; }
=20
=20
vb.net
=20
Public Property ArrayFormula() As String
=20
=20

Examples

=20
C#
=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
=20
vb.net
=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
------=_Part_9826_2016330791.1711704173914--