When inserting data into fixed column, new value is replaced by the original when table is sorted

jonnyd118

When a value is changed within a fixed column the new value isn't kept when the column is sorted. The old value reappears.

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin

nigmastar

I think I'm facing the same issue. This may be connected to re drawing of the table.

1) I have input and select elements in my fixed column on the left.
2) I type something inside the input boxes or select dropdowns
3) I either sort or select the row I changed (the latter both via {select: true} or by manually calling .select() )
4) The values of the input and select elements default to what they were at the time of initialization

You can reproduce it with any of the Examples at https://datatables.net/extensions/fixedcolumns/examples/

For example if you go to https://datatables.net/extensions/fixedcolumns/examples/integration/select.html and change the text inside the first row of the first column (from Airi to TEST) using the Inspector and then you click/select that row.

colin

If you change the data in that way, DataTables won't be aware of it. If you do that, you'll need to call rows().invalidate() to re-read the table. Alternatively, you could use row().data() or cell().data() to update that field.

If that doesn't work, we're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin

nigmastar

Thanks Colin,

Please see example here https://jsfiddle.net/nigmastar/q2j3yhk1/

The above is solely on https://datatables.net/extensions/fixedcolumns/examples/integration/select.html with 2 changes only:

1) Input element in first row first column
2) e.stopPropagation() for the input element.

nigmastar

Thanks again your suggestions, but they didn't work unfortunately. I found this workaround for now

https://jsfiddle.net/nigmastar/q2j3yhk1/15/

It would only need a small change to work with input elements on all rows

nigmastar

This version works with input fields in all rows (on one Left fixed column only)

https://jsfiddle.net/nigmastar/q2j3yhk1/43/