#toc, .toc, .mw-warning { border: 1px solid rgb(170, 170, 170);
background-color: rgb(249, 249, 249); padding: 5px; font-size: 95%; }#toc h2,
.toc h2 { display: inline; border: medium none; padding: 0px; font-size: 100%;
font-weight: bold; }#toc #toctitle, .toc #toctitle, #toc .toctitle, .toc
.toctitle { text-align: center; }#toc ul, .toc ul { list-style-type: none;
list-style-image: none; margin-left: 0px; padding-left: 0px; text-align: left;
}#toc ul ul, .toc ul ul { margin: 0px 0px 0px 2em; }#toc .toctoggle, .toc
.toctoggle { font-size: 94%; }body { font-family: 'Times New Roman'; color:
rgb(0, 0, 0); widows: 2; font-style: normal; text-indent: 0in; font-variant:
normal; font-weight: normal; font-size: 12pt; text-decoration: none;
text-align: left; }table { }td { border-collapse: collapse; text-align: left;
vertical-align: top; }p, h1, h2, h3, li { color: rgb(0, 0, 0); font-family:
'Times New Roman'; font-size: 12pt; text-align: left; }
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
NameBehavior.gnumeric
Description: application/gnumeric
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
