https://bugs.freedesktop.org/show_bug.cgi?id=71058
--- Comment #8 from Ady <ady...@hotmail.com> --- (In reply to comment #5) > Hi Ady, > > I think that as well "Copy"/"Paste" as "Cut"/"Paste" behave well and as > expected in LibreOffice. MS Excel does not behave differently. Perhaps I wasn't clear enough. IMO, "Cut+Paste" is _not_ behaving "well" in Calc (just as bug #68976 describes too), and I think Excel (and others) indeed behaves differently. For example, you could perform one "Cut" task, and no "Paste" anywhere, just save the file and close it. The "Dependents" would have no clear and definitive formula for such case. In other words, a "Move Cell" action (a.k.a. "Select a cell and drag it to a different position") should not be the same as "Cut+Paste". When I *move* a cell, all "Dependents" of that cell keep track of it, thus correcting their respective formulas. That's not the same as "Cut+Paste" (at least, not in other spreadsheet tools). And since other spreadsheet tools (including popular ones) don't track such "Cut+Paste"-ed cells (their prior dependents keep their prior formulas intact), IMHO Calc should do the same. Hence, if there is a bug to be considered, then it is in the "Cut+Paste" action behaving as a "Move" (e.i. drag cell or range of cell) action. This corresponds to the initial description of bug #68976, "Formulas change after cut and paste action". I haven't tested each and all possible "Cut+PasteSpecial" possibilities, but generally speaking I would say that "Cut+Paste" in Calc should behave more as "Cut+PasteSpecial" in Calc (as in other spreadsheet tools), not the other way around. Perhaps there is an issue regarding “Transpose” too, but, as I said, I haven't specifically tested all “PasteSpecial” options before posting here. Regards, Ady. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs