Sorting an opened Excel File that has headers in Row1 and Excel Filtering is on

Posted by: john.brazill on 31 May 2022, 8:26 am EST

  • Posted 31 May 2022, 8:26 am EST

    Hi All,
    I am opening an excel file which has the headings in Row 1 and excel filtering is turned on. Everything looks normal once opened in spread. I can sort and filter any column.
    But how can I do that programmatically? None of the typical spread sorting examples work.
  • Replied 31 May 2022, 4:09 pm EST

    Hi John,

    It seems you have Range AutoFilter in your sheet. You can manage range sorting programmatically as shown in the documentation at https://www.grapecity.com/spreadnet/docs/versions/v14/online-win/spwin-sort-range.html.
    If you face any issues let us know with a sample replicating the issue.

    Regards
    Avnish
Need extra support?

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

Learn More

Forum Channels