Conditional formatting uses old value for formula cell
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 50
- Forks
- 53
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 1
Description
This is applicable to the current master branch, not a released version - specifically pull request #648
See the attached file. Both cells have a conditional formatting rule (red with red text) if the value is > 5. With the latest build using POI 3.17, changing A1 to 6 causes only A1 to be highlighted red, even though B1 ("=A1") is also 6. Subsequently changing A1 back to 5 causes B1 to be highlighted red, even though it's value is 5 again.
Seems to me that the conditional formatting is being evaluated before the formula is - so it's using the old value of the cell.
Tagging @alexberazouski and @WoozyG as I'm not sure if this is a Vaadin Spreadsheet issue or a POI issue.
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
Reproduce the issue with the attached workbook on the current master branch, then inspect pull request #648 and the POI 3.17 integration. Trace the order of formula recalculation and conditional-format evaluation; done means changing A1 between 5 and 6 updates both A1 and B1 highlighting according to their current values.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100