Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sheet ::
interface XCellRangeFormula
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-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 version OpenOffice.org 1.1.1

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

Copyright © 2003 Sun Microsystems, Inc.