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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (FINAL VERSION FOR L10N)
 
Line 17: 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:Documentation/Developer's Guide/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