Can we sort by more than one column using shift-click or ctrl-click yet?

Can we sort by more than one column using shift-click or ctrl-click yet?

Posted by: klgrube on 6 January 2018, 12:20 pm EST

• 

  klgrube

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 January 2018, 12:20 pm EST

  I need to be able to sort more than one column at a time just by using the “Allow Sort” check box and then by doing something like holding down the shift key on two columns, double clicking one of them and having them both sorted.

  I should be able to select two columns and sort them both together. I don’t see a way of selecting more than one non-contiguous column and then sorting, though. Maybe I’m missing something.

  Here’s a simple example:

  UNSORTED

  Dept ID Status
  
  82345 Active
  
  23456 Inactive
  
  35873 Active
  
  96372 Inactive

  SORTED BY COLUMN 1 , , ,

  Dept ID Status
  
  23456 Inactive
  
  35873 Active
  
  82345 Active
  
  96372 Inactive

  SORTED BY COLUMN 1 WITHIN COLUMN 2

  Dept ID Status
  
  35873 Active
  
  82345 Active
  
  23456 Inactive
  
  96372 Inactive

  What’s the best way to accomplish this?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 January 2018, 1:45 am EST

  Hello,

  You should be able to achieve this with code using SortRows or SortColumns methods. Please refer to the documentation here:
  
  http://help.grapecity.com/spread/SpreadNet11/ASP2/webframe.html#FarPoint.Web.Spread~FarPoint.Web.Spread.SheetView~SortColumns.html
  
  http://help.grapecity.com/spread/SpreadNet11/ASP2/webframe.html#FarPoint.Web.Spread~FarPoint.Web.Spread.SheetView~SortRows.html

  Thanks,
  
  Deepak Sharma