To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95757 Issue #|95757 Summary|Edit | Paste Special... --> Preserve formula rather th |an modifying formula Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|wilberw
------- Additional comments from [EMAIL PROTECTED] Sun Nov 2 08:34:26 +0000 2008 ------- The default behaviour when pasting a formula is to modify it, for example: Type into cell A1: 10 Copy(Ctrl+c) cell A1. Select cells B1:B10 then Paste(Ctrl+v). ^^ This works as expected(pasting values) Type into C1: =A1/2 press Enter. Copy(Ctrl+c) cell C1. Select cells C2:C10 then Paste(Ctrl+v). It can be seen that the formula that has been pasted has been modified. Cell C2 has the formula =A2/2 instead of =A1/2 and this behaviour is repeated all the way down to cell C10 which has the formula =A10/2 instead of =A1/2. My enhacement suggestion is to add a tickable checkbox in "Paste Special" which would say "Preserve Formula". By default it would be unticked. Its behaviour would be to paste the formula untouched i.e. in cells C2:C10 the formula that would be pasted into them would be =A1/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]
