[Solved] How to show Hyperlink?

[dawidek990]

Hello, does anyone know what to do so that instead of the name, they showed me the addresses in the cells with hyperlinks?
For example: I have name Openoffice but is hiperlink http://www.openoffice.com, calc show me only OpenOffice, when i clikc it, browser open link... but i need, to calc show me links in cells ;]
it is possible?

Greeteings ;]

[FJCC]

If I type
www.openoffice.org
in a cell, it gets formatted as a hyperlink and shows exactly that text. This works if I have the option URL Recognition selected in the menu Tools -> AutoCorrect Options on the Options tab.
I can also enter the formula

Code: Select all

=HYPERLINK("www.openoffice.org")

in a cell and it will display that text and act as a hyperlink.

[dawidek990]

Okey, is not what i want.

Look in this file on column G... there is a hiperlinks, but i need see links in cells no names of products. How can i do this?
some options? or forumla? or makro?

[DiGro]

On column G select the entry you want to change (Click in the cell next to the text, otherwise you will use the link and go to the page)

Use Insert --> Hyperlink

then copy the text from Target to Text (see picture)

[Zizi64]

Here is a macro cellfunction solution, the original code written by Villeroy, I just modified it.
viewtopic.php?f=21&t=2762

Code: Select all

REM  *****  BASIC  *****
Option Explicit

Function CELL_URL(lSheetIndex as long,lRowIndex as long, iColIndex as long)
 Dim oDoc as object
 Dim oSheet as Object
 Dim oCell as object

	oDoc = ThisComponent
	oSheet = oDoc.Sheets.getbyindex(lSheetIndex)
	oCell = oSheet.getCellByPosition(lRowIndex,iColIndex)
	CELL_URL = "nothing"
	if vartype(oCell) = 9 then
		CELL_URL = oCell.getTextfields.getByIndex(0).URL
	end if
End Function

Polcolorit_Villeroy_Zizi64.ods

(32.31 KiB) Downloaded 107 times

[dawidek990]

Wow, is working, thank you very much ;]

[Lupp]

If somebody wants to also be able to list any number of URL linked to portions of the text contained in a cell, the attached example can help. It contains user functions for the purpose.