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)
Version:
(earliest affected)
6.0 all versions
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
: 128817 (view as bug list)
Depends on:
Blocks: Calc-Styles XLSX-Hyperlink Hyperlink-Calc
  Show dependency tree / graph
 
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:

Attachments
sample (9.12 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-10-22 00:31 UTC, Yousuf Philips (jay) (retired) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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]
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
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 
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
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: 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).