Harold Fuchs wrote:
> I assumed you would have telephone numbers in a column (say column 1) and
> the names in the next column (column 2).
That's right.
> 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.
Yes.
> Each cell in the third column then displays the name from column 2
> but links to the number from column 1.
That's a missunderstanding.
In my table, both, the name cell /and/ the number cell, should link to
the number.
The user should be free to use both cells to click.
That's the simple motive.
> I don't understand what you are trying to do with having the same cell
> mentioned twice in the =hyperlink formula.
I hope it is clear now. Please let me know if not.
As a complete example:
A1=Railway Information
B1='0800784098098
C1=HYPERLINK("tel:"&B1;A1)
D1=HYPERLINK("tel:"&B1;B1)
In words: C1 and D1 has the same target: href="tel:0800784098098".
But they have a different link text.
> If I understand you
> correctly, you want Calc to invoke your VoIPdial software if you click a
> "tel:" link. Is that right?
Exactly.
Regards, Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
