Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-810

ArgumentsEvaluator.evaluateDatesArg uses relative cell position, should use absolute

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 6.0.0
    • 5.9.0, 5.12.2
    • 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

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

              Created:
              Updated:
              Resolved: