To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108147 Issue #|108147 Summary|Formulas Break when a Sheet is moved/copied to another | file Component|Spreadsheet Version|OOO310m19 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|kwanbis
------- Additional comments from kwan...@openoffice.org Fri Jan 8 05:16:37 +0000 2010 ------- When I use the Move/Copy command to move/copy a sheet from one spreadsheet to another, the references on the target spreadsheet are not updated with the new location, resulting in the formulas that refer to that sheet returning a #REF! errors. For example, a parent spreadsheet has sheets A & B. Sheet A contains formulas, that lookup info contained in sheet B. If I move/copy sheet A to another file, the formulas in the NEW sheet A are returning #REF as the formula result. Inspection of the formula shows that the sheet reference that used to be there referring to sheet B, is no longer there and has been replaced by #REF! wherever the name of sheet B previously appeared in the formula. Normally when you perform the above described action, the formulas in sheet A are updated with the new location of sheet B so that all the formulas that referred to sheet B still do (in its new location) and the formulas still work. Steps to repeat. 1) Open a new spreadsheet. 2) In the first cell of the second sheet (Sheet2.A1), enter the value 100 3) In the first cell of the first sheet (Sheet1.A1), enter the formula =Sheet2.A1 Now, Sheet1.A1 should have the value 100. 4) Right click over Sheet1 tab in the lower left corner of the window. 5) Select "Move/Copy Sheet..." 6) The "Move/Copy Sheet" dialog box would open. 7) In the "To Document" field, select new document. 8) Check the copy checkbox, and press OK. A new spreadsheet would be created, with =#REF!.A1 as the value, instead something like ='file:///home/user/Documents/original.xls'#$'sheet name'.H21. --------------------------------------------------------------------- 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
