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

Figure 227: Dialog for defining the filter

Note

Even if they are not called a filter, page fields are a practical way to filter

the results. The advantage is that the filtering criteria used are clearly

visible.

Updating (refreshing) changed values

After you have created the DataPilot, changes in the source data do not cause an

automatic update in the resulting table. You have to always update (refresh) the

DataPilot manually after changing any of the underlying data values.

Changes in the source data could appear in two ways:

1) The content of existing data sets has been changed.

For example, you might have changed a sales value afterward. To update the

DataPilot, right-click in the result area and choose Refresh (or choose Data >

DataPilot > Refresh from the menu bar).

2) You have added or deleted data sets in the original list.

In this case the change means that the DataPilot has to use a different area of

the spreadsheet for its analysis. A change of the data reference for an existing

DataPilot is not possible. You must redo the DataPilot from the beginning.

Cell formatting

The cells in the results area of the DataPilot are automatically formatted in a simple

format by Calc. You can change this formatting using all the tools in Calc, but note

that if you make any change in the design of the DataPilot or any updates, the

formatting will return to the format applied automatically by Calc.

For the number format in the data field, Calc uses the number format that is used in

the corresponding cell in the source list. In most cases, this is useful (for example, if

the values are in the currency format, then the corresponding cell in the result area

is also formatted as currency). However, if the result is a fraction or a percentage,

the DataPilot does not recognize that this might be a problem; such results must

either be without a unit or be displayed as a percentage. Although you can correct

the number format manually, the correction stays in effect only until the next update.

Multiple data fields

Until now we have assumed that the layout of the DataPilot contains only one data

field. However, it is possible to have several data fields in the middle of the layout.

This makes summaries and analyses of multiple aspects possible.

232 OpenOffice.org 3.3 Calc Guide

1 2 ... 227 228 229 230 231 232 233 234 235 236 237 ... 433 434

Sin comentarios

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