<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - HYPERLINK function cannot concatenate URL's strings"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=136938#c1">Comment # 1</a>
              on <a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - HYPERLINK function cannot concatenate URL's strings"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=136938">bug 136938</a>
              from <span class="vcard"><a class="email" href="mailto:ranggapermana@catalyst.net.nz" title="Rangga <ranggapermana@catalyst.net.nz>"> <span class="fn">Rangga</span></a>
</span></b>
        <pre>Hi,

I also found a very similar issue:
- Put =HYPERLINK(CONCATENATE("<a href="https://test.com/">https://test.com/</a>",A2)) as cell value
- the pop up link will show <a href="http://concatenate(https//test.com/">http://concatenate(https//test.com/</a>

If I use right click on the cell it is still redirect to the correct url, so
probably the bug only on pop up link

Thanks,</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>