Lars D. Noodén said the following on 2/17/2006 5:17 AM:
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.
Are you saying that using =$A$1 + $A$3 does not work? I just tried
it in version 2.0.1 and it seems to work just fine. Try that and see
what happens.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
