| Summary: | Wrong "named range" detection | ||
|---|---|---|---|
| Product: | POI | Reporter: | sebastian <skieble> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | 2.5-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
The reported problem is not reproducible with the latest trunk. Please try the latest 3.5-beta4 or download daily builds from http://encore.torchbox.com/poi-svn-build/ Yegor |
hssf doesn't make a difference between a vba function aka =MY_VBA_FUNCTION("lskdjflsk") and a named range. it identifies two named ranges "RANGE1" (correct) and "MY_VBA_FUNCTION" (wrong). that happens if i remove the underlying vba code. i'll try to attach a sample xls file java.util.EmptyStackExceptionTabelle2!$C$9:$H$29 at java.util.Stack.peek(Stack.java:79) at org.apache.poi.hssf.record.NameRecord.getAreaReference (NameRecord.java:668) at org.apache.poi.hssf.usermodel.HSSFName.getReference(HSSFName.java:87) at Main.<init>(Main.java:38) at Main.main(Main.java:45) Exception in thread "main"