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

deprecated interface XConsolidationDescriptor

Usage Restrictions deprecated Description provides access to the settings of a consolidation descriptor. See also ConsolidationDescriptor Developers Guide Spreadsheets - Other Table Operations - Data Consolidation

---

Methods' Summary
getFunction	returns the function by which the ranges are consolidated.
setFunction	sets the function by which the ranges are consolidated.
getSources	returns the cell ranges which are consolidated.
setSources	sets the cell ranges which are consolidated.
getStartOutputPosition	returns the position of the top left cell of the cell range where the consolidated data are copied.
setStartOutputPosition	sets the position of the top left cell of the cell range where the consolidated data are copied.
getUseColumnHeaders	returns, whether column headers from the cell ranges are used to find matching data or not.
setUseColumnHeaders	specifies if column headers from the cell ranges are used to find matching data.
getUseRowHeaders	returns, whether row headers from the cell ranges are used to find matching data or not.
setUseRowHeaders	specifies if row headers from the cell ranges are used to find matching data.
getInsertLinks	returns, whether links to the original data are inserted in the output area or not.
setInsertLinks	specifies if links to the original data are inserted in the output area.

Methods' Details

getFunction GeneralFunction getFunction(); Description returns the function by which the ranges are consolidated.

setFunction void setFunction( [in] GeneralFunction  nFunction ); Description sets the function by which the ranges are consolidated.

getSources sequence< ::com::sun::star::table::CellRangeAddress > getSources(); Description returns the cell ranges which are consolidated.

setSources void setSources( [in] sequence< ::com::sun::star::table::CellRangeAddress >  aSources ); Description sets the cell ranges which are consolidated.

getStartOutputPosition ::com::sun::star::table::CellAddress getStartOutputPosition(); Description returns the position of the top left cell of the cell range where the consolidated data are copied.

setStartOutputPosition void setStartOutputPosition( [in] ::com::sun::star::table::CellAddress  aStartOutputPosition ); Description sets the position of the top left cell of the cell range where the consolidated data are copied.

getUseColumnHeaders boolean getUseColumnHeaders(); Description returns, whether column headers from the cell ranges are used to find matching data or not.

setUseColumnHeaders void setUseColumnHeaders( [in] boolean  bUseColumnHeaders ); Description specifies if column headers from the cell ranges are used to find matching data.

getUseRowHeaders boolean getUseRowHeaders(); Description returns, whether row headers from the cell ranges are used to find matching data or not.

setUseRowHeaders void setUseRowHeaders( [in] boolean  bUseRowHeaders ); Description specifies if row headers from the cell ranges are used to find matching data.

getInsertLinks boolean getInsertLinks(); Description returns, whether links to the original data are inserted in the output area or not.

setInsertLinks void setInsertLinks( [in] boolean  bInsertLinks ); Description specifies if links to the original data are inserted in the output area.

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.