Like you said, cut and paste (ctrl+x - highlight another cell - ctrl+v)
changes the formula in, let's say B1 if B1=A1+A2. I also tried to move the
cell (a2 in this case) with the mouse. Same result.
However, try this: Highlight A2 - ctrl+c - backspace - highlight another
cell - ctrl+v.
So just press ctrl+c backspace instead of ctrl+x.
Or, if you prefer working with the mouse: Instead of Cut, click copy and
then delete (or erase or whatever, I use Swedish version so I am not sure
about exactly what it says).
Johnny
Den 2006-02-17 13:28:00 skrev Lars D. Noodén <[EMAIL PROTECTED]>:
If I have a formula (say, =A1+A2) in Calc, and cut-n-paste one of the
cells to a new location (say, cut from A2 and paste into A3) , the
formula changes (and would now be =A1+A3).
How do I stop that for specific formulas so that a normal cut-n-paste
action will leave the formula unchanged?
I've tried absolute references, but that doesn't help in this case, nor
does turning on cell protection for the cells containing the formula.
Normally this effect is a very helpful feature, but right now not in
this particular instance.
-Lars
Lars Nooden ([EMAIL PROTECTED])
Software patents endanger the legal certainty of software.
Keep them out of the EU by writing your MEP, keep the market open.
---------------------------------------------------------------------
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]
