On Fri, 2006-02-17 at 09:34 -0500, Lars D. Noodén wrote: > 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.
Are you really saying that =$A$1+$A$2 is being changed when you move it? = A1+A2 should always change. > -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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]