https://bugs.freedesktop.org/show_bug.cgi?id=72594
raal <r...@post.cz> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Windows (All) |All
Status|UNCONFIRMED |NEW
CC| |r...@post.cz
Summary|File links to range names |File links to range names
|don't work after re-opening |don't work after re-opening
|file |file (unable to create
| |VLOOKUP named range in
| |another file)
Ever confirmed|0 |1
--- Comment #1 from raal <r...@post.cz> ---
I can reproduce only with LO 3.5.
In actual versions of LO - 4.2.6, 4.3.3, 4.4 is broken creating a link to
named ranges:
LO 3.5
=VLOOKUP(A1;'file:///tmp/file1.ods'#xrange;1;0)
formula works
after save and reopen the formula just shows #NAME (even before the update
links dialog is answered). Manually updating the links does nothing. Editing
the cell (this involves actually making a change e.g. deleting the final
bracket and replacing it) makes the formula work again.
LO 4.2.6 , 4.3.3, 4.4 :
=VLOOKUP(A1;'file:///tmp/file1.ods'#xrange;1;0)
after press ENTER the formula is changed to
=VLOOKUP(A1;'file:///tmp/file1.ods'#file:///tmp/file1.ods;1;0)
Tested in Linux.
--
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
