Created attachment 166836 [details] Example file from Excel with external links to CSV, XLSX Attached Excel-made file contains external data connections to a CSV an an XLSX file. When opened in Calc the Edit – Link to External Files menu item is greyed out, meaning the data connections are not imported at all. Steps to reproduce: 1. Open attached file Actual results: Edit – Link to External Files menu item is greyed out. Expected results: Edit – Link to External Files menu item is working, data connections are editable. LibreOffice details: Version: 7.1.0.0.alpha1+ (x64) Build ID: f27c4ec5c864395f4cdaec32d7e95ff24e4f43c8 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Created attachment 166837 [details] Screenshot of the original document in Excel
Created attachment 166838 [details] Data source file linked from the example
Created attachment 166839 [details] Data source file linked from the example I used the path c:\TEMP for these linked files when I set the connections up in Excel.
Created attachment 166842 [details] Example file saved as XLS Saving to XLS does not work either, Excel does not see external connections in this one either.
Confirmed NixOS Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 67e47070a7580a17804adce812cc2f98bfe7b51f CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: x11 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded
Repro, Edit – Link to External Files menu item is always greyed out. Version: 7.4.0.0.alpha1+ (x64) / LibreOffice Community Build ID: c94961c6869c34b3874d21cfaa5ec1488609acfe CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL Version: 7.5.0.1.0+ (X86_64) / LibreOffice Community Build ID: ced8585bcb92aa58ca3e24197ff38fb82cc8a703 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL threaded Version: 7.6.0.0.beta1+ (X86_64) / LibreOffice Community Build ID: 1b5cee822e0bc15ddbdfc86926678ca35ab3e082 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL threaded