Created attachment 137197 [details] sample steps: 1. open attachment 2. notice that hyperlink is in blue 3. check the 'Excel Built-in Hyperlink' cell style assigned to the cell, which has it as red Version: 6.0.0.0.alpha1+ Build ID: 8ba60ca42d4d1873b8cd85c5d3b5ed2f0e19df60 CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: group
Looks a bit like bug 80040. In comment14 youself say "So LO automatically colors all hyperlinks text in blue with a gray background and doesnt assign it to a hyperlink cell style (whether already defined or not)..."
(In reply to MM from comment #1) > Looks a bit like bug 80040. Yes they are related as they are about xlsx hyperlinks, but that bug is a filesave issue and this is a file open issue. :D
I thought with the comment you made, that LO colors hyperlinks automatically on fileopen.
Confirmed. Arch Linux 64-bit, KDE Plasma 5 Version: 6.0.0.0.alpha1+ Build ID: f657454b69c813b90a8b3c1adb2feef1066dbd35 CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on November 7th 2017
*** Bug 128817 has been marked as a duplicate of this bug. ***
Reproduced in: Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 3752e8eaa81a50b018669d03dc59b3753a5248ef CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Notice that this happens even if "Tools > Options > LibreOffice > Application Colours > Custom Colours > General" has link colours unticked. Both OnlyOffice and MS Office 365 respect the red style of attachment 137197 [details]. But I don't think this is specific to XLSX, as saving as ODS doesn't use the colour either. (However, the link is red if saved as XLS).
I think, that xslx import/export problem is connected to bug 62622 and bug 69565. The underlying problem is, that ODF has an attribute for the style of the hyperlink as attribute of the <text:a> element itself. There exists no corresponding attribute of the <hyperlink> element of OOXML. Thus MS Office has the style of the link as attribute of the text run. But LibreOffice uses font color and underline of the hyperlink attribute (bug 62622) and the AutoCorrect option "URL Recognition" sets the hyperlink style automatically and LibreOffice does not provide a user-interface to determine which style is used (bug 69565). Getting better export/import with OOXML formats requires, that bug 69565 and bug 62622 are solved. Tested with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded