https://bugs.freedesktop.org/show_bug.cgi?id=72594
Priority: medium Bug ID: 72594 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: File links to range names don't work after re-opening file Severity: normal Classification: Unclassified OS: Windows (All) Reporter: davidmaug...@ced.ltd.uk Hardware: All Status: UNCONFIRMED Version: 4.1.2.3 release Component: Spreadsheet Product: LibreOffice Creating a link to a named range works (e.g. VLOOKUP(a1,'file:///C:/some/path/file1.ods'#rangename,1,0) ) even if file1.ods is not currently open. However after saving the file with the link and re-opening, 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. -- 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