ExtendedSelect Auto Sort Auto Filter Cancel

Posted by: bob.hager on 10 May 2018, 9:06 am EST

    • Post Options:
    • Link

    Posted 10 May 2018, 9:06 am EST

    How do I cancel or reset the Auto Filter auto sort combined in ExtendedSelect mode on a spread column?

    I’ve tried:

    mycols.ResetSortIndicator()

    mycols.AllowAutoSort = False

    mycols.AllowAutoFilter = False

    They all error:

    Current column(s) belong to a sorted range. Cannot change AllowSort to false

  • Posted 11 May 2018, 12:55 am EST

    Hello,

    There seems to be no direct way to remove sort. You might try saving off the data as it appears before you do the sort and then reload it when you want it.

    Thanks,

    Deepak Sharma

Need extra support?

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

Learn More

Forum Channels