[Solved+Issue] Change the color of a hyperlink text

[seni]

Hello,

I have a workbook page with thousands of hyperlinks,
and I would like only one of them to have characters in a color other than black.

Is it possible to change the character colors of a single hyperlink?

[LastUnicorn]

What office suite are you using? OpenOffice, LibreOffice, something else?

[seni]

I think it's apache open office.

[Hagar Delest]

You have posted in the general discussion section.
By workbook, do you mean text (Writer) or spreadsheet (Calc)?

[LastUnicorn]

Assuming your using Writer.

Right Click on the hyperlink and chose 'Character...'
On the 'Font Effects' (tab) chose a 'Font Colour' you would be happy with (then click the 'OK' button).

Well done on adding a signature saying what application suite you are using. Perhaps you could add your operating system too — this information can at times be helpful.

[seni]

Oh sorry!
I use OpenOffice Calc. spreadsheet (Calc)

I only have character in format, but it is not clickable.

[MrProgrammer]

Is it possible to change the character colors of a single hyperlink?

You can change the color for a cell's text in Calc by creating a new cell style. In the style dialog, the cell text color is set in Font Effects → Font Color. Apply that style to the =HYPERLINK() cell that you want to change. Read about styles using the link I provided. It tells you how to create, modify, and apply styles.

I use OpenOffice Calc. spreadsheet (Calc)

This information would have helped us answer the question sooner. Instead we had to ask what component you were using. I moved the topic to the Calc forum. Some features of LibreOffice work differently than OpenOffice, so we want to know which suite you use too. Finally, you should tell us your operating system because that may affect responses to future topics that you create. I will not help further until you provide that information.

If you need any additional assistance attach a spreadsheet demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach a spreadsheet document. If your file is large, we don't need the whole thing, just enough to give us an idea of what it looks like.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[seni]

I am on Windows 10.

I was able to create the style, but the tutorial does not explain how to apply it to a hyperlink, and I am unable to do so.

[LastUnicorn]

Is your Windows 10 operating system 32-bit or 64-bit?

[seni]

win 10 64 bit

[LastUnicorn]

I have tried doing as MrProgrammer suggests in both OpenOffice 4.1.15 and LibreOffice 25.8.1.1 and in neither is it possible to change the colour of the text of a hyperlink.

What it is possible to do in both, is to partially change the Background colour of a cell containing a hyperlink. The result doesn't look sweet but the cell is highlighted and that might be okay for your purposes.

However, in among trying all this, I looked at OpenOffice BugZilla and LibreOffice BugZilla both have mention of this as a bug for Calc. It is pointless pursuing OpenOffice BugZilla as development of OpenOffice is effectively dead. So, for what it is worth, here is the bug report for LibreOffice on this: Bug 156849 - can't overwrite auto-applied formatting of Calc hyperlinks (underline, font colour...). Note that that bug report is linked to 5 others too on this common theme, so this is an ongoing gripe for users.

However, if this is a critical issue for you seni then the last comment in the bug report mentions that LibreOffice v7.5.9.2 is free from this bug (I do not know if that is correct information or not). If you want to try that version of LibreOffice then it can be got here: Index of /libreoffice/old/7.5.9.2/win/x86_64. This will suit your Windows 10 64-bit.

As you are on Windows 10 you might want to consider switching from OpenOffice to LibreOffice. There are several good reasons for making the switch anyway, some of which are mentioned here: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information

[seni]

Thank you for all this information and for your help.

It's a shame about the bug.
I can't get LibreOffice to work; the hyperlinks aren't working.
I tried recreating some of the hyperlinks, but it still doesn't work.

[Lupp]

Even if you edit the cell with the link with the help of user code, and set the CharColor explicitly for the "anchor" (range with string) this has no effect.
If you want to show the string of a hyperlink colored as you choose, you need to use the HYPERLINK() function which returns ordinary text, but assigns the link to it in the background.
Example made with LiobO V 25.8.0.4

oof_113063_CharattributesHyperlinks.ods

(19.74 KiB) Downloaded 16 times

[seni]

Thanks Lupp, that's an option that suits me very well. I'll have to save the link plus the name of each of my hyperlinks one by one, which will take time, but it works.

Thank you very much.

[Lupp]

Thanks Lupp, that's an option that suits me very well. I'll have to save the link plus the name of each of my hyperlinks one by one, which will take time, but it works. ...

Not sure if I understood your "... I'll have to save the link plus the name of each of my hyperlinks one by one, ..." correctly.
If you have a sheet with already recognized (working) links which you want to convert using HYPERLINK(), you may be interested in the magic wand contained in the new attachment.

oof_113063_ConvertRecognizedHyperlinksToFunctionresults.ods

(23 KiB) Downloaded 13 times

[MrProgrammer]

I have tried doing as MrProgrammer suggests in both OpenOffice 4.1.15 and LibreOffice 25.8.1.1 and in neither is it possible to change the colour of the text of a hyperlink.

Works for me. I set A1 to use blue text and A2 to use red text.

As displayed by OpenOffice 4.1.7 on MacOS 13.7.8 showing two hyperlink colors

202509101403.gif (74.39 KiB) Viewed 937 times

I created style Link blue text and chose the font color, then applied the style to cell A1

202509101404.gif (31.52 KiB) Viewed 937 times

202509101403.ods

Sample file showing two hyperlink colors set by cell style

(18.35 KiB) Downloaded 16 times