To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102558 Issue #|102558 Summary|Formula with cells arguments do not update when copyin |g and paste insert Component|Spreadsheet Version|OOO310m11 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|walidz
------- Additional comments from wal...@openoffice.org Sat Jun 6 09:36:54 +0000 2009 ------- This is a very critical bug that may make calc unreliable. When “copying” and “paste insert” ranges that are related to a range beneath them , the formulas of these new inserted cells do not update themselves to the newly shifted cells Microsoft Excel does not have this problem at all !!! 1- Open the attached file I uploaded with this issue, 2- select Entire Row 8 , then Copy 3- Select Row 6 4- Go to Paste Special , 5- from the “Shift Cells” Select “Down” and press OK 6- now examine the vlookup formula arguments , they are not updated to the new shifted rows down. (other rows are updated correctly) I tested it on Ms excel ,the result is perfectly correct ! --------------------------------------------------------------------- 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