Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Excel chart export: Manual position and size of all objects lost|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Version:||3.3.0 or older (OOo)|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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.