ArgumentsEvaluator.evaluateDatesArg uses relative cell position, should use absolute

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 6.0.0
    • Affects Version/s: 5.9.0, 5.12.2
    • Component/s: None
    • None
    • None

      Steps to Reproduce

      Run attached sample xlsx in keikai
      repro.xlsx

      Current Result

      E2: 20
      F2: 22

      Expected Result

      E2: 20
      F2: 20

      Debug Information

      The org.zkoss.poi.ss.formula.atp.ArgumentsEvaluator.evaluateDatesArg(ValueEval, int, int) retrieve cells by area.getValue(i, j) where i and j are absolute coordinates, causes the wrong cells to be retrieved
      Should use getAbsoluteValue instead

      Workaround

      deploy attached override class under org.zkoss.poi.ss.formula.atp.ArgumentsEvaluator ArgumentsEvaluator.java

        1. ArgumentsEvaluator.java
          5 kB
        2. repro.xlsx
          10 kB

            Assignee:
            Unassigned
            Reporter:
            MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: