To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95481 Issue #|95481 Summary|Formula modified during copy & paste Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|enforcer2
------- Additional comments from [EMAIL PROTECTED] Mon Oct 27 05:28:18 +0000 2008 ------- Hello, I don't know if this is intended behaviour, but it is IMHO misleading and confusing. In calc, create a row of numbers in cells A1 .. A10, eg. 1 2 3 4 5 6 7 8 9 Then, create a formula in cell B2 "=A2-A1" and copy this to cells B3..B10. All B cells shoudl equal 1. This is fine. Now, cut numbers 5..9 and paste them one cell lower. This will change the formula in cell B5 to read ="A6-A4". I would maybe have expected this behaviour when doing drag&drop, but not when doing copy&paste. If this is a case of bug-for-bug compatibility with MS Excel (cannot test, don't own Excel), then so be it, but IMHO this is unexpected behaviour. Maybe the user should be prompted whether formulas pointing to the cells which are being moved should be adjusted. Thank you, Jens --------------------------------------------------------------------- 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]
