Apache OpenOffice (AOO) Bugzilla – Issue 30851
Excel chart import: Manual position and size of all objects lost
Last modified: 2013-02-24 21:18:35 UTC
I have an MS Excel document, which when loaded in OOo 1.1.2 or OOo 680m41 doesn't look right. Two problems: 1. I changed the Plot Area "Area" to "None" in excel, it becomes grey in OOo, i must select "Chart Wall" and change "Fill" to "None" to make it look right. 2. I moved the axis labels and resized the chart itself, in OOo this goes back, i must use the mouse to arrange the axis labels the way I want in OOo to fix it. Will attach the Excel document...
Created attachment 16175 [details] The Offending Excel Document
1. Open it in Excel 2. Remember what it should look like 3. Open it in OOo 4. Compair
Hm, i see. But I think both are an enhancement and not a defect. kla->lc3: You agree? kla->BH: its for you
lc3->kla: I disagree, because OOo DOES have the features to make this chart look correct, it misinturperates the microsoft chart, If OOo lacked the features to eliminate the fill and allow the user to arrage the axis lables, it would be enhancement. Do you see what I mean now?
Created attachment 16243 [details] The chart after importing to OOo
Created attachment 16244 [details] After MANUAL adjusting within OOo (see comment)
I've attched a document to show that with manual adjustments in OOo you can make it look as it should. (Optional Sidenote: I changed it ot "white" not "none" in that document because i decided it looked nicer against the grid in the bg of OOo but thats irrelivant, last minute decicion. It should proably be "None" since this was what was selected in Excel.)
Reassigned to Ingrid.
->Daniel: This looks like a defect in the import filter. Please have a look. Thanks.
Wrong background format -> issue 47745 Manual position and size of chart objects is not imported currently due to various problems with the undocumented file format. -> Started
*** Issue 71719 has been marked as a duplicate of this issue. ***
*** Issue 72976 has been marked as a duplicate of this issue. ***
I confirm this problem with OOo 2.3 m213
Positioning of axis titles is now correct. However, the chart will still be imported as embedded object in a regular spreadsheet, and not as chart-sheet, which is currently an Excel-only feature. See issue 5736 for details.
back to QA
Seen ok in cws chartpositioning -> verified
Seen ok into the master -> closed