Apache OpenOffice (AOO) Bugzilla – Issue 77703
Imported chart with ranges from different file is empty
Last modified: 2013-02-24 21:20:29 UTC
I just received a xls file containing a column plot (I have attached the file) and there are several formatting problems, some of which are making the graph useless : - in the original the colours for the three columns were black, grey and white with small points; in OO the last is also converted to black. - the column titles in the original were "NEE", "GPP", "TER", in the OO import they are "Column n", "Column U", "Column Z", respectively; if I would not have had the original, I would not have been able to reproduce which column was which - the y axis in the original goes from-2000 to +1500 in steps of 500 units, in OO the y axis goes from -1750 to +1500 in steps of 250 units I have also attached a screen copy of the xls version and the OO version
Created attachment 45334 [details] xls file containing column graph which shows import problems
Created attachment 45335 [details] screen copy of xls column plot opened in OO2.2
Created attachment 45336 [details] screen copy of xls column plot opened in EXCEL
I confirm the problems with OOo2.2.1rc2 and OOo680m212. It is entire wrong and unusable in chart2. But the chart is based on data from another file, therefore OOo cannot get them. Please attach an example, where the data are also available. The wrong fill seems to be the same problem as in issue 59207. In addition, the legend has a wrong position.
Actually I do not have the original data. On the otherhand I think this is a situation OO should be able to cope with : it is quite usual that somebody copies a graph from one xls file to another without copying the data. Actually the data are not the problem at all as datawise the graph Chart produces is entirely correct. This is mostly a formating problem (wrong filling, wrong legend position, wrong axis numbers), withthe exception of the column headings, which would (could ?) be written in the original data. However they also might have been changed, so they also should be independent of the original data.
When updating links to other documents while loading the attached doc, the imported chart is also empty with version OO 2.0. I would expect that as I do not have the linked files. But the data vanishes in the new chart also when the linkes are not updated. ->bm, dr: Could you please have a look why the data vanishes also when the links are not updated. Thanks a lot.
AFAIK, copying a chart from Excel somewhere else (e.g. Word) is still a copy of the entire (!) Excel document as OLE object showing only the chart. Which you can observe by activating the chart, where you see the Excel UI including all the sheets. Maybe this changed with MS Office 2007.
->DR: the third series contains a pattern fill. In OOo 2.2 I saw that we import that as a bitmap fill with a non-existing bitmap. That is shown black in the replacement image and white when the chart is activated. Is there a bitmap missing?
->DR: Do you have an idea how we can fix the data problem? We do not support data ranges from other files. I suspect it also didn't really work in the old chart, did it? We can show data from other files that is linked as a separate sheet. In the old chart it works probably, because we get the current data via the MemChart as "own" data while still being marked as a chart getting data from Calc. Maybe we have to fix this by using a chart with own data for the moment?
see issue 76481 for the pattern problem
The data is there in the calc. Use Format/Sheet/Show -> an additional sheet appears with name 'file:///H:/enroute...'#histogrammes ->bm: Could it be that the xml range parser has a problem with this extraordinary sheet name?
Yes, that's true. You can create a chart from such a sheet, and you can save it. The names are correctly encoded in the file (.ods), but loading does not work. Probably a problem in the Calc data provider implementation. Will evaluate (and fix, as sab is no longer working for sc)
Created attachment 46756 [details] ODF file with chart made out of sheet with complicated name
->NN: The attached NEE.ods ODF file was correctly stored by creating a new chart out of data from the sheet with the complicated name. When loading this document creating an XDataSequence via ScChart2DataProvider::createDataSequenceByRangeRepresentation() fails, becuase ScRangeStringConverter::GetRangeListFromString() returns false. (see chart2uno.cxx:970) Please check if there is a problem in this routine or where the problem might be. I suppose when this is fixed, the .xls document should also load correctly.
Retargeting because of time constraints.
Not finished in time for 2.4, retargeting.
Fixed on CWS "dr62". Changed: rangeutl.cxx 1.13.20.1
Reassigning to QA for verification
Seen ok in cws dr62. Issue 76481 deals with the missing pattern integration; issue 86609 deals with the changed position of the legend after save/reload as .ods.
Seen ok in current master -> closed