jQuery UI Widgets Forums Grid Disable Sorting after Cell Edit in Grid

This topic contains 8 replies, has 2 voices, and was last updated by  Dimitar 7 years, 5 months ago.

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
  • Disable Sorting after Cell Edit in Grid #89362

    ioana
    Participant

    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

    Disable Sorting after Cell Edit in Grid #89399

    Dimitar
    Participant

    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/

    Disable Sorting after Cell Edit in Grid #89400

    ioana
    Participant

    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

    Disable Sorting after Cell Edit in Grid #89430

    Dimitar
    Participant

    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/

    Disable Sorting after Cell Edit in Grid #89437

    ioana
    Participant

    Hi Dimitar,

    thank you, I’ll try it.

    Regards,
    Ioana

    Disable Sorting after Cell Edit in Grid #89442

    ioana
    Participant

    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

    Disable Sorting after Cell Edit in Grid #89464

    Dimitar
    Participant

    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/

    Disable Sorting after Cell Edit in Grid #89473

    ioana
    Participant

    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

    Disable Sorting after Cell Edit in Grid #89507

    Dimitar
    Participant

    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/

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.