setData with hidden columns shows incorrect values

[lhassis]

Hi everyone!

When I set data into a table that has hidden columns, the new data is, at first, shown on incorrect columns. Data follows the visible columns order and not the name property. After a change in the visibility status, data is correctly organized. An example. Columns Start, Finish and Duration.

If I hide Finish column and load data into table again, values from finish are show on Duration column.

And by changing finish column visibility, data are back on the correct columns.

In addition, the filter options remain the same, after hiding columns, as shown below. Before hiding "Finish" column

After hiding "Finish" column

Is this an issue or is there any workaround that I should be doing? Thanks in advance.

[vettadigital]

Hi everyone! For the data problem we did a "workaround" showing all columns before setting data and then hiding again the ones that were previously hidden. For the filter problem we made a 2 line change on hideColumn and showColumn functions and we're submitting a pull request. https://github.com/jspreadsheet/ce/pull/1337

[Valkah]

I just ran into this same issue. I guess no one is going to merge #1337?!

[hodeware]

I just ran into this same issue. I guess no one is going to merge #1337?!

I will release a patch including this one.

[amalinaaziz]

Any fix on this?