Open attachment 180120 [details] or 180121 from bug 149076 and save it to .ods. Look at the element <style:style> of the cells with hyperlink in content.xml. The element has the attributes 'style:hyperlink' and 'loext:hyperlink'. The attribute 'style:hyperlink' should not be there. Such attribute does not exist in ODF 1.3 and makes the markup invalid. The import of such hyperlinks was implemented in https://cgit.freedesktop.org/libreoffice/core/commit/?id=92afb61d8bb1b264a945371065115981ecaed0f1 Writing in ODF was implemented in https://cgit.freedesktop.org/libreoffice/core/commit/?id=066bdb31f7ff801b7a36c79c43ecbd527ffb2a88
Confirmed Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7195e2740eb1c71f5bbc4322b3535d56b39e2817 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 18 January 2023
Still here Version: 24.2.1.1 (X86_64) / LibreOffice Community Build ID: 359ef544e625d2ffbfced462ab37bd593ca85fa7 CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded <style:hyperlink xlink:href="http://www.google.com/" xlink:type="simple"/><loext:hyperlink xlink:href="http://www.google.com/" xlink:type="simple"/>