If you want to go a little farther and sort by something else, like days of the week in the order they come, not alphabetical order, tune in for the next sorting blog. This window that I've covered in this blog entry is pretty much what you need. Here's a closeup of one section, followed by the complete data. In the Sort Criteria tab, select first State, then City, then Last Name. In the Options tab, be sure to select the Range Contains Column Labels option if you selected headings. Select the data, with or without headings, and choose Data > Sort.

So you'd sort by state (the broadest category), then city, then alphabetically by last name. In this case you might want to just sort by last name, but you could also group by location. But because Base is a powerful and flexible application, you need to be able to make some informed decisions while working with it and this, in turn, requires some preparation. You will find a supplementary wwb pages for most of the videos. The link to YouTube and to further information is marked in blue in the following tables. When downloading from a mirror please check the md5 sum or the sha sum (recommended) and verify the OpenPGP compatible signature from the main Apache site. The following videos are available on YouTube in MP4 format. You have a lot of people from the same state, and several cities per state. offers a very powerful database system with Base. Current Version 4.1.10 (released on May 04, 2021) Note All downloads can be verified using the Apache OpenOffice code signing KEYS. Now, let's look at a different set of data. Here, the amounts under the column for the year 2000 are sorted in ascending order. Select the column to sort by, and Ascending or Descending. If you selected headings you'll see the headings themselves if you didn't then you'll just see Column A, etc. If you've got headings selected, you want the option shown, 'Range Contains Column Labels,' to be selected. You need to tell Calc whether you've got headings selected or not. You're good either way.Ĭlick the Options tab. Select all the data to sort, and either select the headings or not. For that, you need the Sort window under Data > Sort. Maybe you want to sort first by state, then by city, then by last name. Not just sorting by the first column, but by perhaps the third column.

Openoffice draw tutorial youtube