Conditional formatting stops formula evaluation
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 50
- Forks
- 53
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 1
Description
Please see this spreadsheet: conditional formatting issue.xlsx
When a cell has a conditional formatting rule that references a formula cell, the referenced cell doesn't update properly when the cells used in the formula change.
In the attached spreadsheet, cell A2 is a formula, simply "=A1". Cell A3 has a conditional formatting rule that colors it red if the value is greater than the value in A2. Now the value in A2 is not updated when A1 changes.
This makes conditional formatting pretty much un-usable (at least for my use-case), as it only really supports static values.
Contributor guide
No contributing guide indexed for this repository
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
Open conditional.formatting.issue.xlsx and reproduce the case where A3's rule depends on formula cell A2, with A2 set to =A1. Trace how formula recalculation interacts with conditional formatting, then verify that changing A1 updates A2 and the conditional formatting result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- data
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100