On 30/06/07, Andreas Borutta <[EMAIL PROTECTED]> wrote:
Harold Fuchs wrote:
>> I would like to make a simple table which contains two rows, one with
>> a name, the other with a telefon number, more smooth to use.
>>
>> Each part of a name/number pair should appear as a hyperlink with the
>> URI-handler "tel:".
>>
>> In HTML it would look like that:
>> <a href="tel:08001507090">Railway Information</a>
>> <a href="tel:08001507090">08001507090</a>
> 1. Put the telephone number in A1 *as text* (on entry, precede the
number
> with a single quote to maintain its leading zeroes etc.)
> 2. Put the "name" ("Railway Information" in your first example) in B1
> 3. Put the formula =HYPERLINK("tel:"&A1;B1) in C1.
Thanks for this helpful hint. :)
I modified it a little to get the complete table Cn-Dn:
C1=HYPERLINK("tel:"&A1;A1)
D1=HYPERLINK("tel:"&A1;B1)
I assumed you would have telephone numbers in a column (say column 1) and
the names in the next column (column 2). Then, after entering the formula in
the top cell of the third column you would simply drag the formula down to
"copy" it into each row. This copying would, of course, follow the normal
rules so A1 in row 1 automatically becomes A2 for row 2, A3 for row 3 und so
weiter. Each cell in the third column then displays the name from column 2
but links to the number from column 1. So, in your example cell C1 would
display "Railway Information" but would link to 08001507090. Hovering over
cell C1 would show "tel:08001507090" as alt text. I don't understand why you
need a fourth column.
In an HTTP example, A1 might contain "
download.openoffice.org/2.2.1/index.html", B1 might contain "Get OpenOffice"
and using the formula =hypertlink("http://"&a1;b1) in C1 would cause C1 to
display "Get OpenOffice" but link to the http://.... link.
I don't understand what you are trying to do with having the same cell
mentioned twice in the =hyperlink formula.
In a browser one could see the target of link inside the statusbar.
Is there any way to view the target of a link inside openoffice while
hovering a link?
When you hover over the link using Calc you see "tel:" and the number; is
this what you mean? Otherwise I don't understand the question.
Of course clicking this link doesn't buy you much. This is true with
Firefox
> and with IE6.
I installed the software VoIPdial
http://www.martin-dehler.de/voip/voipdial/voipdial.htm (German
language) to make any browser (FF or IE) be able to interpret links
like
<a href="tel:08001507090">Foo Bar</a>
on a web page correctly:
It will dial the number and I could take up my telephone.
That's extremly comfortable.
Background information:
In the Windows registry VoIPdial enters a key
HKEY_CLASSES_ROOT\tel\shell\open\command
C:\Programme\VoIPdial\VoIPdial_Dialer.exe "%1"
> OpenOffice doesn't seem to understand the tel: protocol
Openoffice should only, that is my wish, behave like FF or IE.
I like to know, if that is possible with OOo.
I don't think so but someone else might have a way. If I understand you
correctly, you want Calc to invoke your VoIPdial software if you click a
"tel:" link. Is that right?
Please explain the "tel:" protocol and how it may be used; it sounds
> interesting.
"tel:" is an official URI-handler:
http://www.iana.org/assignments/uri-schemes.html
http://www.rfc-editor.org/rfc/rfc3966.txt
Gruß, Andreas
--
http://borumat.de/firefox-browser-tipps
http://borumat.de/html-und-css-tipps
http://borumat.de/heisse-schokolade-aus-ganzen-kakaobohnen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Regards,
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
