Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 378
    • Issues 378
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 3
    • Merge requests 3
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOME
  • gnumericgnumeric
  • Issues
  • #75

Closed
Open
Created Feb 23, 2007 by Bugzilla@bugzilla-migration💬Reporter

No point-and-click way of entering 3D references

Submitted by Oliver Burnett-Hall

Link to original bug (#411403)

Description

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.

Version: git master

Assignee
Assign to
Time tracking