https://bugs.freedesktop.org/show_bug.cgi?id=72594
Priority: medium
Bug ID: 72594
Assignee: [email protected]
Summary: File links to range names don't work after re-opening
file
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs