Issue 46626 - Excel chart export: Manual position and size of all objects lost
Summary: Excel chart export: Manual position and size of all objects lost
Status: ACCEPTED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-04 15:18 UTC by billen
Modified: 2013-02-24 21:21 UTC (History)
2 users (show)

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

Attachments
Original Calc file, which has some formatted Chart (11.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-04-04 15:18 UTC, billen 		no flags Details
Generated Excel file. Chart hasn't got any formatting (7.50 KB, application/vnd.ms-excel)
2005-04-04 15:21 UTC, billen 		no flags Details
How the original chart looks like (73.70 KB, image/png)
2005-04-04 15:25 UTC, billen 		no flags Details
How the excel chart looks like in m79 (75.71 KB, image/png)
2005-04-04 15:25 UTC, billen 		no flags Details
How the excel chart looks like in Excel 2003 (45.43 KB, image/png)
2005-04-04 15:26 UTC, billen 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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. ***