https://bugs.freedesktop.org/show_bug.cgi?id=55169
--- Comment #4 from Ken <ken17...@gmail.com> --- I am not moving anything. I define the name in the Name dialog. I then define the link on another sheet to that name. The links work until the file is saved and reloaded. The some of them are garbage. On 9/30/2012 5:53 PM, bugzilla-dae...@freedesktop.org wrote: > > *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=55169#c3> > on bug 55169 <https://bugs.freedesktop.org/show_bug.cgi?id=55169> from > Markus Mohrhard <mailto: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 reported the bug. > -- 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