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

Reply via email to