(incubating) | The Free and Open Productivity Suite

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.
Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

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

Copyright © 1995, 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.