Calc Guide

Figure 183: Expanded dialog of the DataPilot
Results to
Results to defines where your result will be shown. If you do not
enter anything, the DataPilot will put your result below the list that
contains your data. This could result in overwriting any data that is
already in that location. To avoid overwriting data, you can leave
Results to as – undefined – and enter a cell reference to tell the
DataPilot where to show the results.
1
However, a generally better
approach is to use - new sheet – to add a new sheet to the
spreadsheet file and place the results there.
Ignore empty rows
If the source data is not in the recommended form, this option tells
the DataPilot to ignore empty rows.
Identify categories
If the source data has missing entries in a list and does not meet the
recommended data structure (see Figure 184), the DataPilot adds it
to the listed category above it. If this option is not chosen, then the
DataPilot inserts (empty).
Figure 184: Example of data with missing
entries in Column A
The option Identify categories ensures that in this case rows 3 and 4
are added to the product Apples and row 6 is added to Pears (see
Figure 185).
1 In this case the word - undefined – is misleading because the output position is in fact
defined.
246 OpenOffice.org 3.x Calc Guide