You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2014/03/13 01:14:20 UTC

[Bug 56254] New: Reference to named range that does not exist causes exception

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: dev@poi.apache.org
          Reporter: cliff.binstock@xbrlcloud.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 56254] [PATCH] Reference to named range that does not exist causes exception

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56254

Nick Burch <ap...@gagravarr.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |PatchAvailable
            Summary|Reference to named range    |[PATCH] Reference to named
                   |that does not exist causes  |range that does not exist
                   |exception                   |causes exception

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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 56254] Reference to named range that does not exist causes exception

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56254

Cliff Binstock <cl...@xbrlcloud.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |cliff.binstock@xbrlcloud.co
                   |                            |m

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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org