GNOME Bugzilla – Bug 636031
Making a chart in a new sheet blocks the formula bar
Last modified: 2010-11-29 09:46:09 UTC
When a chart is made, the option of making it a new sheet is presented. If this is done, the formula bar will be locked on all sheets. It will not be usable and cells have to be edited within the cell instead of in the formula bar. A temporary fix is restarting gnumeric and open the file via the open dialog, not the history (or else the problem will still occur). Once opened, the formula bar will work until you click on the sheet with the graph again and the problem repeats (formula bar will be locked again). A more permanent solution is not creating charts in new sheets, but rather in existing sheets. This is highly inconvenient.
Some observations: If the file is opened in the history, the observed issue may be related to bug 625687. This can easily be replicated in current git: new gnumeric create a chart on a new sheet (or create achart in te current sheet and copy/move to a chart sheet) formula bar has become non-functional
Also, I see that when the chart sheet is active, some menus are deactivated, but perhaps not those which should be. Seems I missed that all.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report. We still need to decide which menu entries should be available when a chart sheet is active.
Jean, the statistics tools and the data->fill items currently allow data to be entered on the graph sheet. That is probably a bad idea.
Fully agreed. Actually cells do exist in the graph sheet, just they are never visible. It's possible to add data using the python console and then use these invisible data in the chart.