OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

78. Sort Calc Database Data

77 Import Data into a Calc Database

79 Filter Data That You Want to See

80 Compute Table Totals and Subtotals

One of the reasons some people create a database data range from their spreadsheet data is to sort the data using Calc's database-related sorting tools. Once you set up the database, you can sort on amounts or text

ascending or

descending .

KEY TERMS

Ascending
The sort method where lower values are sorted early in the list and higher values fall at the end of the list, as is the case with an alphabetical list of names.

Descending
The sort method where higher values are sorted early in the list and lower values fall at the end of the list, as would be the case where payroll amounts are sorted from highest to lowest.

By sorting your data, you can often gain insights into it, such as where the top and bottom values lie, without having to resort to extra work to find those values (such as writing

Max() or

Min() functions in cells outside your database's data range). Also, you can print parts of the list in ZIP Code order as you might do when printing a list of names and addresses for a mailing.

NOTE

When you sort a data range, you sort on one or more fields (columns), but all the data in all the rows of the data range sort along with your key sorting fields.