Hi Lars,
Try using 'Paste special' and check only strings, numbers and dates.
tc
Lars D. Noodén wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
