You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/11/15 02:24:50 UTC
[Bug 61764] Conditional formatting rules don't evaluate properly for
some multi-range rule definitions
https://bz.apache.org/bugzilla/show_bug.cgi?id=61764
--- Comment #1 from Greg Woolsey <gw...@apache.org> ---
It turns out Excel evaluates relative references in the conditional formula
relative to the range the formula applies to by treating the top left cell of
the applicable range as "A1". POI code currently shifts those references by
starting from the formula-referenced cell and adding the current range cell's
offsets.
So offsets need to change to be
formula ref + range top-left + current cell range offset
rather than the current
formula ref + current cell range offset
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org