Apache OpenOffice (AOO) Bugzilla – Issue 66876
copied chart lost when saved to Excel .xls format
Last modified: 2013-08-07 15:12:27 UTC
To reproduce 1. In Calc, create a simple chart 2. Copy the chart to a new spreadsheet 3. Save the new spreadsheet to Excel .xls format Results: When the Excel spreadsheet is opened, the chart appears to contain no data. Comments: 1. If the new spreadsheet is saved to OpenDocument Spreadsheet .ods, the chart and its data display properly. 2. If the chart is pasted into Writer and saved to Microsoft Word .doc, the chart and its data display prpoperly.
Hi, the copied chart lost it's data reference, copying it into writer creates a Chart OLE object with it's own data container. So activating it in Word would lead in an action to start an OOo. Excel can display charts without link to data if you feed it with comma separated values or so. So this is not a defect but an enhancement. Frank