On Sat, 18 Feb 2006, Manuel wrote:
What OO does is what is supposed to be. You are moving a cell and the formula
should be updated. If you insert a row between r1 and r2 the formula should
be changed as =A1+A3 because A2 was moved to A3
I'm talking about moving *values* from one cell to another not the actual
cell. That's where the problem is. In the context of a form (e.g. a tax
form) a user can be thinking they're moving a value, but they're really
moving the whole cell, plus the value that happened to be in that cell at
the time.
try:
=a1+INDIRECT("a2")
Thanks!! That works. It complicates the formulas, but is a work around
that gives the behavior I need.
Still, in the long run, I'd like to see a feature added to let ^X only
glom onto the cell's value and not the cell itself.
-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]
