https://bugs.freedesktop.org/show_bug.cgi?id=68976
--- Comment #5 from peterthevicar <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
