Thanks. I'm aware of those work around and should have mentioned them in
the original message. I'd still need a way, either simple or complex, to
get it to work with ctrl-X (cut).
There should be a way to protect the cell or something to be able to
cut-n-paste the contents from a cell in a formula, to a cell outside of a
formula. e.g. ^X ^V cell A2 to cell A3 and leave the formula =A1+A2
unchanged and not =A1+A3 as is currently the case.
-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.
On Fri, 17 Feb 2006, Johnny Andersson wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
