The Free and Open Productivity Suite
Follow us on Twitter: @ApacheOO

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


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

Apache Software Foundation

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice 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.