GNOME Bugzilla – Bug 127412
side of an axis not properly imported from an .xls file
Last modified: 2006-04-15 11:00:32 UTC
When you set the Y-axis to be at the right in a XL graph, save it and open it in gnumeric, the Y-axis is at left in gnumeric but the x-axis is at top. I will provide an example xls file. I think it comes from this stupid thing in XL graphs: you have to set the position of the X-axis in the Y-axis dialog. Don't forget: "don't underestimate the number of stupid things that excel can do" :-)
Created attachment 21629 [details] The .xls file showing the problem
In the file ms-chart.c: axis properties are read independently: we first read X-axis properties and then Y-axis properties. However, this is typically a cross-property: a property in Y-axis (in XL file) influences a property of X-axis in gnumeric. A solution would be to swap "str_pos" after we have read all the chart: str_pos of X-axis = str_pos of Y-axis str_pos of Y-aixs = str_pos of X-axis Sorry, my coding knowledge are roughly zero and I am unable to create a patch...
This is known but will take some work. The xls file format is not terribly clear on how multiple axes are handled. I'll play with it shortly.
This is still in 1.4.2.
Looks like this has been fixed in CVS. I see 2 axes, x axis at the bottom and y axis to the right. Is this correct?
This is not fixed, at least in 1.5.2. Actually, I see two bugs here. When you open the file in gnumeric and XL: - Y-axis at right and X-axis at bottom in gnumeric - Y-axis at left and X-axis at top in XL And then, if you try to resave the file opened in gnumeric and reopen it, the Y-axis is at left and the X-axis is at bottom, both in gnumeric and XL.
This seems to be fixed in 1.6.3.