Signature |
---|
C# | C# | Wiki Markup |
---|
{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 '\}'.{excerpt}
{signature:C#}
public System.String ArrayFormula{ get; set; }
|
Signature |
---|
{signature}{signature:vb.net | vb.net | }
Public Property ArrayFormula() As String
|
Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{signature}
{example}{code:csharp|title=C#}
//--- Get ArrayFormula
string formula = a.ArrayFormula;
//--- Set ArrayFormula
Area a = ws.CreateArea(10,0,10,1);
a.ArrayFormula = "{=TREND(A1:A10,B1:B10)}";
Code Block |
---|
vbnet | vbnet | title | {code}
{code:vbnet|title=vb.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)}"
...