GNOME Bugzilla – Bug 442707
Impossible to insert a chart for the Win32 port
Last modified: 2007-07-06 10:38:31 UTC
Please describe the problem: When using the assistant to insert a chart, the preview function shows a completely blank chart and the "Next" button is greyed. If the "Insert" button is pressed to finish the process, the obtained chart is blank. This happens on the windows port of the program, run on WinXP. Steps to reproduce: 1. Prepare dummy values for x and y (I tried 1,2,3,4,5 for x and rand() for y) 2. Select the 2 columns 3. Click on "Insert chart" Actual results: It seems that the program cannot "see" the data, and produces a blank graph. Expected results: I would expect the program to plot my data. Does this happen every time? Yes Other information: Address from which I obtained the program: http://www.gnome.org/~jody/gnumeric/win32/gnumeric-1.7.10-win32-1.exe
Which plot type have you selected? Does this also happen for other plot types?
i replicate this for bubble chart, perhaps a bubble chart with undefined bubble sizes should degrade to look like an XY plot (bubbles of no dimension would be points) also I can make this happen if I highlight data in sheet1, switch to sheet2, then hit the insert chart button. but that sort of makes sense. I notice *other* spreadsheets will open a dialog asking the user for data if the program finds none
From the preview function, it seems that it happens for all plot types. Moreover, if I insert a blank graph, double-click on it and try to add the curve manually, when I try to select the data for x or y then the dialog box is empty. I think it should display the references of the cells which are selected, but I might be wrong since I have never used gnumeric beforehand.
I can't seem to make this happen, if you attach an example file I can test to see if the problem shows up on my windows system.
Using Windows XP SP2 latest version Gnumeric I am a newbie to Gnumeric. I installed it saturday last and when I tried to insert a chart the chart type dialgue box was not showing any samples as it was supposed to do. In addition when I tried to insert a chart no joy. However, when I open quite detailed saved Excel spreadsheets they open OK charts show no problem. Now uninstalled Gnumeric simply because it is not useable in its current state of development. A great great pity because it seems much better than OpenOffice Terry
Created attachment 89342 [details] Bug example Here is a sample file showing the problem. For me too, complicated Excel files are correctly read, but I cannot create native gnumeric charts.
i also see a blank chart... if you would like to have the gnumeric experience, there is a way to work around this: double click the chart highlight 'Chart1' in the 'customize chart dialog click the 'Add' button -> plot -> (choose type, I'll use XY points for example) now under 'Chart1' you have Grid1, X-axis1, Y-axis1, and PlotXY1 under PlotXY1 there is 'Series1' click the 'Series1' under you will see tabs Data, style, ... under the Data tab you can add your points (do NOT click the buttons next to the input fields, I just discovered a bug there !) you can just put your cursor in the field then use your mouse to highlight the data in the spreadsheet. gnueric handles charting differently than other spreadsheets. It was a little weird at first, but it is quite empowering and makes alot of sense if you learn it ! It is now painful for me to meke charts any other way... in my (limited) experience, gnumeric is indeed better than OpenOffice.org. The developers here are very helpful and seem to fix things pretty quickly. If the program isn't what you need at the moment, it may be soon ! You seem to be running the same kind of setup I am (XP-sp2), the only difference being that I installed gnumeric over it's previous version, not sure if it matters. perhaps somebody more experienced than me can figure out this problem.
see bug 444064 If you click the menubar of the blank add data dialog and drag it around it somehow repairs itself.
Thanks Aaron ! This works for me too. However, the button next to the input field in the dialog box works fine in my case, and it is even the only way I have found to validate the input (typing return doesn't do anything). After trying it, I also have the feeling that gnumeric can be very powerful, and I have good hope that this annoying bug will be fixed soon !
It looks like that for some reason, goffice can't find the icons needed by the graph guru. The files are there though, in C:/gnumeric/share/pixmaps/goffice/0.4.0
This is the same as Bug 394183 – Charting dialog is empty, which I submitted and was dismissed as Solved. It is obviously not solved... Unfortunately since only Jody was kind enough to provide a binary for us Windows morons, I tested it recently and posted on the same Bug reports which apparently are ignored since they are Closed. The last (Windows) version where charting is working properly is Build 1.7.0 I apologize for the strong words but as a Bug reporter I feel neglected. Peace.
I have used gnumeric on a couple windows computers through the 1.7's up to 1.7.10 and have not seen this problem. one day everybody will be using free software... is is really that difficult to create a windows build? Isn't it just setting some compiler directives and compiling with a windows compiler? If somebody could break it down step by step I am sure there would be a volunteer to do the compiling as each new release happens.
Aaron: to create a windows build you first of all should have a computer running windows. That alone exclude lots of people (including most of the Gnumeric developers).
Created attachment 90472 [details] no preview when adding a chart
Created attachment 90473 [details] when including the chart the chart is empty
Created attachment 90474 [details] properties show that now data is associated to the chart
I just mad a fresh install with the latest win32 build and can confirm that the bug still exists. version: 1.7.10-win32-1 OS: WinXP In order to document the problem for the non-windows users I added some screenshots to the bug-report. Hope this helps to clarify the issue. If there is anything that I can do to debug, please let me know. However I have to admit that I am not a developer of any kind.
Thank you for the screen shots they change my understanding of the problem. The fact that you can see the names of the plots (#14) means that the plugins are at least partially visible. The emptiness in the other screenshots just indicates that the chart has no plots, hence there is nothing to display. 1) What happens if you click in the blank area beside the list of plot types ? or even when you select items from the list of plot families on the first page of the guru ? 2) From the property dialog can you 'Add' a plot using the attached menu (Note you'd still need to manually add some data if this works) ? 3) Do plots stored in files display ? 4) Can you try running gnumeric from a 'cmd' window to see if there are any errors or warnings displayed. Thanks
Created attachment 90560 [details] A screenshot of the debugging messages 1) the chart subtypes are not displayed since they require an icon. It's then impossible to create a chart. 2) It's possible to add a chart from the add menu. 3) Yes 4) See screenshot.
I've forgotten to add: it's a fresh windows install with a fresh gnumeric 1.7.10 install.
*** Bug 394183 has been marked as a duplicate of this bug. ***
I see the problem. #ifdef WIN32 libgoffice_icon_dir = g_build_filename (dir, "share", "pixmaps", "goffice", NULL); #endif vs AC_SUBST(goffice_icondir, '${datadir}/pixmaps/goffice/${VERSION}') Please try copying the contents of the 0.4.0 directory into the parent directory and see if things work.
bingo. I just tried it under wine, and that fixed things. We'll put the fix into goffice-0.4.1, but it may take some time to get a new gnumeric build. For the time being jsu copy the files from <install_point>/share/pixmaps/goffice/0.4.0 into their parent directory.
Now that was easy, wasn't it? :) And you don't even have to create a new build :) Except for new users which may be disappointed by not being able to create graphics. Couldn't you create a new installer? Isn't it just a matter of where the files are unpacked to?
Patch is in goffice for 1.4.1
I am Windows XP SP2 where do I download the corrected version ( Chart problem)? Thanks Terry
There are no updated packages as yet. 1.7.11 will have the patch. In the mean time you can copy the images into the parent directory as mentioned above.