To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103076 Issue #|103076 Summary|ODF, chart from MS-Office2007sp2 doesn't load Component|Spreadsheet Version|OOo 3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|barthanssens
------- Additional comments from barthanss...@openoffice.org Wed Jun 24 18:13:54 +0000 2009 ------- When loading an ODS with a chart created in MS-Office 2007sp2, the chart isn't visible. Instead, "OLE" is displayed. The cause is twofold: A) there is, of course, the difference in the value of the href attribute OOo uses <draw:object xlink:href="./Object 1"...> MSO uses <draw:object xlink:href="Object 1/"...> B) in addition, OpenOffice.org 3.1 seems to expect that the cell range in the chart:plot-area (Object 1/content.xml) is set, otherwise the bars won't show up (see also ODF 1.1 part 10.1) Like this: <chart:plot-area table:cell-range-address="Sheet1.B1:Sheet1.B3" ... <chart:series chart:values-cell-range-address="Sheet1.B1:Sheet1.B3" MS-Office 2007sp2 doesn't set the table:cell-range... on chart:plot-area. According to the ODF spec, this attribute seems to be optional Note that MS-Office 2007sp2 and OOo use a slightly different notation for specifying ranges as well (with or without $), but that doesn't matter in this example. (Of course, OOo will only show the first bar since B2 and B3 contain formulas from the msoxl: namespace and they are currently not supported in OOo) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
