Bug 62162 - indirect function with named range reference causes NPE
Summary: indirect function with named range reference causes NPE
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.15-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-07 11:15 UTC by samson
Modified: 2018-03-17 23:27 UTC (History)
0 users



Attachments
Sample file to replicate the problem (8.55 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-03-07 11:15 UTC, samson
Details
Unit test to replicate the issue (1.94 KB, patch)
2018-03-07 11:16 UTC, samson
Details | Diff
Possible solution (1.12 KB, patch)
2018-03-07 11:17 UTC, samson
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description samson 2018-03-07 11:15:39 UTC
Created attachment 35753 [details]
Sample file to replicate the problem

Referring a named range in a different sheet using from an INDIRECT causes NPE. The problem seems that the “OperationEvaluationContext” is searching the name in the referee sheet (the one containing the formula) instead of the owner of the name. See the suggested patch for details.
Comment 1 samson 2018-03-07 11:16:38 UTC
Created attachment 35754 [details]
Unit test to replicate the issue
Comment 2 samson 2018-03-07 11:17:16 UTC
Created attachment 35755 [details]
Possible solution