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

Click on the Options tab (see Figure 325) to set the sort options. Check the Range

contains column labels checkbox to prevent column headers from being sorted

with the rest of the data. The Sort by list box in Figure 324 displays the columns

using the column headers if the Range contains column labels checkbox in Figure

325 is checked. If the Range contains column labels checkbox is not checked,

however, then the columns are identified by their column name; Column A, for

example.

Normally, sorting the data causes the existing data to be replaced by the newly sorted

data. The Copy sort results to checkbox, however, causes the selected data to be

left unchanged and a copy of the sorted data is copied to the specified location. You

can either directly enter a target address (Sheet3.A1, for example) or select a

predefined range.

Check the Custom sort order checkbox to sort based on a predefined list of values.

To set your own predefined lists, use Tools > Options > OpenOffice.org Calc >

Sort Lists and then enter your own sort lists. Predefined sort lists are useful for

sorting lists of data that should not be sorted alphabetically or numerically. For

example, sorting days based on their name.

Figure 325. Set sort options.

Caution

When a cell is moved during a sort operation, external references to

that cell are not updated. If a cell that contains a relative reference to

another cell is moved, the reference is relative to the new position

when sorting is finished. Know the behavior of references during

sorting and do not be alarmed; this is almost always what you want—

because the reference is to the right or left in the same row. Also, we

have not found a spreadsheet program that exhibits a different

behavior for references while sorting.

Chapter 13 Calc as a Simple Database 321

1 2 ... 316 317 318 319 320 321 322 323 324 325 326 ... 433 434

Sin comentarios

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