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)
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.
Dear ron, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
The bug is stiil present in: Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: nl-NL Calc: threaded
Workaround: Paste the formula using the item "LibreOffice Spreadsheet" from the paste drop-down list. See also bug 143225 and bug 131633.
(In reply to Regina Henschel from comment #8) > Workaround: Paste the formula using the item "LibreOffice Spreadsheet" from > the paste drop-down list. > Forget it. Does not work.