Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

interface XCellRangeFormula
Description
allows to get and set cell contents (values, text or formulas) for a cell range.

The outer sequence represents the rows and the inner sequence the columns of the array.

Since
OOo 1.1.2

Methods' Summary
getFormulaArray gets an array from the contents of the cell range.  
setFormulaArray fills the cell range with values from an array.  
Methods' Details
getFormulaArray
sequence< sequence< string > >
getFormulaArray();

Description
gets an array from the contents of the cell range.

Each element of the result contains the same string that would be returned by ::com::sun::star::table::XCell::getFormula() for the corresponding cell.

setFormulaArray
void
setFormulaArray( [in] sequence< sequence< string > >  aArray );

Description
fills the cell range with values from an array.

The size of the array must be the same as the size of the cell range. Each element of the array is interpreted the same way as the argument to a ::com::sun::star::table::XCell::setFormula() call for the corresponding cell.

Throws
::com::sun::star::uno::RuntimeException If the size of the array is different from the current size.
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.