You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2003/01/25 00:30:48 UTC

DO NOT REPLY [Bug 16411] New: - Setting reference of Named range fails

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: poi-dev@jakarta.apache.org
        ReportedBy: mjmare@webtothemax.com


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