On 30/06/07, Andreas Borutta <[EMAIL PROTECTED]> wrote:
Hello,
in OOo-Calc 2.2.1 you could markup content as a hyperlink (http,
ftp).
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>
I do not want to markup each cell manually of course.
Do you think the task could be solved with Calc (and a macro)?
Thanks.
Regards, Andreas
--
http://borumat.de/openoffice-writer-tipps
http://borumat.de/firefox-browser-tipps
http://borumat.de/thunderbird-email-tipps
http://borumat.de/heisse-schokolade-aus-ganzen-kakaobohnen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This may get you on the road.
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.
C1 gets formatted in such a way that when you roll the mouse over the cell
a) the cursor changes to a hand as if the cell were a hyperlink and
b) it displays the right "alt text".
Of course clicking this link doesn't buy you much. This is true with Firefox
and with IE6. OpenOffice doesn't seem to understand the tel: protocol
specifier either because it doesn't *seem* to try to execute any program.
Please explain the "tel:" protocol and how it may be used; it sounds
interesting.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
