After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 411403 - No point-and-click way of entering 3D references
No point-and-click way of entering 3D references
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: GUI
git master
Other All
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-02-23 23:35 UTC by Oliver Burnett-Hall
Modified: 2018-05-22 13:20 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Oliver Burnett-Hall 2007-02-23 23:35:38 UTC 
Gnumeric supports evaluation of 3D references, but at the moment these can only be entered by typing in the whole expression -- unlike most expressions, they can't be entered by mousing only.

The way this should work is by doing something like this:
1) type '=SUM('
2) activate Sheet1 by clicking on its tab
3) hold down shift and click on Sheet16's tab
4) click cell A1
5) type in ')' and hit enter
From this you should get the formula '=Sheet1:Sheet16!A1'

This is sort of related to bug 53733, which is about selecting multiple sheets in general; I'm creating this as a separate bug as it would probably be possible to solve them separately.
Comment 1 GNOME Infrastructure Team 2018-05-22 13:20:48 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/75.