Apache OpenOffice (AOO) Bugzilla – Issue 13853
Chart: Data table not supported
Last modified: 2013-09-25 20:41:35 UTC
Hello developers, I have been using Staroffice 5.2 for some years now and I am quit happy with it. Sometimes I still have to use MS Office. I have imported an Excel file with some charts in the newest version of OpenOffice (1.0.3) and the result was so bad that I have to write this - hoping this can be improved. The charts look absolutely different from the original and when I try to save as an OpenOffice file the size rises from 205kb to 3,3MB (normaly it's the other ways). I will attach a little part of the original excel file and two screenshots which show more than a lot of words. Greetings J.Witt
Created attachment 5912 [details] This zip file contains a part of the original excel file and 2 gif-screenshots
The difference in appearance comes down to two issues: a. Excel Legend appears at bottom while Calc displays it to the right. Excel allows different placement Legend locations with right as default. b. Excel has the ability to display data table. The default is that this is disabled. Calc does not display the data table. Once these two are changed, then the differences dissappear. The workaround is to simply store the Excel Chart with its default values thereby ensuring consistency. I need to also check if these are part of the new Chart.
ok. I believe I may have a handle on this thanks to Daniel. We know that Calc does not suppport Excel Chart data tables. If this is cleared from the Chart then the Legend will appear in the correct position if it has been auto positioned in one of the 4 supported postions viz left/right/top/bottom. As the data table itself contains a legend, then this overrides the earlier legend details. Thus Calc positions the legend in the default position of 'right'. The simple workaround is to clear the data table in Excel. We have to decide whether to fix this now or wait until we support data tables.
accept issue
Thank you for your reply. I personally would like to see OO supporting data tables. I think it's a nice feature. I also think that people's acceptance for swapping to OO will rise if the ability to import MS documents will improve.
changing this to an enhancement request for support of data tables in Calc Chart.
Hi, I found that this issue is already started but have no target. Please consider to set the target, as it is already started. Thanks
set the target
set the priority.
reset the target
enhanced summary, set keywords and reassigned issue according to RFE process
Hi Dancer, never touch an Issue assigned to a developer. Such Issues are worked on especially if the have the staus started. Frank
reset started
I was hoping that this would be fixed sooner.
Taking over. Remaining issue is the missing data table.
DR->IHA: This issue for implementation of the data table.
accepted
DR->IHA: After fixed, please back to me for additions in the Excel filters.
Are there any plans for data tables in the new chart-implementation?
No.
One of our users uses data tables in Excel charts extremely profusely. These charts are embedded as Excel objects into Word documents, and other users modify the data directly in the Word documents. Opening the Excel file in Calc produces a completely grey rectangle instead of a nice chart with a data table as a legend. Opening the Word document in Writer produces something that looks OK, but when you double-click the chart, Excel opens instead of the default Calc, which won't work on workstations where MS Office isn't installed. We're having a hard time convincing these users that they don't need MS Office. It's been over 5 years since this issue was opened. Any chance of getting some target milestone besides "OOo Later"? Yes, I realize you guys are busy :-)
reset to new
Hi, Any activity on this issue? Thanks.
Tested in OOo 3.1. Issue still occurs.
Any chance of setting a definite Target milestone?
Now issue 107070 is fixed, and it is possible to copy cell range from sheet on chart. So, it might be quite easy to implement data table feature.
*** Issue 116720 has been marked as a duplicate of this issue. ***