DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16411>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16411 Setting reference of Named range fails Summary: Setting reference of Named range fails Product: POI Version: 2.0-dev Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Critical Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I'm trying to modify a named range in an existing spreadsheet, like so: HSSFName name = wb.getNameAt(0); System.out.println("name:"+name.getNameName()+" "+name.getReference() +" "+name.getSheetName()); name.setReference("Verkopen!$A$1:$C$36"); System.out.println("name:"+name.getNameName()+" "+name.getReference() +" "+name.getSheetName()); Outputs: name:VerkoopData Verkopen!$A$1:$C$19 Verkopen name:VerkoopData Verkopen!$IU$1:$C$36 Verkopen The first (unmodified) reference is OK, the second (modified) is obviously wrong. TIA -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
