> I just tried it with copy and paste instead of cut and paste. Result as > expected. I just wonder why we get the result you describe, when cutting > and pasting. Strange.
Well, the example hid the reason a little, and I've almost satisfied myself that this is actually how I would want it to work in normal use. It's probably simple and obvious, and I've just complicated it and have spread confusion. If you move a single formula, 99.99% of the time you do want it to move unchanged, because the referenced cells have not moved. But when you paste the cut cell into a range, you are probably creating a sequence or an array: E.g. A1 =1 A2 =A1+1 Cut A2 Paste to A3 to A5 A3 =A1+1 A4 =A3+1 A5 =A4+1 I think this is usually what one would be intending to do. Although it may still seem a little odd, because you would normally enter a formula into A2 and then cut or copy A2 and paste to a cell range with A2 as the first cell again. You wouldn't normally move it at the same time. But then, if you do move it you want everything to work correctly. The way it is now works both ways. I suspect it's one of those 'majority' case decisions where it's always possible to find an [possibly absurd] exception where it's inconvenient or leads to errors. I couldn't find an existing issue on it in issue- zilla, except the one I reported just yesterday, and retracted today :/ > Den 2006-02-17 15:50:57 skrev Ross Johnson <[EMAIL PROTECTED]>: > > > On Fri, 2006-02-17 at 15:16 +0100, 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. > > > > That's weird - only the first paste after the cut reproduces the formula > > without change. If you paste it two or more times, those extra pasted > > copies are changed. This looks like it's meant to be a feature, but if > > you cut a cell and then paste into a new range you get a discontinuous > > set of changed formulas where the first is the same as the original but > > the second etc are changed according to the rules relative to the > > original cell location where the cut was made, not the first cell. I > > think this is a bug. > > > > That is, if B1 = A1+A2. Cut B1. Paste into range B2 to B5. I get > > > > B2 = A1+A2 > > B3 = A3+A4 > > B4 = A4+A5 > > B5 = A5+A6 > > > > That's not what I would expect. > > > >> 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] > >> > >> > > > > > > > > -- > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.1.375 / Virus Database: 267.15.10/263 - Release Date: > > 2006-02-16 > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
