Flexgrid Filter Sorting

Flexgrid Filter Sorting

Posted by: brandon.grime on 31 July 2019, 8:44 am EST

• 

  brandon.grime

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 July 2019, 8:44 am EST

  Hey,

  I had a column that was decimal formatted string values (‘10.01’, etc), and it was unable to correctly sort by ascending and descending values. I found out that I could use sortMemberPath to reference another column and the sorting was corrected. The issue being in the columns filter menu, the values that you can select and deselect to appear visible are still incorrectly sorted. Is there a way the fix this?

  Pretty confusing to put into words, but hopefully you can understand.

  Thanks

  Brandon

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 1 August 2019, 2:29 am EST

  Hi Brandon,

  Using sortMemberPath, you can change the implementation of sorting only for FlexSheet and not for filter menu.
  
  In order to sort the values of the specified column in FlexSheet as well as Filter values, you will need to convert the string values to number. Please refer to the sample below that demonstrates how you can convert the string values to number:

  https://stackblitz.com/edit/react-wvggp7

  Regards,
  
  Ashwin