Spread V11: Options in filter dialog are sorted based on capital

Spread V11: Options in filter dialog are sorted based on capital

Posted by: viswanath.malepati on 17 July 2018, 6:35 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 July 2018, 6:35 am EST

  Hi,

  We are applying filters on a column and options in filter dialog are sorted based on capital, which doesn’t happen in Excel. How to stop this?

  please find the attached sample files

  Thanks,
  
  Viswanath

  FilterDialogOrder.zip

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 17 July 2018, 6:36 am EST

  Sorting is based Case sensitivity of letters, which should not happen.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 18 July 2018, 2:22 am EST

  Hello Viswanath,

  For this you need to cancel default sorting by setting SortState enumeration to None as given in link below:-

  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.SortState.html

  And then you can implement your own sorting logic.

  Hope it helps.

  Thanks,
  
  Reeva