Email address linking in Calc- works in 3.5.7.2, not in 4.1.3.2

[xerion567]

When I enter an email address into a cell in Calc it automatically gets formatted into a mailto: link. Clicking on the cell in Calc 3.5.7.2 (Ubuntu 12.04 - Gnome3) results in starting a new email to that address, but clicking on the cell in Calc 4.1.3.2 (Mint 16 - Cinnamon) does nothing. Both machines are using Thunderbird for email.

I can get the desired functionality by ctrl-clicking, but the inconsistency is confusing for new users (Excel behaves as 3.5.7.2). What could be causing this?

Also the formatting for the email link is a dark grey background with dark blue text (in Mint 16), making it difficult to read. Is there a way to change this?

[mariosv]

The option is in Menu/Tools/Options/LibreOffice/Security/Security options and warnings - Options.

[xerion567]

Thank you very much, that did the trick!

[oweng]

To set the colour of a hyperlink use Tools > Options… > LibreOffice > Appearance and then:

• General section > the “Unvisited links” and “Visited links” entries change the foreground text colour.
• Text section > the “Field shadings” entry changes the background shading colour.

[xerion567]

Perfect! Thank you!