I have a few Libreoffice OpenDocument spreadsheets which all retrieve the latest share prices and forex rates from some CSV files in another folder using vlookups. These CSV files are updated by a script which I run before I open the spreadsheets:
=VLOOKUP("USDAUD=X",'file:///home/username/Documents/Share Research/Data/Forex Data Downloaded Data.csv'#$Sheet1.$A$1:$B$15, 2,0)
When I open the spreadsheets LibreOffice always prompts with “This file contains links to other files.
Should they be updated?”, which I always click yes to.
This works fine about 8 out of 10 times. But sometimes I open the spreadsheets to find that, seemingly at random, some of the vlookup cells have lost the file path to the CSV files and instead look like this
I haven’t moved or deleted any of the files involved in this at any time. Does anyone have any suggestions how to avoid this problem? Or if there’s a fix in a future version?
libreoffice-calc 4.2.7-0ubuntu2 on Ubuntu 14.04