user auto sorting columns

Posted by: zenrhapsody on 8 September 2017, 1:15 pm EST

  • Posted 8 September 2017, 1:15 pm EST

    When a sheet is first displayed, sortable columns display the 'non-sorted' indicator.  When user clicks this indicator, it sorts Ascending.  Next click causes sheet to sort descending.  3rd click goes back to Ascending order sort.

    How can user go back to original non-sorted order?

  • Replied 8 September 2017, 1:15 pm EST

    The UI is designed to toggle between ascending and descending, and there is nothing built-in to let the user reset the sort state.  There is an API you can use to do so in code:


    You could use code in the AutoSortingColumn event to override the default behavior in the case where e.Column = SheetView.ColumnAutoSorted and e.Ascending = True that set e.Cancel = True and calls ResetViewRowIndexes, and the auto sort will toggle between ascending, descending, and unsorted.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels