OpenOffice.org 2.x Betriebsanweisung PDF herunterladen (Seite 286)

Chapter 4: Spreadsheets in Calc

Selecting DataPilot Output Ranges

Click the button More in the DataPilot dialogue. The dialogue will be extended. Select a

named area from the list box Results to into which to create the DataPilot table. If the

required output area does not have a name, enter the coordinates of the upper left cell of the

area into the field to the right of the list box Results to. Clicking on the appropriate cell with

the mouse also enters the coordinates.

By activating the check box Ignore empty rows, these will, then, not be taken into account

when the DataPilot table is created.

If the check box Identify categories is activated, the categories will be recognized by means

of their headings and assigned accordingly when the DataPilot table is created.

Editing DataPilot Tables

Click one of the buttons in the table that the DataPilot has created and hold the mouse button

down. A special symbol appears next to the mouse pointer.

Dragging the button to a different position in the row alters the order of the columns. If a

button from the row to the left edge of the table is dragged into the line headings area, a

column can be changed into a row. The mouse pointer alters its appearance from the icon for

a column heading to that of a line heading.

To remove a button from the table, just drag it out of the table. Release the mouse button

when the mouse pointer becomes a not allowed icon. The button is, thus, deleted.

Note: Double-clicking on the name of a table element hides or shows the merged elements below it.

Filtering DataPilot Tables

Although the DataPilot tables are usually created according to user requirements, there may

be occasions when not all of the data provided by the tables is of interest. If this should be the

case, filters should be used that apply conditions to the data such that if the conditions are not

met the excess data is removed from the tables.

Click the Filter button in the sheet to call up the entry mask for the filter conditions. The

Filter dialogue will appear. This dialogue provides different criteria which can be used for

selecting data.

Updating DataPilot Tables

If the data of the base table has changed, Calc recalculates the tables to bring the analysis up-

to-date. Here are the steps to accomplish to recalculate the tables:

1. Click with the right mouse button on one of the button fields

2. Choose the Refresh entry or choose Data > DataPilot > Refresh.

Deleting DataPilot Tables

To delete a DataPilot table, select any cell in the analysis table, then choose Data >

DataPilot > Delete.

OpenOffice.org User Guide for 2.x 252

1 2 ... 281 282 283 284 285 286 287 288 289 290 291 ... 507 508

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 286