https://issues.apache.org/bugzilla/show_bug.cgi?id=56254

            Bug ID: 56254
           Summary: Reference to named range that does not exist causes
                    exception
           Product: POI
           Version: 3.11-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: critical
          Priority: P2
         Component: POI Overall
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 31385
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31385&action=edit
Patch (and test)

Referencing a syntactically correct named range that does not exist should
result in a cell with a #REF! error.  However, it creates an exception.

I have submitted a patch that works for INDIRECT() reference which solves my
immediate need, but the exception for a direct reference is pretty "deep" in
the stack:  I suspect that there should be a unique exception created that is
caught by the formula evaluator, which would then set the error code properly.

Note that the patch includes:  1) code fix; 2) working test for INDIRECT
reference; 3) commented out test for direct reference.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to