Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.