OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 170)

When you close the dialog, the outline group controls are visible

between either the row or column headers and the edges of the editing

window. The controls resemble the tree-structure of a file-manager in

appearance, and can be hidden by selecting Data > Outline > Hide

Details. They are strictly for on screen use, and do not print.

The basic outline controls have plus or minus signs at the start of the

group to show or hide hidden cells. However, if one or more outline

group is nested in another, the controls have numbered buttons for

hiding different levels of group.

If you no longer need a group, place the mouse cursor in any cell in it

and select Data > Group and Outline > Ungroup. To remove all

groups on a sheet, select Data > Group and Outline > Remove.

Figure 129: Outline group controls

Filtering which cells are visible

A filter is a list of conditions that each entry has to meet in order to be

displayed. You can set three types of filters from the Data > Filter

sub-menu.

Automatic filters add a drop-down list to the top row of a column that

contains commonly used filters. They are quick and convenient, and,

because the condition includes every unique entry in the selected cells,

are almost as useful with text as with numbers.

In addition to each unique entry, automatic filters include the option to

display all entries, the ten highest numerical values, and all cells that

are empty or not-empty, as well as a standard filter. Their drawback is

that they are somewhat limited. In particular, they do not allow regular

expressions, so you cannot display contents that are similar, but not

identical, by using automatic filters.

Standard filters are more complex than automatic filters. You can set

as many as three conditions as a filter, combining them with the

170 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 165 166 167 168 169 170 171 172 173 174 175 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 170