How to reference a named cell on a named sheet

English
#1

This has to have been answered already, but my search didn’t find it.
I have a sheet named Income with a cell named Both_Taxable. If I try to reference that from another sheet in the same document, e.g.

=Income.Both_Taxable

I get a “#NAME?” error.
If I reference it as

=Income.I32

it works.
Running LO 7.4.4.2 on FreeBSD 12.4

#3

It depends on the scope of Name (see Menu / Sheet / Named Ranges and Expressions / Manage...).
If scope is Document (Global) then as in @karolus 's answer, if scope is Income (sheet) then =Income.Both_Taxable.

#4

@sokol92 : As Gary_Aitken already states … The scope is global

#2

Hallo

=Both_Taxable

:blush:

1 Like
#5

Ugh. I didn’t realize cell names have to be unique for the whole document?

#6

Only the Names in global-scope

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.