Sort order of filter dialog

Posted by: ngocnguyen09910060 on 1 November 2022, 6:55 pm EST

    • Post Options:
    • Link

    Posted 1 November 2022, 6:55 pm EST

    Hi teams,

    My customer is a Japan company. So, i’m using

    "@grapecity/spread-sheets-resources-ja": "^15.2.2"
    to setting Japanese become default language of SpreadJS.

    My customer want to understand about sort order of list filter area on filter dialog. So, please answer me 2 questions:

    1. Is sort order of list filter area on filter dialog same as Excel app ?
    2. Is sort order of list filter area on filter dialog apply this standard ?
  • Posted 3 November 2022, 10:42 am EST


    I believe SpreadJS’ sort order is compatible with Excel. However, I’ve asked the development team if we adhere to the aforementioned standards about both of the aforementioned questions. This has the following internal tracking id: SJS-15394.

    When I have a development update for you, I’ll let you know.



  • Posted 8 November 2022, 3:23 pm EST


    The devs have informed that we try to match the Excel sorting policy, but the issue is that we don’t know internally how that works.

    For the most part, we do match it in most circumstances, but there are some characters where it doesn’t match. Since we don’t know the Excel sorting policy, it is hard to make totally the same as Excel.



  • Posted 9 November 2022, 6:54 pm EST

    Hi ankit.kumar,

    I understood.

    Thank you very much.

Need extra support?

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

Learn More

Forum Channels