isArrayFormula Field

Indicates whether the formula in the cell is an array formula.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.FormulaInformation(name);
var value; // Type: boolean
value = instance.isArrayFormula;

var isArrayFormula : boolean;

Example

This example checks for an array formula.

Javascript

activeSheet.setValue(0, 2, 3);
activeSheet.setFormula(1,1,"C1+D1",GcSpread.Sheets.SheetArea.viewport);
var information = activeSheet.getFormulaInfomation(1, 1);
alert(information.isArrayFormula);

Reference

FormulaInformation type

Send comments on this topic.