Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 398
    • Issues 398
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 3
    • Merge requests 3
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOMEGNOME
  • gnumericgnumeric
  • Issues
  • #509
Closed
Open
Issue created Jul 12, 2020 by Charles Howes@PenelopeFudd

Gnumeric 1.12.47 on MacOS 10.15.5 (via Brew): Tools > Scenarios not working properly

Hi, found a bit of a problem with Gnumeric on MacOS.

I'm trying to use Scenarios to see the effect of changing commission.

  • First problem: the help functions don't work on MacOS:
(gnumeric:18807): GLib-GIO-WARNING **: 12:54:55.357: No default handler found for url scheme 'ghelp'.

First workaround: Access Gnumeric Help via Google.

  • Second problem: the scenario function isn't documented: https://help.gnome.org/users/gnumeric/stable/gnumeric.html#sect-advanced-analysis-scenarios
6.5. Analysis using scenarios
6.5.1. Adding new scenarios
6.5.2. Viewing and managing scenarios
6.5.1. Adding new scenarios
6.5.2. Viewing and managing scenarios

Second workaround: View help for Excel's Scenarios online: https://www.excel-easy.com/data-analysis/what-if-analysis.html#create-different-scenarios

  • Third problem: the scenario function generates a blank report.

Steps:

  1. Click on the cell you're going to change for these scenarios
  2. Tools > Scenario > Add..., type in the scenario name, click save.
  3. Change the cell
  4. Tools > Scenario > Add..., type in the scenario name, click save.
  5. Tools > Scenario > View...
  6. Click on first scenario
  7. Click on 'Create Report', get error 'Results entry did not contain valid cell names'
  8. Click 'ok'
  9. Click 'Options'
  10. Click cell picker icon, choose result cell, click cell picker icon again
  11. Click 'View'
  12. Click 'Create Report'
  13. View new sheet:
Scenario Summary
                | Current Values | Scenario 1 | Scenario 2
Changing Cells: |

It isn't filling in the table. Screen_Shot_2020-07-12_at_1.28.12_PM

Third workaround: none

  • Fourth problem: When you try to delete the scenarios to try again, the last scenario can't be deleted (the delete button is disabled).

Fourth workaround: Click 'ok', then open Tools > Scenario > View... and then you can delete the last scenario.

Also, I managed to get a Segmentation fault: 11 while adding a scenario (typing the name) and gnumeric crashed, but it's not reproducible. MacOS sent a copy of the stack trace to Apple.

Hope this has been helpful!

Thanks!

Assignee
Assign to
Time tracking