Bug 30070 - Wrong "named range" detection
Summary: Wrong "named range" detection
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.5-FINAL
Hardware: All All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-13 11:20 UTC by sebastian
Modified: 2008-12-29 08:49 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description sebastian 2004-07-13 11:20:46 UTC
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"
Comment 1 Yegor Kozlov 2008-12-29 08:49:35 UTC
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