:: com :: sun :: star :: sheet ::

interface XArrayFormulaRange
Description
provides handling of array formulas in a cell range.
Developers Guide
Spreadsheets - Handling Array Formulas

Methods' Summary
getArrayFormula returns the array formula of the range or an empty string, if the range does not contain an array formula.  
setArrayFormula applies the array formula to the entire cell range.  
Methods' Details
getArrayFormula
string
getArrayFormula();

Description
returns the array formula of the range or an empty string, if the range does not contain an array formula.
setArrayFormula
void
setArrayFormula( [in] string  aFormula );

Description
applies the array formula to the entire cell range.
Parameter aFormula
the formula that will be applied as array formula. Passing an empty string erases an existing array formula.
Top of Page