No point-and-click way of entering 3D references
Submitted by Oliver Burnett-Hall
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:
- type '=SUM('
- activate Sheet1 by clicking on its tab
- hold down shift and click on Sheet16's tab
- click cell A1
- 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.
Version: git master