Disable Sorting after Cell Edit in Grid

[ioanaParticipant]

Hi jqWidgets Team,

Is it possible to disable the automatically sorting after edit on a cell (in Grid)?
Is:
When the user changes a cell value, sort on the column is triggered.
Need:
User changes the value, no sort is triggered. If the user manuually triggers the sort, then values should be sorted.

Regards,
Ioana

[DimitarParticipant]

Hi Ioana,

If a column is sorted and a cell from this column is edited, the grid sorts the column again to account for the new value. This is the default behaviour and it cannot be altered, unfortunately.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[ioanaParticipant]

Hi Dimitar,

thank you for answering. Unfortunately in a scenario where a user is editing such a cell, then using the keyboard (tab key for example) navigates to the next cell with the intention to edit it – it can no longer see the cell to edit (if for example the Grid has a scrollbar).

Still hoping that there is a way to “trick” this…

Regards,
Ioana

[DimitarParticipant]

Hi Ioana,

In this case, you can try using editmode: 'selectedrow' (demo) and you will be able to edit the whole row before the grid is re-sorted.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[ioanaParticipant]

Hi Dimitar,

thank you, I’ll try it.

Regards,
Ioana

[ioanaParticipant]

Hi Dimitar,

the proposed solution does not seem to work.
I have changed one of your fiddle, see http://jsfiddle.net/ioana_v/qvm07q3u/1/ and used editmode: ‘selectedrow’.
Am I doing something wrong? Or this will not work together with selectionmode: ‘singlecell’?
In my case the selectionmode must be ‘singlecell’. Any other ideas?

Regards,
Ioana

[DimitarParticipant]

Hi Ioana,

In your example:

1. Sort the “First Name” column.
2. Double-click a cell from “First Name” column to start editing of the cell’s row.
3. You can now safely edit the row’s cells and tab through them. Only after exiting edit mode will the grid be re-sorted.

Is this not what you require? This was my understanding from your statement “Unfortunately in a scenario where a user is editing such a cell, then using the keyboard (tab key for example) navigates to the next cell with the intention to edit it – it can no longer see the cell to edit (if for example the Grid has a scrollbar)”.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[ioanaParticipant]

Hi Dimitar,

correct, but when the user exits from the edit mode the jump due to the sorting is still happening, not allowing to see the edited row.
I was looking for a way to completely remove the automatically sorting after edit. I need sorting to happen when the user needs it (clicking on sort icons in column header), so the user is in control of what happens.
Same as it is possible to hide/show the sorting menu: it is configurable as not always needed/wanted.

Also, the editmode must be ‘click’ in my case.

Regards,
Ioana

[DimitarParticipant]

Hi Ioana,

Unfortunately, jqxGrid does not have a built-in functionality that can offer a solution on the matter.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts