Language Asturianu (ast) Català (ca) Čeština (cs) Dansk (da) Deutsch (de) English [US] (en-US) Español (es) Esperanto (eo) Eesti keel (et) Euskara (eu) Français (fr) Gàidhlig (gd) Galego (gl) Italiano (it) Lietuvių (lt) Magyar (hu) Nederlands (nl) Norsk (no) Polski (pl) Português [do Brasil] (pt-BR) Português [Europeu] (pt) Română (ro) Slovenčina (sk) Slovenščina (sl) Suomi (fi) Svenska (sv) Yкраїнська (uk) Tiếng Việt (vi) Türkçe (tr) ኦሮሚኛ (om) Հայերեն (hy) Ελληνικά (el) български език (bg) Русский (ru) Cрпски [ћирилицом] (sr) עברית (he) हिन्दी (hi) ភាសាខ្មែរ (km) தமிழ் (ta) ภาษาไทย (th) 简体中文 (zh-CN) 正體中文 (zh-TW) 日本語 (ja) 한국어 (ko)

The Free and Open Productivity Suite

• Product
• Download
• Support
• Blog
• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

home » api » docs » common » ref » com » sun » star » sheet

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 © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

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.