Here are the steps to reproduce: 1. Create a new document. 2. Write in cell A1 "1". 3. Write in cell A2 "2". 4. Write in cell B2 "=SUMME(A$1:A2)" (or dependent on whatever your localization is. It seems I can't mix SUMME from german with SUM from english) and press enter. 5. Select A1 and B1. Now the differences: Copy the selection, select A4 and paste the content. A4 will now contain "=SUMME(A$1:A4)" as I would expect it. But if you cut the selection instead of copying, selecting A4 and pasting the content A4 will contain "=SUMME(A$1:A2)". Normally I would expect that the formula would be "=SUMME(A$1:A2)" too.
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 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.
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.
I'll set it to enhancement request.
> when you cut and paste A2:B2 to B3:C3, the reference remains unchanged. So if I'm understanding all your post correctly if you would copy this in Excel the reference would then change?