DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=27622>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=27622 Named range reference becomes invalid on removeSheet Summary: Named range reference becomes invalid on removeSheet Product: POI Version: 2.0FINAL Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] (1) My workbook has sheets SHA, SHB, SHC, ... (2) Create a named range pointing to e.g. SHD!$A$2:$A$16 (3) Delete some sheets (not SHD, of course) (4) The named range now points to e.g. SHA!$A$2:$A$16 >From taking a glimpse at HSSFName, I guess named ranges are internally linked to the sheet nidex rather than the name. I guess when running workbook.removeSheet, the indexes of the named ranges are not update (or something like that) NOTE: haven't tried release 2.5, maybe it's already fixed there. Thanks nd good luck Simon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
