On Fri, 2006-02-17 at 10:18 -0500, Lars D. Noodén wrote: > Yes. But I am not moving the formula I am moving one of the cells. > So if I have, in cell B1, any of these formulas, > =A1+A2 > or =A$1+A$2 > or =$A$1+$A$2 > > and I move *A2* to A3 using cut and paste, then the formula changes to > =A1+A3 > or =A$1+A$3 > or =$A$1+$A$3
Ah! Sorry, I misunderstood. Yes this is a 'feature' and it is apparently the same in Excel 2000 and Excel 2003 according to the following issue reports: http://qa.openoffice.org/issues/show_bug.cgi?id=29135 http://qa.openoffice.org/issues/show_bug.cgi?id=26929 If you move a cell that formulas refer to then they are changed. > That's fine in most circumstances and good in many of those. However, > there are times when that is a big problem. There are times when I'd > like to keep the formula from changing. > > -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 Sat, 18 Feb 2006, Ross Johnson wrote: > > Are you really saying that =$A$1+$A$2 is being changed when you move it? > > = A1+A2 should always change. > > --------------------------------------------------------------------- > 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]
