if vlookup table array reference a cell that is already evaluated, produce a CIRCULAR_REF_ERROR

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: 5.12.2, 6.1.0
    • Component/s: None
    • None

      Steps to Reproduce

      1. 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;
        			}
        

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

              Created:
              Updated: