https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
Josh Micich <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #3 from Josh Micich <[email protected]> 2009-12-31 13:27:59 UTC --- I can observe the funny behaviour you describe, but I think it is actually part of normal Excel functionality. The anomaly seems to arise from using relative coordinates in the cell reference (i.e. missing '$'). You can achieve the same affect by setting the 'Refers To' property in the 'Name Manager' dialog to the same value as you did in the java example. When 'navigating' to a defined name by using the 'Name Box', different behaviour is observed depending on whether the coordinates are absolute or relative. The simple fix is to use absolute coordinates in your cell reference. For example: "Sheet1!$A$2" BTW - you should replace uses of the method HSSFName.setReference() to HSSFName.setRefersToFormula(), as the old method will not be available in future POI versions. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
