Bug 154243 - EDITING: copy lookup formula from other file does no longer work
Summary: EDITING: copy lookup formula from other file does no longer work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-External-Datalink
  Show dependency tree / graph
 
Reported: 2023-03-17 14:56 UTC by ron
Modified: 2023-05-15 17:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
A file with a data table (9.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-17 14:56 UTC, ron 		Details
A file with a lookup formula (10.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-17 14:58 UTC, ron 		Details
A file with the copied lookup formula (9.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-17 15:00 UTC, ron 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description ron 2023-03-17 14:56:47 UTC 
Created attachment 186027 [details]
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)
Comment 1 ron 2023-03-17 14:58:08 UTC 
Created attachment 186028 [details]
A file with a lookup formula
Comment 2 ron 2023-03-17 15:00:34 UTC 
Created attachment 186029 [details]
A file with the copied lookup formula

The link text ( 'file:///D:/DATA.ods'#$Blad1.A1:B4 ) is disappeared
Comment 3 Eike Rathke 2023-03-17 16:21:56 UTC 
I think this never worked. Tried with LO 5.3 and same. With old OOo 3.3 the cell range is preserved but without file name, ''#$Blad1.A1:B4
Comment 4 ron 2023-03-20 08:13:13 UTC 
As soon as there is 1 link active, other links can be added by copying without a problem.
Maybe I used to start with a file with an active link.
Comment 5 Eike Rathke 2023-03-27 12:13:31 UTC 
If one formula with a correct external reference was entered already, the external document cache is populated for that external file, which makes a whole lot of difference.