-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Normal
-
None
-
Affects Version/s: 5.12.2, 6.1.0
-
Component/s: None
-
None
Steps to Reproduce
- check B5, compare keikai with excel
Current Result
#N/A
Expected Result
In Excel, B5 is E
Debug Information
- formulas in B3:B5
=VLOOKUP("a", B1:C2, 2, FALSE) =VLOOKUP("b", B1:C3, 2, FALSE) =VLOOKUP("C", B1:C4, 2,FALSE)
their table arrays overlap, so keikai thinks there is a circular reference error
- WorkbookEvaluator.evaluateAny() return ErrorEval.CIRCULAR_REF_ERROR
if (cce.getValue() == null) { if (!tracker.startEvaluate(cce)) { return ErrorEval.CIRCULAR_REF_ERROR; }