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 XCellRangesAccess

Description provides access to the cells or to sub-ranges of all sheets. See also Spreadsheets

---

Methods' Summary
getCellByPosition	Returns a single cell within the range.
getCellRangeByPosition	Returns a sub-range of cells within the range.
getCellRangesByName	Returns a sub-range of cells within the range.

Methods' Details

getCellByPosition ::com::sun::star::table::XCell getCellByPosition( [in] long  nColumn, [in] long  nRow, [in] long  nSheet ) raises( ::com::sun::star::lang::IndexOutOfBoundsException ); Description Returns a single cell within the range. Parameter nColumn is the column index of the cell inside the sheet. Parameter nRow is the row index of the cell inside the sheet. Parameter nSheet is the sheet index of the sheet inside the document. Returns the specified cell. Throws ::com::sun::star::lang::IndexOutOfBoundsException if an index is outside the dimensions of this range. See also ::com::sun::star::table::Cell

getCellRangeByPosition ::com::sun::star::table::XCellRange getCellRangeByPosition( [in] long  nLeft, [in] long  nTop, [in] long  nRight, [in] long  nBottom, [in] long  nSheet ) raises( ::com::sun::star::lang::IndexOutOfBoundsException ); Description Returns a sub-range of cells within the range. Parameter nLeft is the column index of the first cell inside the range. Parameter nTop is the row index of the first cell inside the range. Parameter nRight is the column index of the last cell inside the range. Parameter nBottom is the row index of the last cell inside the range. Parameter nSheet is the sheet index of the sheet inside the document. Returns the specified cell range. Throws ::com::sun::star::lang::IndexOutOfBoundsException if an index is outside the dimensions of this range. See also ::com::sun::star::table::CellRange

getCellRangesByName sequence< ::com::sun::star::table::XCellRange > getCellRangesByName( [in] string  aRange ) raises( ::com::sun::star::lang::IllegalArgumentException ); Description Returns a sub-range of cells within the range. The sub-range is specified by its name. The format of the range name is dependent of the context of the table. In spreadsheets valid names may be "Sheet1.A1:C5" or "$Sheet1.$B$2" or even defined names for cell ranges such as "MySpecialCell". Parameter aRange the name of the sub-range. Returns the specified cell ranges. See also ::com::sun::star::table::CellRange

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 ASF logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.