https://bz.apache.org/bugzilla/show_bug.cgi?id=63264
Bug ID: 63264
Summary: Conditional Format rule evaluation calculates relative
references incorrectly
Product: POI
Version: 4.0.x-dev
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I apparently missed this when I implemented conditional format evaluation. One
of the test files even showed the problem, I just wasn't checking the right
cells.
Issue 1, when adjusting formulas for relative references, the calculation is
using the full target row/column rather than calculating an offset from the
region top-left corner.
Issue 2, Excel appears to specify that if a rule applies to multiple regions,
relative references are calculated from the top-left-most cell in any region,
not the one containing the current target cell, as is being passed currently
from the rule.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
