The hyperlink() function does not get encoded into an html document as expected.

The test spreadsheet with cells A1-A3 is as follows:

    =hyperlink("http://www.openoffice.org")
    =hyperlink("http://www.openoffice.org";"click")
    =hyperlink("mailto:issues@openoffice.org?subject=test";"send e-mail")

Based upon my understanding, this should be translated to the following html code:

    <a href="http://www.openoffice.org">http://www.openoffice.org</a>
    <a href="http://www.openoffice.org">click</a>
    <a href="mailto:issues@openoffice.org?subject=test">send e-mail</a>

Instead, the html document is simply plain text with no links as follows:

     http://www.openoffice.org
     click
     send e-mail

The hyperlink() function appears to export properly to pdf.

The problem is reproducible in both Windows XP Professional and Linux (Mandriva
10.1 Official)


Tom