Bug 16845 - [RFE] Multi zone named region
Summary: [RFE] Multi zone named region
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-02-06 15:30 UTC by Luca Billi
Modified: 2008-12-16 09:36 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Luca Billi 2003-02-06 15:30:41 UTC
Using jakarta-poi-1.9.0-dev-20030122,
I get a warning ([WARNING] Unknown Ptg 29 (41))
parsing an Excel2000 workbook containing a multi-zone named region
(Reference: MySheet!$H$14,MySheet!$I$15).

The following code

HSSFWorkbook wb = new HSSFWorkbook(inputStream);
System.out.println(wb.getNameAt(wb.getNameIndex("MultiArea")).getReference());

besides the above warning, prints:

#REF!
Comment 1 Danny Mui 2003-02-06 15:41:49 UTC
i don't believe NamedRegions support multi-zoned regions.
Comment 2 Yegor Kozlov 2008-12-16 09:36:56 UTC
Multi-zone names are now supported. Try the latest POI-3.5-beta4. 

Yegor