jspreadsheet / jspreadsheet/ce

Hidden Columns with Formulas - Download CSV

Open
#1,281 0 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

Hello, Paul

Congrats, you have developed an excellent framework.

I am getting the following issue. I am not quite sure if it is an error.

I have several columns with formulas, some of them are hidden. I set the copyCompatiblity property as true.

When I download (export) the table as CSV ... for those columns hidden I am getting the formulas instead of the values ... the other columns (different that "hidden") are ok.

I would like to have the values (not formulas) either if the column type is hidden or not. Please advise.

Thanks.

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

No files, tests, or entry points are named. Reproduce CSV export with formula columns where some columns are hidden and copyCompatiblity is true, then trace the export path and verify that hidden formula columns produce their values rather than formulas.

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.