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

Services' Summary

Interfaces' Summary

Properties' Summary

Services' Details

Interfaces' Details

Properties' Details

---

:: com :: sun :: star :: sheet ::

service DataPilotDescriptor

Description represents the description of the layout of a data pilot table. See also DataPilotTable Developers Guide Spreadsheets - Creating a New DataPilot Table

---

Exported Interfaces - Summary
XDataPilotDescriptor	provides access to the layout settings of the data pilot table.
::com::sun::star::beans::XPropertySet	provides access to the layout settings of the data pilot table. (details)
XDataPilotDataLayoutFieldSupplier	Provides access to the DataPilotField used to layout multiple data fields. (details)

Properties' Summary
sequence< ::com::sun::star::beans::PropertyValue > ImportDescriptor	[ OPTIONAL ] specifies parameters to create the data pilot table from a database.
string SourceServiceName	[ OPTIONAL ] specifies the name of a DataPilotSource implementation for the data pilot table.
sequence< ::com::sun::star::beans::PropertyValue > ServiceArguments	[ OPTIONAL ] specifies arguments that are passed to the implementation named by SourceServiceName.
boolean IgnoreEmptyRows	[ OPTIONAL ] specifies if empty rows in the source data are ignored.
boolean RepeatIfEmpty	[ OPTIONAL ] specifies if empty category cells in the source data should be treated as repetition of the content from the previous row.
boolean ColumnGrand	[ OPTIONAL ] specifies if columns for grand total results are created.
boolean RowGrand	[ OPTIONAL ] specifies if rows for grand total results are created.
boolean ShowFilterButton	[ OPTIONAL ] specifies whether the filter button is shown.
boolean DrillDownOnDoubleClick	[ OPTIONAL ] specifies whether to drill down to details or go into edit mode.
string GrandTotalName	[ OPTIONAL ] specifies a label for grand total results.

Exported Interfaces - Details

XDataPilotDescriptor Description provides access to the layout settings of the data pilot table.

::com::sun::star::beans::XPropertySet Usage Restrictions optional Description provides access to the layout settings of the data pilot table.

XDataPilotDataLayoutFieldSupplier Usage Restrictions optional Description Provides access to the DataPilotField used to layout multiple data fields.

Properties' Details

ImportDescriptor sequence< ::com::sun::star::beans::PropertyValue > ImportDescriptor; Usage Restrictions optional Description specifies parameters to create the data pilot table from a database. Since OOo 3.3 See also DatabaseImportDescriptor

SourceServiceName string SourceServiceName; Usage Restrictions optional Description specifies the name of a DataPilotSource implementation for the data pilot table. Since OOo 3.3

ServiceArguments sequence< ::com::sun::star::beans::PropertyValue > ServiceArguments; Usage Restrictions optional Description specifies arguments that are passed to the implementation named by SourceServiceName. Since OOo 3.3

IgnoreEmptyRows boolean IgnoreEmptyRows; Usage Restrictions optional Description specifies if empty rows in the source data are ignored.

RepeatIfEmpty boolean RepeatIfEmpty; Usage Restrictions optional Description specifies if empty category cells in the source data should be treated as repetition of the content from the previous row.

ColumnGrand boolean ColumnGrand; Usage Restrictions optional Description specifies if columns for grand total results are created.

RowGrand boolean RowGrand; Usage Restrictions optional Description specifies if rows for grand total results are created.

ShowFilterButton boolean ShowFilterButton; Usage Restrictions optional Description specifies whether the filter button is shown.

DrillDownOnDoubleClick boolean DrillDownOnDoubleClick; Usage Restrictions optional Description specifies whether to drill down to details or go into edit mode.

GrandTotalName string GrandTotalName; Usage Restrictions optional Description specifies a label for grand total results. Since OOo 3.4

 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.