Sort order of filter dialog

Sort order of filter dialog

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

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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 ?

  • The Unicode Standard CJK: https://www.asahi-net.or.jp/~ax2s-kmtn/ref/unicode/cjku_klist.html
  • The Unicode Standard Hiragana: https://www.asahi-net.or.jp/~ax2s-KMTN/ref/unicode/u3040.html
  • The Unicode Standard Katakana: https://www.asahi-net.or.jp/~ax2s-kmtn/ref/unicode/u30a0.html
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 3 November 2022, 10:42 am EST

  Hi,

  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.

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 8 November 2022, 3:23 pm EST

  Hi,

  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.

  Regards,

  Ankit

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy

  Posted 9 November 2022, 6:54 pm EST

  Hi ankit.kumar,

  I understood.

  Thank you very much.