Bug 44949 - getSheetName does not work with noncontiguous named ranges
Summary: getSheetName does not work with noncontiguous named ranges
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-05-07 08:16 UTC by Martin Allerstorfer
Modified: 2013-08-05 09:08 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Martin Allerstorfer 2008-05-07 08:16:16 UTC
Using the method getSheetName of the class HSSFName does not work with noncontiguous named ranges. More precisely the method getExternSheetNumber of class NameRecord uses the wrong entry in the stack field_13_name_definition in that case. Because for noncontiguous named ranges the first entry is not Area3DPtg or Ref3DPtg but MemFuncPtg. So it always return the first sheet.

I tested it with version 3.0.2 and 3.1 BETA1, both without success.
Comment 1 Nick Burch 2008-07-10 15:56:41 UTC
Any chance you could upload a small sample spreadsheet that triggers this problem, along with letting us know which named range will trigger the issue? That'd give us something to test a fix against
Comment 2 Dominik Stadler 2013-08-05 09:08:54 UTC
no response in a long time => resolving for now, please reopen with more information ifnthis is still an issue