To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100849 Issue #|100849 Summary|Copy & paste to excel spreadsheets fails for graphs wh |en sheet name differs Component|Spreadsheet Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|ecifene
------- Additional comments from ecif...@openoffice.org Sat Apr 4 17:29:15 +0000 2009 ------- 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 --------------------------------------------------------------------- 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
