Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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 formula, surround the formula string with a '{' and '}'.

Signature
C#
C#
 public System.String ArrayFormula{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property ArrayFormula() As String
{signature}
{example}{code:csharp|title=C#}
Example
Code Block
csharp
csharp
titleC#

//--- Get ArrayFormula
string formula = a.ArrayFormula;

//--- Set ArrayFormula
Area a = ws.CreateArea(10,0,10,1);
a.ArrayFormula = "{=TREND(A1:A10,B1:B10)}";
{code} {code:vbnet|title=
Code Block
vbnet
vbnet
titlevb.net
}

'--- Get ArrayFormula
Dim formula As String = a.ArrayFormula

'--- Set ArrayFormula
Dim a As Area = ws.CreateArea(10,0,10,1)
a.ArrayFormula = "{=TREND(A1:A10,B1:B10)}"
{code} {example} {scrollbar}
Scrollbar