Page History

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

	vb.net
	vb.net

Public Property ArrayFormula() As String

Example

Code Block

	csharp
	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	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)}"

Scrollbar

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key