
		Forums Knowledge Base OfficeWriter Online


	This documentation is for OfficeWriter v3.0.4 .NET Platform View Docs for Another Version or Platform

Programmer's Reference > ExcelApplication API > Area > ArrayFormula

ArrayFormula Property

C# Signature:

VB.NET Signature:

Description:

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

ArrayFormula is a read / write property.

Examples:

[csharp]

// Get ArrayFormula
string formula = a.ArrayFormula;

// Set ArrayFormula
Area a = ws.CreateArea(10,0,10,1);
a.ArrayFormula = "{=TREND(A1:A10,B1:B10)}";

[vbnet]

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

Getter

Signature:

public            String
     ArrayFormula

Returns:

String The array entered formula.

Setter

Signature:

public void ArrayFormula                      String
     arrayFormula

Type:

String