OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 277)

100

101

Chapter 4: Spreadsheets in Calc

Set the cursor in the database range and choose Data > Sort. In the dialogue that appears,

select the column to be sorted, fro example, Amount, as the sort criterion and click OK.

Up to two additional criteria can be specified, one to follow the other, for the sort function.

For instance, sort the expenditures first by date, then by item if they have the same date, and

then by amount if they have the same date and item.

Filtering Database Ranges

To filter out only certain records so that they can be modified, use the spreadsheet filtering

function. Choose between using a dialogue to specify the criteria exactly (in that case range

definitions are also possible), or creating an AutoFilter that will help filter according to

specific values or text.

Imagine that the output list is already 8000 records long. With this number of records it is no

longer possible to get an overview. Now, only those records that occurred after 1/2/2000 and

which apart from this involve an amount in excess of 100 currency units must be shown.

Here is one way:

1. Set the cursor in the database range

2. Choose Data > Filter > Standard Filter to open the dialogue.

3. Enter the following:

OpenOffice.org User Guide for 2.x 243

1 2 ... 272 273 274 275 276 277 278 279 280 281 282 ... 507 508

Comentarios a estos manuales

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 277

Comentarios a estos manuales

Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x