Lars D. Noodén wrote:
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.
What OO does is what is supposed to be. You are moving a cell and the
formula should be updated. If you insert a row between r1 and r2 the
formula should be changed as =A1+A3 because A2 was moved to A3
try:
=a1+INDIRECT("a2")
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
