Re: [libreoffice-users] Having issue with External links in calc.

On 4 Dec 2025 at 19:30, Regina Henschel wrote:

Subject:                Re: [libreoffice-users] Having issue with 
External links in calc.
To:                     users@global.libreoffice.org
From:                   Regina Henschel 
<rb.henschel@t-online.de>
Date sent:              Thu, 4 Dec 2025 19:30:00 +0100

> Hi Michael,
>
> Michael D. Setzer II schrieb am 04.12.2025 um 18:54:
> > Have a spreadsheet that has external links to two csv files
>
> Operating system?
>
> Do you see the links in menu Edit > Links to external files... ?
>
>   and it
> > has worked for many years. But just opened it, since the main data
> > file is only updated every 3 months, and noticed it was not linking
> > to the new data?
>
> No longer linked or do not update automatically?

Did some more testing.
Fedora 42
Version: 25.2.7.2 (X86_64)
Build ID: 520(Build:2)
CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
Calc: threaded

Here is what I had happen before.

Would open the streadsheet with this
libreoffice staffingCampusA.ods
It would then link to CONTACTD/moredir.csv and morestaff.csv

Now it doesn't updated info. Tried adding 1000 to the first field of 
both files before opening, but after opening it still shows same data.
Used Edit External Links and it shows status as unavailable?
Click on update for both links, and data remains the same.
Try breaking links and recreating links, and redoing update, and 
again no changes. Then break links, and save spreadsheet.
Reopen, and redo the links again, and it works just fine?? Data is 
then updated. But try again, and no updates?

My other option that does work, is open the 3 files together, and 
then manually copy the cell from the two cvs files to the correct 
locations.

libreoffice --infilter=CSV:44,34,76,1,,,,true morestaff.csv 
CONTACTD/moredir.csv staffingCampusA.ods

The staffing pattern file is only updated ever 3 months, and the 
moredir.csv comes from Campus Directory, that has changes much 
more often.

Even tried touching the files before opening spreadsheet thinking it 
might be seeing the speadsheet as being newer than files, but made 
no difference.

So for moment, have modified the script to option the 3 files, and 
do a manual copy since external link is showing Not available, 
while files are exactly there, and then clicking on update changes 
that to Manual, but it isn't updated?? 

Thanks for reply.

 
> Kind regards,
> Regina
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor 
(Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 mailto:msetzerii@gmx.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy