Description: Libre Calc refuses a Link to External Data Steps to Reproduce: 1. New Calc 2. Sheet -> Link to External Data... 3. Fill the url field with e.g.: https://wiki.documentfoundation.org/Language_Teams 4. Hit Enter Actual Results: Nothing happens Expected Results: Calc should load the webpage for a while, then a dialog pops up to ask you for import options, then available tables/ranges appear in the box. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 7.1.2.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 12; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: CL A clean reinstall and a remove of the user profile doesn't change anything When using an old .ods file with a link, the updating fails with: The link could not be updated.
Works on windows Version: 7.1.2.2 (x64) / LibreOffice Community Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4 CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded
I can't reproduce it in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: d4f116d9576453f5974eb63db37a33c59ac53bc9 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Could you please try to reproduce it with version 7.1.3.2 of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Still the same with: Version: 7.1.3.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 12; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: CL Old references can't be updated, gives "The link could not be updated."
Above test was made from the repository download.opensuse.org/repositories/LibreOffice:/7.1/openSUSE_Leap_15.2 . Remove all of these and install the rpms from RPMS directory out of LibreOffice_7.1.3_Linux_x86-64_rpm.tar.gz . Version: 7.1.3.2 / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 12; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: CL When starting /usr/bin/libreoffice7.1 direct, all functions work as expected.
Same here: Version: 7.1.3.3 / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 4; OS: Mac OS X 10.15.7; UI render: GL; VCL: osx Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Additional observations: * Cannot create new links (as described by original reporter) * If I open an exisiting ODS, which already has external http links, LO will refuse to update them "Die Verknüpfung konnte nicht aktualisiert werden." (as described by original reporter) * If I open the existing ODS with MS Excel, the links can be updated (to be honest, I was surprised that Excel is so compatible...) Perhaps some permissions issue, that only affects linux/mac? Is there any log file, I could check for errors?
Save Mode and a new user profile did not solve this issue.
WFM Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: eda109d5d91e82adb675ebf6db952bf6d82b3391 CPU threads: 4; OS: Windows 10.0 Build 21387; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
Same problem with external data from: https://www.aliorbank.pl/dodatkowe-informacje/informacje/kursy-walut.html Libra shows HTML_all - only text HTML_tables - no data Version: 7.2.4.1 (x64) / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 16; OS: Windows 10.0 Build 14393; UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: pl-PL Calc: threaded
(In reply to Krzysztof from comment #8) > Same problem with external data from: > https://www.aliorbank.pl/dodatkowe-informacje/informacje/kursy-walut.html > > Libra shows > HTML_all - only text > HTML_tables - no data I reproduce. There is something specific in this table that LibreOffice is tripping over. Arch Linux 64-bit Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: d45d65559f11ecb34b14e3b5c838391c62c8c694 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 1 December 2022