Difference between revisions of "Documentation/DevGuide/Spreadsheets/DataPilot Tables"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (1 revision(s))
 
(3 intermediate revisions by one other user not shown)
Line 6: Line 6:
 
|NextPage=Documentation/DevGuide/Spreadsheets/Creating a New DataPilot Table
 
|NextPage=Documentation/DevGuide/Spreadsheets/Creating a New DataPilot Table
 
}}
 
}}
{{DISPLAYTITLE:DataPilot Tables}}
+
{{Documentation/DevGuideLanguages|Documentation/DevGuide/Spreadsheets/{{SUBPAGENAME}}}}
 +
{{DISPLAYTITLE:DataPilot Tables}}
 
<!--<idltopic>com.sun.star.sheet.DataPilotTables</idltopic>-->
 
<!--<idltopic>com.sun.star.sheet.DataPilotTables</idltopic>-->
 
The <idl>com.sun.star.sheet.DataPilotTables</idl> and related services create and modify <code>DataPilot</code> tables in a spreadsheet.
 
The <idl>com.sun.star.sheet.DataPilotTables</idl> and related services create and modify <code>DataPilot</code> tables in a spreadsheet.
Line 16: Line 17:
 
The <idl>com.sun.star.sheet.DataPilotTables</idl> service is accessed by getting the <idl>com.sun.star.sheet.XDataPilotTablesSupplier</idl> interface from a spreadsheet object and calling the <code>getDataPilotTables()</code> method.
 
The <idl>com.sun.star.sheet.DataPilotTables</idl> service is accessed by getting the <idl>com.sun.star.sheet.XDataPilotTablesSupplier</idl> interface from a spreadsheet object and calling the <code>getDataPilotTables()</code> method.
  
{{Documentation/Note|Only <tt>DataPilot</tt> tables that are based on cell data are supported by these services. <tt>DataPilot</tt> tables created directly from external data sources or using the <idl>com.sun.star.sheet.DataPilotSource</idl> service cannot be created or modified this way.}}
+
{{Note|Only <tt>DataPilot</tt> tables that are based on cell data are supported by these services. <tt>DataPilot</tt> tables created directly from external data sources or using the <idl>com.sun.star.sheet.DataPilotSource</idl> service cannot be created or modified this way.}}
  
 
{{PDL1}}
 
{{PDL1}}
[[Category: Spreadsheet Documents]]
+
 
 +
[[Category:Documentation/Developer's Guide/Spreadsheet Documents]]

Latest revision as of 20:54, 3 July 2018



The com.sun.star.sheet.DataPilotTables and related services create and modify DataPilot tables in a spreadsheet.

The method getDataPilotTables() of the interface com.sun.star.sheet.XDataPilotTablesSupplier returns the interface com.sun.star.sheet.XDataPilotTables of the collection of all data pilot tables contained in the spreadsheet.

DataPilotTables

The com.sun.star.sheet.DataPilotTables service is accessed by getting the com.sun.star.sheet.XDataPilotTablesSupplier interface from a spreadsheet object and calling the getDataPilotTables() method.

Documentation note.png Only DataPilot tables that are based on cell data are supported by these services. DataPilot tables created directly from external data sources or using the com.sun.star.sheet.DataPilotSource service cannot be created or modified this way.
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages