https://bugs.documentfoundation.org/show_bug.cgi?id=158816
Bug ID: 158816 Summary: Dependence on ~/Documents Product: LibreOffice Version: 7.6.4.1 release Hardware: All OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: gra...@harris.net.nz Description: I have a 'master' spreadsheet which aggregates data from a lot of other spreadsheets in the same directory. When I open this 'master' spreadsheet it errors once per external file referenced: "The following external file could not be loaded. Data linked from this file did not get updated. file://home/graham/Documents/solarview+2023+killigray-elevation-60-azimuth-60W-table_mhr-monthly.ods" Once the 'master' is open there is no apparent missing data. There are no files in /home/graham/Documents/, I almost never use it. All the files referenced are actually in the same directory as the 'master' ie /home/graham/projects/killigray/energy/insolation/ and seem to actually get loaded OK. I search in the 'master' for Documents in All sheets, Documents is not found in either Value or Formulas. So I conclude there is some hard coded dependence on /home/$USER/Documents/ Steps to Reproduce: 1.Open attached spreadsheet. 2.Witness error dialogs 3. Actual Results: Error dialogs as described. This is not resolved by re-saving the file. Expected Results: None of these error dialogs should have been displayed- there are no actual errors affecting the data load. Reproducible: Always User Profile Reset: Yes Additional Info: The subsidiary files to load are identified by formulae which create their filenames (with no path) from hard-coded values in Sheet1 like: ="solarview+2023+killigray-elevation-60-azimuth-"&F3&"-table_mhr-monthly" If I change the formula to ="./solarview+2023+killigray-elevation-60-azimuth-"&F3&"-table_mhr-monthly" then the same errors still occur on loading the master spreadsheet but it actually cannot load the subsidiary spreadheets from the current directory. In Safe mode the 'master' sheet does not load all subsidiary sheets automatically, instead "Security Warning Automatic update of external links has been disabled.". When I click Allow updating the problem as described above is replicated. -- You are receiving this mail because: You are the assignee for the bug.