Name Behavior



I have a question regards referencing a cell  in Sheet1 from Sheet2.

The cell to be referenced has a Name via: Edit, Modify, Names, Sheet1, ”test”, ”$B$5”

“=Sheet1!$B$5“      works from Sheet2

“=Sheet1!test”         does not work from Sheet2

Gnumeric file attached.

I am new to gnumeric, using 1.12.0.   

Is “Sheet!Name” a valid way to reference a cell in another sheet?

-Norm 

Attachment: NameBehavior.gnumeric
Description: application/gnumeric



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]