FilteredRows and TrimRows is empty

Getting help Questions
,
1

We upgraded from version 7 to version 14 and all seems to be working, except the readouts of the hidden / invisible columns after applying a filter.

afterFilter: function afterFilter() {
var t = hot.getPlugin(‘hiddenRows’);
t.updatePlugin(); // does not help
var x = hot.getPlugin(‘trimRows’);
x.updatePlugin(); // does not help either
console.log(t.getHiddenRows(), x.getTrimmedRows()); // --> Both an empty array. [] , []
}

The plugins are enabled (when i log T and X i see them as enabled = true). I must be missing something obvious, but can’t figure out what. I read all the upgrade docs for every version and saw nothing i can imagine would cause this. Any Clue what could cause this?

2

Hi @nathan.scherff

It is hard to specify what went wrong. When I use this code in a 14.3.0 version it works well

Setup

trimRows: [0, 2],
  hiddenRows: {
    rows: [1, 5],
    indicators: true,
  },
  afterFilter: function () {
    const hiddenRows = hot.getPlugin('hiddenRows');
    const trimRows = hot.getPlugin('trimRows');

    console.log(hiddenRows.getHiddenRows());
    console.log(trimRows.getTrimmedRows());
  },

Demo: handsontable - StackBlitz

Reproduction

reproduction

3

@aleksandra_budnik Thanx for the reply. Did you paste the correct Demo link?
It seems it is a demo of another issue.

4

Ah yes, here it is https://stackblitz.com/edit/r5tjzh-sg9xxn?file=index.js

5

Thank you for the correct link. But … is it true that no matter what filters you apply in the same column, the console.log keeps returning the same values? Is there a way to output the filtered or nonfiltered rows in a console.log?

6

Would something like this help https://stackblitz.com/edit/r5tjzh-sg9xxn?file=index.js or you would also like to get within hidden list those from trimRows and hiddenRows?

7

That was exactly what i was looking for!
Thank you for your patience!

8

I’m glad I was able to help. Have a great Monday!