https://bugs.documentfoundation.org/show_bug.cgi?id=154243
Bug ID: 154243
Summary: EDITING: copy lookup formula from other file does no
longer work
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 186027
--> https://bugs.documentfoundation.org/attachment.cgi?id=186027&action=edit
A file with a data table
I used to make extensive calculations by copying small spreadsheet files into a
new one.
These small files may contain lookup formulas to other files.
In version 7.5.1.2 this no longer works (To be honest it also didn't work in
earlier versions, but I don't know from which version.)
When this lookup formula is copied to a new file, the link to the data file
disappears.
Original formula in file Lookup.ods:
=VLOOKUP(A2;'file:///D:/DATA.ods'#$Blad1.A1:B4;2)
Copied file in Geen titel 1.ods: =VLOOKUP(A2;;2)
--
You are receiving this mail because:
You are the assignee for the bug.
