Bug 113337 - FILEOPEN: XLSX - Hyperlinks always displayed as blue, even if style uses different font colour
Summary: FILEOPEN: XLSX - Hyperlinks always displayed as blue, even if style uses diff...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
6.0 all versions
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: filter:xlsx
: 128817 (view as bug list)
Depends on:
Blocks: Calc-Styles XLSX-Hyperlink Hyperlink-Calc
  Show dependency treegraph
Reported: 2017-10-22 00:31 UTC by Yousuf Philips (jay) (retired)
Modified: 2023-10-09 09:02 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

sample (9.12 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-10-22 00:31 UTC, Yousuf Philips (jay) (retired)

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2017-10-22 00:31:43 UTC
Created attachment 137197 [details]

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

Build ID: 8ba60ca42d4d1873b8cd85c5d3b5ed2f0e19df60
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 1 MM 2017-10-22 08:31:41 UTC
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)..."
Comment 2 Yousuf Philips (jay) (retired) 2017-10-22 17:13:20 UTC
(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
Comment 3 MM 2017-10-22 21:01:20 UTC
I thought with the comment you made, that LO colors hyperlinks automatically on fileopen.
Comment 4 Buovjaga 2017-11-07 16:01:55 UTC

Arch Linux 64-bit, KDE Plasma 5
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
Comment 5 Xisco Faulí 2019-11-15 11:16:33 UTC
*** Bug 128817 has been marked as a duplicate of this bug. ***
Comment 6 Stéphane Guillou (stragu) 2022-09-17 21:13:07 UTC
Reproduced in:

Version: / 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).