Sorting list based on integers in any column



Here is an extremely simple implementation for sorting, which is probably
sufficient for most needs.  The code determines which column in the
report was clicked, converts the text data for that column into item
data, then lets the list control perform its standard sorting.  The code
below sorts columns of integers; sorting text is even simpler.

1) Use Class Wizard to map the message LVN_COLUMNCLICK to the
ListView handler function OnColumnclick.  This will insert the line
ON_NOTIFY_REFLECT(LVN_COLUMNCLICK, OnColumnclick) into your derived
ListView message map.  Fill in the OnColumnclick function with the code
below. 

2) Add a comparison function to your derived ListView class.  The
function prototype should read: static int CALLBACK CompareFunc(LPARAM,
LPARAM, LPARAM).  The ListView framework calls this function to compare
ListView items (the first two function parameters).  Fill in the
function with the code below.  

void CMyListView::OnColumnclick(NMHDR* pNMHDR, LRESULT* pResult) 
{
    // Keep track of sort order and column used for sorting.

    static int nSortColumn = -1;
    static BOOL bSortAscending = TRUE;

    // Get the index of the column header that was clicked.

    NM_LISTVIEW* pNMListView = (NM_LISTVIEW*) pNMHDR;
    int iColumn = pNMListView -> iSubItem;

    // Reverse sort order if column was just previously clicked.

    if (iColumn == nSortColumn) { bSortAscending = !bSortAscending; }
    else                                    { bSortAscending = TRUE; }
    nSortColumn = iColumn;

    // Set item data for each row to column value,
    // since sort routine gets passed item data only.

    CListCtrl& ListCtrl = GetListCtrl();
    int nItems = ListCtrl.GetItemCount();

    for (int item=0; item<nItems item++)
    {
        CString text = ListCtrl.GetItemText(item, iColumn);

        int value = atoi(text);  // numeric sort
        if (!bSortAscending) { value = -value; }

        ListCtrl.SetItemData(item, value);
    }

    LPARAM lParamSort = 0;
    ListCtrl.SortItems(CompareFunc, lParamSort);
}

int CALLBACK CMyListView::CompareFunc(LPARAM lParam1, LPARAM lParam2,
LPARAM lParamSort)
{
    // First two parameters are item data to be compared.
    // Third parameter is passed from SortItems, not used here.

    if (lParam1 < lParam2) { return -1; }
    if (lParam1 > lParam2) { return  1; }
    return  0;
}



Comments

  • A problem...if the "itemdata" is already utilized to save some other information then...??

    Posted by aniketd on 04/26/2005 01:25am

    Yes, this is an helpful example but what if the listview control's "itemdata" needs to store some other information (e.g. Item Text Formatting information) in that case we cannot use the for loop to set the itemdata to item number... 
    
    for (int item=0; item

    Reply
  • How to sort text columns?

    Posted by Legacy on 02/22/1999 12:00am

    Originally posted by: varsh

    Sorting of integer columns works fine.I want to sort text columns when clicked on the column header using the
    SetItemData() and SortItems() method. How can i do?
    

    Reply
  • You must have javascript enabled in order to post comments.

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Microsoft® Office 365 is a top choice for enterprises that want a cloud-based suite of productivity/ collaboration applications. With Office 365, you get access to Microsoft™ Office solutions practically anytime, anywhere, on virtually any device. It's a great option for current Microsoft users who can now build on their experience with Microsoft™ solutions while enjoying the flexibility of a cloud-based delivery. But even organizations with no previous investment in Microsoft will find that …

  • On-demand Event Event Date: July 28, 2016 Jepsen tests are third-party tests for distributed databases that validate vendors' guarantees about how they perform under various failure scenarios, especially network partitions. These have proven their value as tools in any distributed system tester's arsenal. When the creator of Jepsen, Kyle Kingsbury, started his Jepsen-for-Hire business last fall, VoltDB immediately got in line, and over the past two months, our solution was given the most stringent Jepsen …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date