To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43050 Issue #:|43050 Summary:|moving a cell should break formulas linked to the old |value Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|ttissino
------- Additional comments from [EMAIL PROTECTED] Fri Feb 18 01:42:13 -0800 2005 ------- Say we have these formulas in a sheet: A1: 1 A2: 2 A3: (empty) A4: 4 B1: =A1*2 B2: =A2*2 B3: =A3*2 B4: =A4*2 B5: =SUM(B1:B4) If I drag cell A2 to cell A3, the formula in B2 became =A3*2, but the formula in B3 still contains =A3*2, so the cell A3 will be counted twice. On Excel, the same operation causes the formula in B3 to be set to =#RIF!*2. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
