Issue 62217

Summary: Moving cells in and out of formula references, yet leaving the formula unchanged
Product: Calc Reporter: lars.nooden
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, lars_o_hansen
Version: OOo 2.0.1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description lars.nooden 2006-02-17 14:57:14 UTC
I'd like to stop formula references from changing so that a normal cut-n-paste
action of cells containing values for the will leave the formula unchanged. 
That was a poor description.  Here's an example to clarify:

If I have a formula, =A1+A2, and I cut-n-paste A2 to A3, the formula
automagically becomes =A1+A3.  That action normal, as the help says, "Formulas,
however, are always adjusted accordingly."  And most of the time it is very,
very helpful.  However, in some cases it gets in the way and it would be
necessary to leave the formula unchanged.  

The result I would to have is a way to protect the formula so that if I the same
formula, =A1+A2, and I cut-n-paste A2 to A3, the formula stays =A1+A2 rather
than changing to =A1+A3.

The option to protect the formula would be useful in many contexts, one of which
is having forms with occasional manual actions at certain points of the workflow.
Comment 1 lars 2006-02-17 20:01:25 UTC
according to http://qa.openoffice.org/issue_handling/workflowcharts/
RFE_issues_by_QA.sxd I reassign this issue to requirements and set the status 
to New
Comment 2 clement_pillias 2008-03-05 22:57:06 UTC
Copying instead of cutting seems to do what you want (you may also want to
delete A2). And it would be faster than setting an option, cut-n-paste and then
clear the option. Except in rare cases involving multiple displacement of cells,
I am not sure that it is really helpful to add another option (in fact, it is a
mode).