Summary: | EDITING: copy lookup formula from other file does no longer work | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | ron |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | buzea.bogdan, erack, ron |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 112071 | ||
Attachments: |
A file with a data table
A file with a lookup formula A file with the copied lookup formula |
Created attachment 186028 [details]
A file with a lookup formula
Created attachment 186029 [details]
A file with the copied lookup formula
The link text ( 'file:///D:/DATA.ods'#$Blad1.A1:B4 ) is disappeared
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 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. 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. |
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)