background ( all sheets in the same file ): one sheet named LECO - with a range name TotalShares defined with scope local one sheet named MDY - with a range name TotalShares defined with scope local one sheet named test - with a range name TotalShares defined with scope local one sheet named SummaryPositions
In a formula in the SummaryPositions sheet can I refer to the TotalShares range in the LECO sheet as LECO.TotalShares? When TotalShares was created in the LECO sheet it's scope was declared as local.
No you can't do that.
Local range names are only visible in the sheet where they are declared. You should think about using a global range name if you need it in more than one sheet, but keep in mind that local range names override global range names. So if you define RangeName1 in global scope and in Sheet1 you can use RangeName1 in every sheet but in Sheet1 it will refer to the local range name while in all other sheets it refers to the global range name.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-20 16:02:58 +0200
Seen: 151 times
Last updated: Mar 21 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
