thank you @Pranay Kumar 

i successfully clear sort setting by using the api you suggested 

But unfortunately the sorted data is also rolled back.

I don’t want to roll back the data.

Only the sort setting is the thing I want to clear

Hi @Jiro Yamada,

Can you explain a bit more what you mean by "roll back the data"?

Also if you record a small gif/video of what is happening, would be extremely useful.

Thank you!
RG

hi @Ruben Goncalves 

i am sorry, i can not make a gif/video.

the thing i want to do is the following:

 (1) sort the data by clicking column

 (2) make the sort function disable

 (3) edit the data on cells which were sorted in (1)

i tried to use the api you suggested but the data sorted in (1) become unsorted back.

Hello @Jiro Yamada ,

We are trying to understand your use case, but we are not getting it.

If the column is sorted, in the grid, when you change a value, that value will be sorted because the column is sorted.

What do you want to achieve with " make the sort function disable ".

Can you please give some more details, please?

Thanks.

Bruno Martinho

hi

i made an image file to explain

could you refer to the attached file?

Hello Jiro,

I'm not sure I understood your case correctly. Please correct me if I'm wrong, but you want a cell to stay where it is after sorting a column?

If this is correct, I've made a sample for you.

On Grid Initialize, I call our API to disable refresh on edits with this code.

GridAPI.GridManager.GetActiveGrid().provider.collectionView.refreshOnEdit = false;

Let me know if this works for you,

Gabriel Lundgren

very good

you are my hero