jspreadsheet / jspreadsheet/ce
setData with hidden columns shows incorrect values
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 7.2k
- Forks
- 890
- PR merge metrics
- No merged PRs in 30d
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the issue with Start, Finish, and Duration columns: hide Finish, load data with setData, and inspect the displayed values and filter options. Done means hidden columns no longer shift values onto visible columns, and filter options reflect the changed visibility without requiring another visibility change.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript
- Domain
- frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100