Ask Your Question
0

Accessing Hyperlinks without Using the CTRL Key, etc.

asked 2018-12-28 22:13:19 +0100

Lady Fitzgerald gravatar image

Is there some way to reset Calc so I can click on a hyperlinks without having to use the CTRL key?

Also, when I create a hyperlink in a cell, Calc creates a border around the hyperlink that is the same color of the cell. Is there any way to keep it from making that annoying outline?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-12-28 22:24:12 +0100

Grantler gravatar image

updated 2018-12-28 22:31:19 +0100

Is there some way to reset Calc so I can click on a hyperlinks without having to use the CTRL key?

Deselect:

Tools menu > Options > LibreOffice > Security :: Security Options and Warnings :: Options > Security Options :: Ctrl-click required to follow hyperlinks

Calc creates a border around the hyperlink that is the same color of the cell.

Probably you mean the Field Shade?

Tools menu > Options > LibreOffice > Application Colors > Text Document :: Field shadings

Choose another color or deselect. Please notice: This alteration has an impact on other program tools, too (eg Writer).

edit flag offensive delete link more

Comments

The suggestion for eliminating the need for pressing the CTRL key before clicking an a hyperlink worked great. Thanks!

However, the border around hyperlinks is another story. I gave a bad description of the problem so let me try again.

I have my cell text set for white for the entire spreadsheet, and cell background and cell borders for the entire document is set to black. Hyperlinks show up as a dark blue or purple (both colors look the same to me) and have a white line outlining hyperlink. I feel the outline is annoying and want it to go away. also, the font color needs to be white since it contrasts poorly with the black background. Is there anyway to change the font color of the hyperlink to white?

Lady Fitzgerald gravatar imageLady Fitzgerald ( 2018-12-28 23:10:53 +0100 )edit

I came up with a workaround for the white outline and wrong color for the hyperlink. Instead of making the title of the file I'm wanting to access a hyperlink, I put a column before the title column with a bolded letter O in each row of that column to emulate a button, then made that letter the hyperlink. To access the file I want, I just click on the button.

Lady Fitzgerald gravatar imageLady Fitzgerald ( 2018-12-29 06:57:45 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-28 22:13:19 +0100

Seen: 414 times

Last updated: Dec 28 '18