GNOME Bugzilla – Bug 573769
After loading a specific spreadsheet, it is locked and most tools disabled
Last modified: 2009-03-14 01:48:13 UTC
Please describe the problem: I loaded a slightly older, but native gnumeric spreadsheet, and am unable to edit anything. Most of the tools and menu options are greyed out (including, strangely, the 'File|Open' option). I can rightclick, go to format, and none of the lock options is enabled. After trying some modifications, none of which were visible, trying to exit does produce the 'Changes detected' dialog. Steps to reproduce: 1. Open the spreadsheet (attached) 2. 3. Actual results: Sheet is not editable Expected results: Life should continue as usual. Does this happen every time? Yes Other information:
Created attachment 129857 [details] This is the problematic file
Workaround found: The '-' in the workbook page name is causing the trouble. I edited the gnumeric xml file and now the spreadsheet file works again. The problem is easily tested: Change the name of a page to something with a '-' in it, and the page is blocked. (I used 'Skin-effect'. When I did a new sheet, I renamed again, and found that I couldn't edit anymore. Also, I wasn't able to re-edit the page name.) Shouldn't invalid characters in page names be detected? Particulary as there is no way to edit them? John
I am unable to reproduce with 1.8.2 or 1.9.4. Anyone else?
Not reproducible for me with 1.6.3-5.1+etch2, 1.8.4-3 or 1.9.4-1. John, can you please double check that this is the right file to test with? And please give us more details about what environment you're using, and where you've obtained your gnumeric build from.
Yes it is the correct spreadsheet. I just reopened it with the same result. My gnumeric is 1.8.3, 'home'built. Maybe something to do with that I have the 2.15.4 version of GTK+ installed? I have the impression that this version has some other issues (don't have much of a choice - glade-3 seems to need that version, at least). Distro is a quite modified (updated) Slackware 12.1., gcc version 4.2.3 Linux on6jc 2.6.23 #2 SMP PREEMPT Mon Apr 28 18:45:33 ART 2008 i686 athlon-4 i386 GNU/Linux WOW - weird! I just reopened gnumeric -again-, and now all works fine. Exactly the same file, now it's editable! Another try from 0, restarting gnumeric - again blocking. Another try from 0, typing something in a few cells, THEN loading the file, crash - I sent the backtrace through the crash feedback dialog. Another try - everything works. I could even combine the temporary spreadsheet with the 'offending' one. Another try - again blocked... This is very strange! If it is of any use, I'll run gnumeric in gdb and try to get some usefull information (at least of crashes, if any). Maybe someone could indicate where to try and catch the problem.
I am fairly certain the name of the sheet should not be what really matters here. Any further info, notably stack traces, would be useful.
Yes, as I remarked, enabling seems to be random. I would love to send a backtrace, but there is no crash. If someone could indicate a strategic point to debug in gnumeric, I can do that. But I need at least a general idea of where to look. A new semester is starting, and I don't have the time to try and analyze the entire program. I'm suspecting that the problem occurs during the spreadsheet loading phase. The strange combination of tools and menuitems which are disabled seems to indicate the loading process wasn't finished completely. Most of the GUI is disabled, except, strangely, copy, cut and paste. Also, the font selection things are enabled, but not justification. Save, SaveAs, Close and Quit are, but New and Open aren't. Maybe this gives a better idea in which state gnumeric is at that point. John
We really are going to need more information on this, so -->NEEDINFO. There is no rush: you're the only one seeing the problem. The menu graying out you see is what happens when you start editing a cell. That observation is consistent with you being asked about changes on Quit, although you would have to finish editing a cell to trigger that. If that is what happens, then the undo menu should show what changes were made. Is there anything on your system that could generate input to the program apart from the keyboard or mouse? Speech-to-text systems come to mind.
This state is entered by: -Starting gnumeric, -Selecting the file from the 'recent files', using the mouse. When the file is 'open', one cell is selected, and everything is as described earlier. No other input devices are present. Important: Now I'm noticing that it only happens when opening files from the 'Last used' list, already inside gnumeric. If I open with 'gnumeric <filename>', all is well. John PS: As I said before, this could be related to some problem with GTK. I have the latest (2.15.4) version installed, because of requirements of Glade-3.
Probably the same as bug 573769.
Hi Morten... I'd say so, too. This _is_ bug 573769 ;-) Or is there another bug similar? Anyway, I just downloaded GTK+ 2.16.0 and the new glib. I'll try and find some time to recompile everything. John
Tentative patch is in HEAD. Patch for 1.8.x is attached to bug 575267. *** This bug has been marked as a duplicate of 575267 ***