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

operators AND and OR. Standard filters are mostly useful for numbers,

although a few of the conditional operators, such as = and < > can

also be useful for text.

Other conditional operators for standard filters include options to

display the largest or smallest values, or a percentage of them. Useful

in themselves, standard filters take on added value when used to

further refine automatic filters.

Advanced filters are structured similarly to standard filters. The

differences are that advanced filters are not limited to three

conditions, and their criteria are not entered in a dialog. Instead,

advanced filters are entered in a blank area of a sheet, then referenced

by the advanced filter tool to apply them.

Sorting records

Sorting arranges the visible cells on the sheet. In Calc, you can sort by

up to three criteria, with each criterion applied one after the other.

Sorts are handy when you are searching for a particular item, and

become even more powerful after you have filtered data.

In addition, sorting is often useful when you add new information.

When a list is long, it is usually easier to add new information at the

bottom of the sheet, rather than adding rows in the proper places.

After you have added information, you can then sort it to update the

sheet.

You can sort by highlighting the cells to be sorted, then selecting Data

> Sort. The selected cells can be sorted by the order of information in

up to three columns or rows, in either ascending (A-Z, 1-9) or

descending (Z-A, 9-1) order.

On the Options tab of the Sort dialog, you can choose the following

options:

Case sensitive

If two entries are otherwise identical, one with an upper case letter

is placed before one with a lower case letter in the same position.

Range contains column labels

Does not include the column heading in the sort.

Include formats

A cell's formatting is moved with its contents. If formatting is used

to distinguish different types of cells, then use this option.

Chapter 5 Getting Started with Calc 171

Free eBook Edition

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

Sin comentarios

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