-
Bug
-
Resolution: Fixed
-
Normal
-
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