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]
