Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

service DataPilotSource
Description
represents a data pilot source.

A component that implements this service can be used as data source for a data pilot table in a spreadsheet document.

Developers Guide
Spreadsheets - Source Object

Exported Interfaces - Summary
XDimensionsSupplier

provides access to the collection of the dimensions of the data pilot source.

XDataPilotResults

gives access to the results of the data pilot table.

::com::sun::star::util::XRefreshable

provides methods to refresh the data pilot table, that means to read the data again from the data pilot source.

::com::sun::star::beans::XPropertySet

provides access to the properties.

Properties' Summary
boolean
ColumnGrand
specifies if grand totals for the columns are inserted.  
boolean
RowGrand
specifies if grand totals for the rows are inserted.  
[ readonly ] long
RowFieldCount
[ OPTIONAL ]
specifies the number of row fields.  
[ readonly ] long
ColumnFieldCount
[ OPTIONAL ]
specifies the number of column fields.  
[ readonly ] long
DataFieldCount
[ OPTIONAL ]
specifies the number of data fields.  
Exported Interfaces - Details
XDimensionsSupplier
Description
provides access to the collection of the dimensions of the data pilot source.
XDataPilotResults
Description
gives access to the results of the data pilot table.
::com::sun::star::util::XRefreshable
Description
provides methods to refresh the data pilot table, that means to read the data again from the data pilot source.
::com::sun::star::beans::XPropertySet
Description
provides access to the properties.
Properties' Details
ColumnGrand
boolean ColumnGrand;
Description
specifies if grand totals for the columns are inserted.
RowGrand
boolean RowGrand;
Description
specifies if grand totals for the rows are inserted.
RowFieldCount
[ readonly ] long RowFieldCount;
Usage Restrictions
optional
Description
specifies the number of row fields.
Since
OOo 3.0
ColumnFieldCount
[ readonly ] long ColumnFieldCount;
Usage Restrictions
optional
Description
specifies the number of column fields.
Since
OOo 3.0
DataFieldCount
[ readonly ] long DataFieldCount;
Usage Restrictions
optional
Description
specifies the number of data fields.
Since
OOo 3.0

 
Top of Page

Apache Software Foundation

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.