To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105479 Issue #|105479 Summary|value calculated twice after a Cut & Paste operation Component|Spreadsheet Version|OOO310m19 Platform|HP URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|aldogiga
------- Additional comments from aldog...@openoffice.org Wed Sep 30 11:16:21 +0000 2009 ------- When you cut some data that are referenced in a formula in another cell and you paste in a different position which also affects a formula the values in both the referencing cells are affected by the moved value. In the attached examples I moved the cell B4 that affects the value of cell C4 (see Total sum - 1.ods) to the new position in cell B7 that affects the value of cell C7. After the cut operation the cel C5 has the modified value (see Total sum - 2.ods). After the paste operation the cell C5 returns to its previous value (Excel behave the same way but I consider that an error) but also the cell C7 change its value making the total result a mistake. --------------------------------------------------------------------- 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