poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 63264] New: Conditional Format rule evaluation calculates relative references incorrectly
Date Sat, 16 Mar 2019 00:26:34 GMT

            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

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

View raw message