[Libreoffice-bugs] [Bug 75904] Different behavior of formulas if copied or cutted
https://bugs.freedesktop.org/show_bug.cgi?id=75904 A (Andy) stgohi-lob...@yahoo.de changed: What|Removed |Added OS|Linux (All) |All Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #1 from A (Andy) stgohi-lob...@yahoo.de --- reproducible with LO 4.2.1.1 (Win 8.1) In the bug report seems to be a small typing error: Step 5: Select A1 and B1 - Select A2 and B2 -- 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
[Libreoffice-bugs] [Bug 75904] Different behavior of formulas if copied or cutted
https://bugs.freedesktop.org/show_bug.cgi?id=75904 --- Comment #2 from sworddrag...@aol.com --- You are right with the typo and there is even another typo: 'Normally I would expect that the formula would be =SUMME(A$1:A2) too.' - 'Normally I would expect that the formula would be =SUMME(A$1:A4) too.'. But it seems I can't edit my post. -- 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
[Libreoffice-bugs] [Bug 75904] Different behavior of formulas if copied or cutted
https://bugs.freedesktop.org/show_bug.cgi?id=75904 --- Comment #3 from Kohei Yoshida libreoff...@kohei.us --- Yes, this is intentional. The way Calc updates references during copy-n-pasting and cut-n-pasting are different. This is not a bug. If you check the previous versions of Calc it's always behaved this way. Having said that, I just checked Excel's behavior. Excel behaves identically to Calc *except* when the original range and the pasted range are both in the same columns Excel behaves the way the reporter describes. Very interesting. For example, in this scenario, in Excel, when you cut and paste A2:B2 to A4:B4, the reference becomes A$1:A4, however, when you cut and paste A2:B2 to B3:C3, the reference remains unchanged. Is this difference critical though? That's the question. -- 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