Issue 46626

Summary: Excel chart export: Manual position and size of all objects lost
Product: General Reporter: billen <openoffice>
Component: chartAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, tony.galmiche.ooo
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Original Calc file, which has some formatted Chart
none
Generated Excel file. Chart hasn't got any formatting
none
How the original chart looks like
none
How the excel chart looks like in m79
none
How the excel chart looks like in Excel 2003 none

Description billen 2005-04-04 15:18:04 UTC 
When I create a chart in Calc and export it as Excel (97/200/XP) the formatting
of it is lost. That includes:

* Any resizing or repositioning of objects inside the Chart.
* The Subtitle isn't included at all.

I have tested the XLS file in Excel 2003, but it guess that it want work in any
Excel version. When I test the generated XLS file in m79, then it also without
any formatting. I guess it is the export of the XLS file, that something goes wrong.

See attached files/screenshots.
Comment 1 billen 2005-04-04 15:18:56 UTC 
Created attachment 24618 [details]
Original Calc file, which has some formatted Chart
Comment 2 billen 2005-04-04 15:21:07 UTC 
Created attachment 24620 [details]
Generated Excel file. Chart hasn't got any formatting
Comment 3 billen 2005-04-04 15:25:13 UTC 
Created attachment 24621 [details]
How the original chart looks like
Comment 4 billen 2005-04-04 15:25:45 UTC 
Created attachment 24622 [details]
How the excel chart looks like in m79
Comment 5 billen 2005-04-04 15:26:10 UTC 
Created attachment 24623 [details]
How the excel chart looks like in Excel 2003
Comment 6 billen 2005-04-05 08:24:31 UTC 
I have just confirmed that the issue exists in 1.1.4 also.
Comment 7 kla 2005-04-08 10:55:21 UTC 
.
Comment 8 IngridvdM 2005-04-18 17:25:15 UTC 
iha->dr: To you as this looks like a bug in the export.
Comment 9 daniel.rentz 2005-04-19 09:21:53 UTC 
Not a bug, but simply not implemented, due to various problems with object
positioning in Excel charts (this stuff is not documented).

Started.

To do: Position/size of
- Chart titles, axis titles
- Diagram area
- Legend
- Data point labels

Excel charts do not have a subtitle. This object cannot be exported to Excel.
Comment 10 kla 2009-09-24 09:34:42 UTC 
*** Issue 105315 has been marked as a duplicate of this issue. ***