Apache OpenOffice (AOO) Bugzilla – Issue 9120
Some mailto hyperlinks do not import from MS Excel
Last modified: 2003-09-08 16:55:29 UTC
I have a MS Excel document that has a list of email addresses. They have all been automatically converted to hyperlinks. This means that they don't appear to have the mailto: in front of the text. When I open the document in OOo 80 percent or so of the addresses are still hyperlinks, and the rest are only text. This is also true for web page links. Also addresses only seem to convert to hyperlink if mailto: etc is in front, maybe add option to convert text around @ symbol to hyperlink (as MS Office does).
Please attach this Excel file. Thanks You may disguise the mail addresses, but the wrong import should be reproducible ;-)
Sorry, I just rechecked all of the links and the ones that don't work are only colored to look like links in excel, but there is no field shading to prove that fact. I knew that many of the links worked, so I assumed that they all did. False alarm, sorry. As to the second part of my question. If a link is typed in it converts @ and www to a link automatically, but if the address is pasted into a speadsheet it is left as text. It seems like it should still be converted. Also in Excel if a cell is not converted and you edit the cell, it will convert it. IE hit F2 and then enter. Thanks.
It is intended, that text is converted to URLs only after editing a cell (F2+Enter). A paste sould not modify anything, it should transport the clipboard contents exactly to the destination. There are different ways to paste from clipboard (in Calc and Excel): 1) Copy&Paste a complete cell. Excel and Calc will not modify it (simple text with @ remains simple text). URLs are copied. 2) Copy text, paste in edit mode (F2, select, copy, move, F2, paste, Enter). Text converts to URL. 3a) Copy simple text, paste as entire cell (F2, select, copy, move to another cell, paste). Inserts text only. 3b) Copy URL from text, paste as entire cell (F2, select URL, copy, move to another cell, paste). Calc inserts URL, Excel inserts simple text. Seems that Calc works better here. 4) Copy cell, paste in edit mode (Copy cell, move, F2, paste). Does not work in Excel, works in Calc. Calc wins. ;-)
works->closed