Saturday, October 11, 2008  



 FarPoint Technologies
 (800) 645-5913

 fpsales@fpoint.com



     
 »Spread for Windows Forms » Product Tour » Sorting

Previous Sorting Next

You can sort the data displayed in the sheet either by column or by row. Typically, all the rows of a sheet are sorted by the values in a particular column. But FarPoint Spread allows various ways of performing a sort with various properties and methods for each type of sorting.

There are various properties of sorting. The order of the sort can be in ascending order (A to Z, zero to 9) or descending order (Z to A, 9 to zero). The method of comparison can be customized. You can select which values to use as a key when comparing in order to sort the values. The sort indicator, an arrow typically, can be displayed in the header for the column being used as a sort key.

The sorting is done depending on the data type of the values in the cells. If you sort cells with data of the DateTime type, then it sorts those cells by date, and if you sort cells with data of the string type, it sorts those cells alphabetically.



    
 Have a question?
Have a Question? Ask Us!
Subscribe to the RSS feed!RSS Subscribe
 

 
Learn about the new Roadshow now!

Tour Home
Annotation Mode
Auto Complete
Borders
Cell Notes
Cell Types
Conditional Formatting
Control Layer
DataBinding
Drag Drop
DragFill
Excel Compatibility
Filtering
Fonts/Colors
Formulas
Formula Textbox
Freezing Rows/Columns
Grouping
Grouping Excel-like
Hierarchy
Import Export
Merging
Move Rows/Columns
MultipleHeaders
OperationModes
Printing
Printing to PDF
Reporting
Search
Shapes
Sheets
Sorting
Spans
Spread Designer
SubEditors
Unbound
Undo/Redo
Viewports
Zoom
Rate this tour



Copyright © 1991-2007 FarPoint Technologies, Inc. All rights reserved. All names are property of their respective owners.