Handsontable: Sorting doesn't work when filtering is applied

[budnix]

Description

Sorting doesn't work when filtering is applied (in specific situations)

Steps to reproduce

1. Go to http://jsfiddle.net/zgrry4ap/.
2. Filter "Currency" column using the filter "Begins with" condition with "a" value.
3. Try to sort any column. In the result, nothing happens.

Demo

http://jsfiddle.net/zgrry4ap/.

Your environment

• Handsontable version: 0.31.2
• Browser Name and version: Chrome
• Operating System: macOS

[AMBudnik]

Related situation.

When we filter any column first and then try to sort it multiple times some of the rows are immune to sorting and stay at the same position.

[budnix]

Thanks, @AMBudnik! I believe that your scenario can be caused by the same bug.

[AMBudnik]

(note to myself, Groove #5706, Forum)

[GanjuV]

Issue exist when sorting and persistentState is true and we are calling untrimAll() and trimRows() simultaneously.
PFB the link for details for your reference.
https://jsfiddle.net/Vaibhav34/b2buhp6u/2/

4312

[sergionegri]

Any news on this? Given the estimation of "a day or more" I was hoping in a quick resolution ;)

[AMBudnik]

We have been little busy building a new website and a licence-key system but we'll be fixing all 'high' priority bugs in the Q4 this year.

[travisraghib]

Q4 is about to be over. Any updates on this?

[AMBudnik]

I hope that within next 2 weeks we'll have a new Roadmap - for 2018. Currently, there is a very long list of ideas/changes/bugs without any date on our private Trello board.

[krzysztofspilka]

Fix sorting when used with filtering

[AMBudnik]

Still replicable in version 0.35.1

[briancaldass]

some solution to this issue ?, the same thing happens to me

[AMBudnik]

Sorry @briancaldass we did not find any fix/workaround yet

[briancaldass]

@AMBudnik
So what can I do for the moment? to sort with filter

[AMBudnik]

I really would like to give you some other options. However, the only thing I can do (as we do not have a workaround for this issue) is to find a way to review this issue soon and try to fix it.
I can understand why this is confusing - the filtering and sorting are main functionalities of a spreadsheet. This should work without flaws.

[AMBudnik]

Replicable in version 1.18.1

[wszymanski]

It's probably related to sorting the last element when trimRows, maxRows and columnSorting plugins are turned on. The minimum demo showing the problem: http://jsfiddle.net/6aoyx6aL.

[krzysztofspilka]

@wszymanski looks good to me

[AMBudnik]

Hi @briancaldass @travisraghib @sergionegri @GanjuV

the issue has been solved in v 2.0.0. (CE and PRO).

Feel free to comment if it doesn't work for you or you have any concerns and we'll reopen the ticket.

[rayokao]

Seems like there's an issue if you're using minSpareRows, uncheck the blank cells from the filter and then sort:

http://jsfiddle.net/rayokao/r0ujLb4h/

[AMBudnik]

Thank you for sharing the issue. I have replicated it with 7.1.1.

It looks like the issue is still replicable in the latest build of 8.0.0. http://jsfiddle.net/handsoncode/h2gfmc97/

Can you check it out @aninde ? Not sure if I have the latest changes (those are from 26/09)

[AMBudnik]

Hey @rayokao

It looks like the exact issue has been already tested with the newest build here https://github.com/handsontable/handsontable/issues/5983 so please track changes to https://github.com/handsontable/handsontable/issues/5983 for more updates.

[aninde]

@AMBudnik, https://github.com/handsontable/handsontable/issues/4170#issuecomment-537004622 you tested it on the latest build. You're right, this bug is duplicate of https://github.com/handsontable/handsontable/issues/5983.

[dkwebtec]

after 3 years still not fixed in 8.0

https://forum.handsontable.com/t/sorting-after-filtering-with-minsparerows-set/1411

[AMBudnik]

@dkwebtec forum ticket related to use of the minSpareRows and this topic does not code a case with minSpareRows. In the end, the spare row issue was moved to https://github.com/handsontable/handsontable/issues/5983 and true, it is still replicable in v 8.0.0.