https://bugs.freedesktop.org/show_bug.cgi?id=55169
--- Comment #6 from Ken <[email protected]> --- Insert->Names->Define. Fill in a name and a range. Example $Funds.$A#:E# Do this for a number of regions on the Funds sheet. They are always A#:E# Or trying to fix some definitions. Insert->Names->Manage Select a definition and retype the range to the proper values. This part On the other sheet. Select a cell A# with a right click and dismiss menu popup. This is because the cell may already have a link that I do not want to take. Insert->Hyperlink. In the dialog Target field type a name previously defined. In the Text field type the name again. Apply and Close. Do this in the column for each of the names defined. The links work fine. I did not check if inserting a line in one of the defined ranges adjusts properly. It should since there are no $ in front of the numbers. But there is no correlation with the outlandish results gotten from a save and reload. I am not sure but I think auto save also scrambles some of the name definitions. The names closer to the top of sheet seem less likely to be affected. Usually the first one is correct and the farther down the Funds sheet the worse the result. On 9/30/2012 6:23 PM, [email protected] wrote: > > *Comment # 5 <https://bugs.freedesktop.org/show_bug.cgi?id=55169#c5> > on bug 55169 <https://bugs.freedesktop.org/show_bug.cgi?id=55169> from > Markus Mohrhard <mailto:[email protected]> * > Can you please describe in all details what you are doing. Including which > cell > is selected when you are defining the range names and in which cell you are > using the range name. > The more details you add to your description the more likely it is that I can > reproduce it and fix it if it is a bug. > ------------------------------------------------------------------------ > 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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
