[libreoffice-users] Re: copy from Thunderbird and paste to Calc

Am 14.09.2011 19:50, James wrote:
> I want to see if this works for anyone (on another than Linux platform).
>
> 1. compose a new message in Thunderbird
> 2. Enter
> libreoffice-users Mailing List <users@global.libreoffice.org>
> on the to line:
> 3. Select all the to: and copy it to the clipboard
> 4. Create an empty spreadsheet
> 5. Past the clipboard in a cell
>
> It should work.
>
> Now try (quotes around the name):
> "libreoffice-users Mailing List" <users@global.libreoffice.org>
> It only pastes what is inside the quotes.
> Even past-special doesn't work.
>
> Past into the expression bar, it works.

In a spreadsheet I would always prefer a list of 2 columns, one for the 
mail address, another for a label and let a formula build the hyperlink. 
This way I can simply edit all hyperlinks in plain text and use a 
descriptive label or not.

=HYPERLINK(A1;IF(LEN(B1);B1;A1)) [show the label text B1 if any]
=HYPERLINK(IF(LEFT(A1)="mailto:";"";"mailto:";)&A1;IF(LEN(B1);B1;A1)) 
[prepend "mailto:"; if A1 does not start with "mailto:";, show label B1 if 
any]


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted