[Solved] Pasting hyperlinks – Font problem

[CraigG58]

I have a spreadsheet with one column containing Internet hyperlinks (which I need to be clickable), and paste URLs into its cells after copying them from my web browser.

The entire column is pre-formatted as an Arial 8 font, and I've also got the “Tools > Options > OpenOffice > Fonts” dialog “Font settings for HTML” set to the same font and size. But, when do a simple paste or a “paste special” as “HTML format”, the font size for that cell is always increased to 10 by Calc, requiring me to go back and re-format it. I haven't been able to find any other setting that may control this.

If I "paste special" as “Unformatted text”, that works as expected using in the correct font formatting I've set, but of course no active hyperlink.

Where am I going wrong here? Thanks in advance for any help!

[UnklDonald418]

Instead of pasting the URL directly into a cell, try Insert>Hyperlink and pasting the URL into the Target field of the dialog.

[CraigG58]

Sorry, was premature with that last response. The entire column wasn't re-formatted back to the correct size font after the previous mishaps I'd described...

After reformatting it back to Arial 8, then performing the paste as you suggested, it works perfectly. Thanks mucho for the suggestion, problem fixed!