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

100

101

Figure 218: Renamed groups and partial results

Figure 219: Reduced to the

new groups

Note

A well-structured database makes manual sorting within the DataPilot

obsolete. In the example shown, you could add another column with the

name Department, that has the correct entry for each person based on

whether the employee’s department belongs to the group Office or

Technical. The mapping for this (1:n relationship) can be done easily with

the VLOOKUP function from Calc.

Sorting the result

The result of any DataPilot is sorted (categories) in columns and rows in an ascending

order. You can change the sorting in three ways:

• Select sort order from drop-down menus on each column heading.

• Sort manually by using drag and drop.

• Sort automatically by choosing the options in the preferences dialog of the row

or column field.

Select sort order from drop-down menus on each column heading

The simplest way to sort entries is to click the arrow on the right side of the heading

and check the box(es) for the desired sort order. The custom sorting dialog is shown

in Figure 220. Additional options exitst to show all, only the current item or to hide

only the current item.

Figure 220: Custom sorting

228 OpenOffice.org 3.3 Calc Guide

1 2 ... 223 224 225 226 227 228 229 230 231 232 233 ... 433 434

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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