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 2019/03/16 00:26:34 UTC
[Bug 63264] New: Conditional Format rule evaluation calculates
relative references incorrectly
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: dev@poi.apache.org
Reporter: gwoolsey@apache.org
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63264] Conditional Format rule evaluation calculates relative
references incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63264
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
r1855619
--
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
[Bug 63264] Conditional Format rule evaluation calculates relative
references incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63264
Greg Woolsey <gw...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #1 from Greg Woolsey <gw...@apache.org> ---
Fixing the offset calculation and passing the top-left-most region rather than
the region matching the current cell fixed these cases. I've augmented unit
tests to check for them to avoid future regressions.
--
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
[Bug 63264] Conditional Format rule evaluation calculates relative
references incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63264
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |61652
Referenced Bugs:
https://bz.apache.org/bugzilla/show_bug.cgi?id=61652
[Bug 61652] Attempting to getConditionalFormattingForCell causes NPE
--
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