Apache OpenOffice (AOO) Bugzilla – Issue 14569
named range in copied sheet
Last modified: 2013-08-07 15:15:02 UTC
When copying a sheet wich has a named range, the name is not copied, but still points to the range in the original sheet. So the formula =sum(myrange) does not work inside the copied sheet like expected.
You have to use absolute links instead of relative links to get your desired solution (e.g. "sheet1.$A$1" instead of "$sheet1.$A1$1")
Should read "relative ... instead of absolute ...". I suggest to use just "$A$1" without any sheet name.
Closed because invalid
When I removed the sheetname it works fine until I insert a line above the range inside the copied sheet: the named range is not moved properly and the formula misses the first line of the range. To get it working again I have to do the same insert of line in the original sheet: that influences the situation in the copied sheet - actually very unforseeable in collections of many sheets.
I agree, that looks strange => development
A reference without a sheet name should behave identical to a reference with a relative sheet name pointing to the very same sheet. To update range name references that contain a relative reference part during insertion/deletion is an error. The workaround is to use self-relative sheet references like Sheet1.$A$1 as suggested by Oliver.
Fixed on branch cws_src680_dr18: sc/inc/compiler.hxx 1.18.14.1 sc/source/core/tool/compiler.cxx 1.46.14.1 sc/source/core/tool/rangenam.cxx 1.13.296.1
Reopen to be able to reassign.
Reassign to QA.
Restore status.
verified in internal build cws_dr18
Will this also fix the problem with graphs in copied sheets as discussed in issue 23212 ?
Gmaths, No, issue 23212 is unrelated, that's about a special case of absolute references not to be treated as such if copied along with the data they reference. Eike
Found fixed on Master src680m54 using Linux, Solaris and Windows build
In 1.9.62 I found still problems with names of ranges. Please look at attached file "names_in_calc_1962.oos". I feel there should be different issues arising from this document, but I can not yet assign them properly. Gisbert
Created attachment 21218 [details] problems with names of cell-ranges
hi Eike, please have a look at this one and give us a comment. Frank
It'a all correct. Relative references in named ranges are adjusted to the position where they are used in formulas. The name box uses a named range's original definition, including sheet, regardless of absolute or relative references.
So I close it.
closed fixed
*** Issue 76863 has been marked as a duplicate of this issue. ***