Comment 8 for bug 1388491

Tell me if I should open a separate bug for this, but it looks to me that formulae are changed when you simply do Cut / Paste (recorded in the undo history as Cut / Move) so this is a more serious problem than it may seem on first sight of the title.

I fell foul of this when moving some data around in a simple 'row total' sheet with a protected column of formulae. "Imagine my surprise" when cut / pasting some of the data changed the formulae in unpredictable (by me) ways!

Here's how counter-intuitive it is (no need to protect the formulae for this)

1) create a simple 'row sum' table as follows

1 2 =A1+B1
3 4 =A2+B2

2) This displays as expected:

1 2 3
3 4 7

3) Select cells A2 and B2 and cut, gives what you'd expect:

1 2 3
      0

4) Click on A1 and paste

3 4 7
      7

And C2 now has =A1+A2 - NOT what I expected!

I guess this sort of spreadsheet is fairly common and it really had me confused. I can only move my input values around using select, copy, paste, select, delete instead of the obvious select, cut, paste.

This seems to be a problem arising from assuming that every cut and paste is a move whereas it is often, and more obviously, just a cut and paste! Surely to get a move you should ask for it via Paste Special?

Note that exactly the same table in Writer gives the expected result:

3 4 7
      0

and leaves the formula in B3 alone.