Issue 30851 - Excel chart import: Manual position and size of all objects lost
Summary: Excel chart import: Manual position and size of all objects lost
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: oooqa
: 71719 72976 (view as issue list)
Depends on: 47745
  Show dependency tree
Reported: 2004-06-29 02:39 UTC by lc3
Modified: 2013-02-24 21:18 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

The Offending Excel Document (13.50 KB, application/
2004-06-29 02:41 UTC, lc3
no flags Details
The chart after importing to OOo (10.22 KB, application/vnd.sun.xml.calc)
2004-07-02 18:13 UTC, lc3
no flags Details
After MANUAL adjusting within OOo (see comment) (10.15 KB, application/vnd.sun.xml.calc)
2004-07-02 18:14 UTC, lc3
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description lc3 2004-06-29 02:39:03 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...
Comment 1 lc3 2004-06-29 02:41:06 UTC
Created attachment 16175 [details]
The Offending Excel Document
Comment 2 lc3 2004-06-29 02:42:44 UTC
1. Open it in Excel
2. Remember what it should look like
3. Open it in OOo
4. Compair
Comment 3 kla 2004-07-02 13:14:34 UTC
Hm, i see. But I think both are an enhancement and not a defect. 

kla->lc3: You agree?

kla->BH: its for you
Comment 4 lc3 2004-07-02 18:09:28 UTC
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

Do you see what I mean now?
Comment 5 lc3 2004-07-02 18:13:43 UTC
Created attachment 16243 [details]
The chart after importing to OOo
Comment 6 lc3 2004-07-02 18:14:20 UTC
Created attachment 16244 [details]
After MANUAL adjusting within OOo (see comment)
Comment 7 lc3 2004-07-02 18:17:30 UTC
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.)
Comment 8 bettina.haberer 2004-11-29 18:21:28 UTC
Reassigned to Ingrid.
Comment 9 IngridvdM 2005-04-19 10:26:20 UTC
->Daniel: This looks like a defect in the import filter. Please have a look. Thanks.
Comment 10 daniel.rentz 2005-04-19 15:05:34 UTC
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
Comment 11 IngridvdM 2006-11-23 12:32:43 UTC
*** Issue 71719 has been marked as a duplicate of this issue. ***
Comment 12 IngridvdM 2007-01-05 12:04:51 UTC
*** Issue 72976 has been marked as a duplicate of this issue. ***
Comment 13 2007-05-26 12:56:35 UTC
I confirm this problem with OOo 2.3 m213
Comment 14 daniel.rentz 2010-05-20 15:46:18 UTC
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.
Comment 15 daniel.rentz 2010-05-20 15:46:47 UTC
back to QA
Comment 16 kla 2010-05-28 10:23:30 UTC
Seen ok in cws chartpositioning -> verified
Comment 17 kla 2011-03-28 08:31:32 UTC
Seen ok into the master -> closed