Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Microsoft Office to OpenOffice Migration Guide
Previous Page Home Next Page

DataPilot or Pivot Table

DataPilots are Calc’s equivalent to Excel’s Pivot Tables. However there are a number of limitations. Pivot tables import from Excel into Calc (although the cells do not have the PivotTable shading), but as soon as they are worked on these limitations become apparent.

The limitations are:

  • There is no PivotChart facility, but a DataPilot can be used as the data source for a chart.

  • The user interface allows a maximum of 8 fields in the data, row or column areas. (An alternative interface which allows more is available from in a document called MyDataPilot.sxc).

  • There is some ability to group data (for example, a date field grouping by week or quarter but not by month). The work-around is to create a new column with a formula for calculating the grouping, for example =Month().

  • You can not define different formats for different fields.

  • Calc can have formulas based on things like “Difference From” or “% of”, but can not have its own custom fields (work-around, create new columns to calculate the desired values).

  • The Application Program Interface specification is incomplete for writing macros that work with DataPilots—for example; the ability to control, through another program such as’s own macro language BASIC, whether the tables have grand totals or have access to DataPilot’s created from external data.

Microsoft Office to OpenOffice Migration Guide
Previous Page Home Next Page

  Published under the terms of the GNU General Public License Design by Interspire