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: [email protected]
Reporter: [email protected]
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.
