Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Sorting Data

In the simple example shown below, the data consist of the names and countries of a number of mountains together with their height above sea level. KSpread can sort data such as this in different ways.


Screenshot of sorted data

We may want the data sorted so that the names are in alphabetical order. To do this select the area containing the data (A2:C7 in this case) and choose Sort... from the Data menu. This opens the Sorting dialog box.

Sorting is done alphanumerically, and the default is case sensitive, numbers coming before uppercase letters which come before lowercase letters, so that cells containing the entries Cat , bar , 77 and Bat would be sorted into the following order: 77 Bat Cat bar .

Using the Sort Criteria page of this dialog box lets you Sort Rows or Sort Columns . If you check the First row contains headers box data in the first row will not be included in the sort operation. You can choose which column or which row of the data is to be used as a primary sort key and, if you wish, other columns or rows to be used as secondary and tertiary keys. Using the example in the above screenshot, choosing column B as the first key and column C as the second would sort the data by country and, for each country, by height.

The Options page of the dialog allows you to sort using the order of items in a custom list such as January, February... instead of alphanumerically. The cell format is moved with the cell content, if you select Copy cell Formatting (Borders, Colors, Text Style) Uncheck the option Case sensitive sort to get a sort not depending on capitalization.




 
 
  Published under the terms of the GNU General Public License Design by Interspire