Seeking clarification of range name scope in Calc

[JohnL]

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.

[mmohrhard]

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.