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.

-Lars
Lars Nooden ([EMAIL PROTECTED])
        On the Internet, nobody knows you're a dog ...
        ... until you start barking.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to