jspreadsheet / jspreadsheet/ce

setData with hidden columns shows incorrect values

Open
#1,334 4 comments 0 reactions 0 assignees View on GitHub

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.
image

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

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
image

After hiding "Finish" column
image

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

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.