Calc Guide

Figure 181: After the start of the DataPilot
Data source
There are usually three possibilities for the DataPilot to have a data
source: a Calc spreadsheet, an external data source that has to be
registered in OpenOffice.org, and access to an OLAP system (not
available at this time).
Calc spreadsheet
The simplest and most often used case is analyzing a list in a Calc
spreadsheet. The list might be updated regularly or the data might be
imported from a different application.
A huge list can, for example, be copied from a different application and
pasted into Calc. The behavior of Calc while inserting the data depends
on the format of the data. If the format is acceptable, the data is copied
directly into Calc. However, if the data is in plain text, a dialog appears
with the text import assistant; see Chapter 1 (Introducing Calc) for
more more information.
Chapter 8 Using the DataPilot 243