Flexgrid - Sort once behaviour like in Excel

Flexgrid - Sort once behaviour like in Excel

Posted by: deborah on 3 May 2021, 10:10 pm EST

• 

  deborah

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 May 2021, 10:10 pm EST

  Hello,

  I’m wondering if it’s possible to sort on a column and have it not re-sort after changing a value in said column.

  For example, I have a Name column. I click on the column header and it sorts in ascending order. If I change value ‘Item 1’ to ‘Item a’, it immediately goes to the bottom. I’d like for it to stay in place.

  I’ve tried setting the column ValueFilter’s sortValues property to false and setting the column’s allowSorting property to false but it didn’t have the desired result.

  Thanks you

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 4 May 2021, 9:17 pm EST

  Hi,

  You may set the refreshOnEdit property of grid’s collectionView to achieve the required functionality. You may refer to the following code snippet and the sample demonstrating the same:

  grid.collectionView.refreshOnEdit = false;
  

  https://codesandbox.io/s/wijmo-starter-forked-ekqqq?file=/src/index.js

  API reference:
  
  https://www.grapecity.com/wijmo/api/classes/wijmo.collectionview.html#refreshonedit

  Regards
  
  Sharad

• 

  deborah

  • Post Options:
  • Link
    Copy

  Posted 5 May 2021, 10:13 am EST

  Thank you very much for your help Sharad!