DataPilot or Pivot Table
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.
is no PivotChart facility, but a DataPilot
can be used as the data source for a chart.
user interface allows a maximum of 8 fields in the data, row or
column areas. (An alternative interface which allows more is
available from https://homepages.paradise.net.nz/hillview/OOo/
in a document called MyDataPilot.sxc).
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
can not define different formats for different fields.
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).
Application Program Interface specification is incomplete for
writing macros that work with DataPilots—for example; the ability
to control, through another program such as OpenOffice.org’s own
macro language BASIC, whether the tables have grand totals or have
access to DataPilot’s created from