Apache OpenOffice (AOO) Bugzilla – Issue 100849
Copy & paste to excel spreadsheets fails for graphs when sheet name differs
Last modified: 2015-08-03 16:17:27 UTC
Steps to reproduce: Create a new spreadsheet Add some values eg: 1 | 2 2 | 4 3 | 6 Generate a Graph from those points Rename the sheet as 'Foo' Save Create a new spreadsheet Paste the whole contents of the first spreadsheet to the second. Save as an Excel 95 or Excel 5.0 file Close Reopen Now, the Graph is gone! (yes, it was correctly pasted) So we copy the graph from the original document. It may be seen as correctly pasted. Now, double-click it. All points disappear! (graph gets blank) Expected: The graph should have been preserved. Note: If saving version is Excel 97/2000/XP, the graph doesn't disappear, it 'just' appears blank on reopen. Workaround: Rename the sheet to 'Foo' before pasting the graph. That makes the pasted graph to be linked with the source data. Then the sheet name can be restored without problems. I understand why it is interesting to keeping the sheet name, but if a graph if pasted referring to sheet Foo and there's no sheet Foo on current book, there should be at least a message asking if I want to change the references to Foo to current sheet. Also note that viewing the data range for the 'blank grapth' show the textboxes empty (instead of showing it's trying to link with Foo). Verified with OpenOffice.org 3.0.0 and OpenOffice.org 3.0.1
I reproduced it with OOo3.1RC1. You need not to rename or copy anything. Create a simple xy-chart and save the document to Excel 95 or to Excel 5.0 format. Open the file in Excel and you notice, there is no chart. But Excel 95 and Excel 5.0 are very old formats and this behavior has been already in SO7. So I guess this is a "wontfix"-issue. Other filters are more important. I haven't got an Excel 5.0 or Excel 95, but if I create such a chart with Excel 2007 and save it in Excel 5.0 or Excel 95, then the chart is not lost. Therefore I guess, that those old versions are able to hold charts.
Then perhaps they're separated issues. I found about the Excel 5.0 problem when trying to reproduce the "Can't copy the graph" bug, and assumed it was the same underlying problem.