https://bz.apache.org/bugzilla/show_bug.cgi?id=61764

--- Comment #1 from Greg Woolsey <[email protected]> ---
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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to