OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 218)

100

101

Selection from

Shows the range of cells used in 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.

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 200), the DataPilot adds it to the listed

category above it. If this option is not chosen, then the DataPilot inserts (empty)

(see Figure 202).

Figure 200: 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 201).

Figure 201: DataPilot result with Identify categories selected

Without category recognition, the DataPilot shows an (empty) category (Figure

202).

1 In this case the word - undefined – is misleading because the output position is in fact

defined.

218 OpenOffice.org 3.3 Calc Guide

1 2 ... 213 214 215 216 217 218 219 220 221 222 223 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 218

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3