| Summary: | [RFE] Multi zone named region | ||
|---|---|---|---|
| Product: | POI | Reporter: | Luca Billi <lucabilli> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
i don't believe NamedRegions support multi-zoned regions. Multi-zone names are now supported. Try the latest POI-3.5-beta4. Yegor |
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!