https://bugs.freedesktop.org/show_bug.cgi?id=44383
--- Comment #10 from Eike Rathke <[email protected]> --- > 7. expected behaviour: at least one of the pasted cells (C1:C2) should still > have the same result as in the cells (A3:A4) which contain sthe same > formulas as in (A1:A2). No. When copy&pasting formulas references are never adapted and relative references always point to the same relative offset as the original, which here for A1 (=D1) is 3 columns to the right, maintained after pasting into C1 (=F1), and absolute references don't change at all (A2:=$D2 stays C2:=$D2). This is the same for normal copy&paste without shifting cells. What happens internally is that the cells are shifted before the content is pasted (which is logical because otherwise to be pasted content could overwrite to be shifted content before that is shifted). It seems regarding reference handling you expect: a) when shifting cells the references are updated in the clipboard as if they were already inserted in the sheet, with all so far usual reference updating, which means after paste the result will be C1:=G1 and C2:=$E2 Another but illogical handling would be b) references are treated as if the content was pasted before the cells are shifted, but if that was done then the shift would include the already pasted cells and they would end up in column D instead of column C; I don't think this was meant. For a) we'd need a different implementation of clipboard and reference update handling for the copy&paste+shift case. -- 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
