handsontable / handsontable/hyperformula
Only execute formulas with none empty cells
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 2.8k
- Forks
- 171
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 7
Description
Description
Would be great if you could introduce an option with which you can set that formulas are only calculated if every cell it contains is also filled.
So if a cell referenced by the formula is not filled, i.e. empty. The result should also be empty.
Links
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
The issue names no source files, tests, or entry points; begin by reviewing the linked JSFiddle reproduction. Trace how referenced empty cells affect formula evaluation, then define completion as an option that leaves the result empty whenever any referenced cell is empty. Confirm behavior against the reproduction and add coverage in the relevant evaluation tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- data
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100