Conditional formatting stops formula evaluation

[ianscriven]

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.

[ianscriven]

I can confirm that this issue is not present if using the alternate ConditionalFormatter provided by Greg Woolsey here - https://github.com/vaadin/spreadsheet/issues/461#issuecomment-279091036

[WoozyG]

This is point 5 from my initial comment's list of items fixed by the alternate code in #461.