https://bugs.freedesktop.org/show_bug.cgi?id=55169
--- Comment #3 from Markus Mohrhard <markus.mohrh...@googlemail.com> --- You know that you are using relative references? So they are expected to change if you are not in the same cell. That is why I asked for the base cell. The base cell of a range name is the cursor cell when you define the range name. When you now move the cursor and reopen the manage names dialog the shown formula/range will change. If you don't want relative references prefix each part of the formula with a $. So the absolute reference version of your first range looks like: $Sheet2.$A$20:$G$30. -- 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