Bug 156849 - can't overwrite auto-applied formatting of Calc hyperlinks (underline, font colour...)
Summary: can't overwrite auto-applied formatting of Calc hyperlinks (underline, font c...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 162360 (view as bug list)
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2023-08-21 18:12 UTC by Daveo
Modified: 2024-10-15 19:26 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Illustration of regression. (34.10 KB, image/png)
2023-08-21 18:12 UTC, Daveo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Daveo 2023-08-21 18:12:15 UTC
Created attachment 189079 [details]
Illustration of regression.

An issue was recently raised on the "users" mailing list where a user wanted to set his own cell style for hyperlinks so that links are not underlined.
The user opens the Hyperlink style dialog, where he can set the font size and color, but selecting  "Underlining > Without" does not change that aspect of the hyperlink style.
It appears to work in version 7.4.7,2 provided the file is not opened in version, or another application.
Comment 1 Daveo 2023-08-21 18:39:18 UTC
Last line of report should read:
It appears to work in version 7.4.7,2 provided the file is not opened in version 7.6.03, or another application.
Comment 2 Buovjaga 2023-09-20 17:12:33 UTC
Bibisected with linux-64-7.6 to 89e65e6afdfc942cf8232886d6703947167eaec3
tdf#153880 sc: Make Calc text hyperlinks stand out more

Not calling it a regression, but let's add the people involved to Cc.
Comment 3 Heiko Tietze 2023-09-21 06:51:47 UTC
You can change the font color via Tools > Options > General > Application Color. But the underlining will remain probably in the default, at least it happens in a quick test, and you change the color globally.

Another question I see is the cell style Text > Hyperlink, which is not applied nor meaningful anymore.

And the actual question is whether we should allow changing the font / font effects of links per cell, per document, or globally. The alternative is to accept the situation that links are defined by the OS/DE.

@Daveo, it's also a question for you.
Comment 4 Stéphane Guillou (stragu) 2023-10-09 09:02:27 UTC
(In reply to Heiko Tietze from comment #3)
> And the actual question is whether we should allow changing the font / font
> effects of links per cell, per document, or globally. The alternative is to
> accept the situation that links are defined by the OS/DE.

Issue is we produce documents and we should allow to cater for user preference, but hyperlinks are a special case as they have e.g. visited colours (which by the way does not happen anyway in Calc, see bug 44189) and need consistency across the file...
I do agree that we need to have a more uniform handling of hyperlink formatting across components. Currently the fact that users consider a variety of factors that include OS/DE + Application colours + character or cell style + direct formatting is not good UX.

For the problem described here, the actual issue predates 7.6 and is that we can't change the auto-formatted hyperlink style or direct formatting like we can in Writer (in which a Hyperlink character style is used). It's the same for the font colour (which can be worked around by using Tools > Options > LibreOffice > Application Colours), and was the same for the grey highlight before it was removed.
The cell style is unrelated: it can give a hyperlink look to a cell if needed. See how it can be useful in bug 134456 comment 6. (That bug was originally the same issue, but was redirected to improving documentation.)

Maybe this is linked to character style support requested in bug 108220?
And compatibility with how other suites handle it has to be considered, see bug 113337.
Comment 5 Buovjaga 2024-08-05 19:20:14 UTC
Bug 159747 was meanwhile closed as notabug.
Comment 6 Buovjaga 2024-08-05 19:20:32 UTC
*** Bug 162360 has been marked as a duplicate of this bug. ***
Comment 7 Ademas 2024-08-28 08:25:46 UTC
I very much second this. The underlines in the hyperlinks tend to clutter my spreadsheets, reducing readability. This is a major reason I have been resisting to upgrade from 7.5.

We need a way to set the global style of hyperlinks, and also cutomize them individually. For example, in my case, I have a column that only and always has hyperlinks, so there is no need to clutter it with underlines. But I want them on other parts of the documents.

About the font colours, while there is currently a way to change it... I'd appreciate it if it was as simple as changing the colors of normal text. With the click on toolbar.

I don't accept that the way links look should be defined elsewhere, if I want my hyperlink to look like an ugly potato, or to even make a ghost link that only people in the know will know where to click to access it, I should be able to.
Comment 8 David Hale 2024-10-15 19:26:15 UTC
Any idea when this bug will be resolved?
I'm still stuck on v7.5.9.2 which (I think) is the last version without this bug.