
left unchanged and remains open. If you want to ‘Cherry Pick’ records, consider using the Trip Planner. That function
allows you to pick random records and save them as a file.
1.12 Sort File
While you can sort a file by simply double clicking on the column header, there are cases where you want more control
on how the sort is performed. The file can be sorted by any column of the spreadsheet as shown below.
You have the choice of either using this window or just double clicking on the column header to sort the file. This
dialog is more complete, however. Ascending sorts put the smallest number at the top of the list. When sorting by
double clicking on the header, the second time reverses the sort. Unlike some data base programs, these sorts are
permanent; that is, there is no undo other than to sort again the original way.
Sorting on text fields is done alphabetically based on the following precedence of characters:
!"#$%&'()*+,-./0123456789:;<=>?@abcdefghijklmnopqrstuvwxyz[\]^_`
ABCDEFGHIJKLMOPQRSTUVWXYZ{|~
Note that the first character of the above list is a space. To insure that your sorts perform as expected on a column like
the Rating column, you should insure that all numbers are right justified. Ignoring punctuation marks, spaces have the
lowest value followed by the numbers, lower case letters and then upper case letters. Thus, if I may use periods to
represent spaces, the following are true for text sorting:
.999 is less than 1...
...2 is less than 0001
zulu is less than Able
If two waypoints are alike or equal on the first sort key, the second key is used to break the tie. On numeric fields such
as range and bearing, the sort may be done on the full number (that has decimal places that are not displayed). Thus,
they might look identical, when they are not.
The TAG is the last 2 to 4 (user selectable) characters in the description. To return a file to its original order, you might
try sorting by Date Code. You can sort a file many ways, but the copy on the disk is unchanged until you save the file.
So, to abandon a sorted file you have not saved, just re-open the file on the disk.
The Name column will sort by the above rules, so 10 will preceede 2 as it begins with a lower number. To avoid this,
use leading zeros. That is, 002 is definately less than 010.
Komentáře k této Příručce