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 636031 - Making a chart in a new sheet blocks the formula bar
Making a chart in a new sheet blocks the formula bar
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Charting
1.10.x
Other Linux
: Normal major
: ---
Assigned To: Jean Bréfort
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-11-29 02:58 UTC by Brian Mikolajczyk
Modified: 2010-11-29 09:46 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Brian Mikolajczyk 2010-11-29 02:58:51 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.
Comment 1 Andreas J. Guelzow 2010-11-29 03:11:54 UTC
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
Comment 2 Jean Bréfort 2010-11-29 06:36:23 UTC
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.
Comment 3 Jean Bréfort 2010-11-29 06:58:22 UTC
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.
Comment 4 Andreas J. Guelzow 2010-11-29 08:09:36 UTC
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.
Comment 5 Jean Bréfort 2010-11-29 09:46:09 UTC
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.