<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - Completion of double quotes for HYPERLINK functions."
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=124201">124201</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Completion of double quotes for HYPERLINK functions.
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.3.0.0.alpha0+ Master
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>enhancement
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>baffclan@yahoo.co.jp
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
"URL" and "Cell Text" results need to be completed with double quotes.


Steps to Reproduce:
1. Create new calc
2. Click A1 cell
3. Click [fx](Function Wizard) in Formula bar
4. Appear Function Wizard window
5. Type "hyperlink" in search box
6. Double click "HYPERLINK" in Function
7. Type [<a href="http://www.libreoffice.org/">http://www.libreoffice.org/</a>] in URL box
8. Type [Libreoffice] in Cell text box



Actual Results:
Function result said "Err:510".



Expected Results:
"URL" and "Cell Text" results need to be completed with double quotes.
Result:
<span class="quote">> {"libreoffice";"<a href="http://www.libreoffice.org/">http://www.libreoffice.org/</a>"}</span >
Formula:
<span class="quote">> =HYPERLINK("<a href="http://www.libreoffice.org/">http://www.libreoffice.org/</a>","libreoffice")</span >




Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.2.2 (x64)
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ja-JP (ja_JP); UI-Language: en-US
Calc: threaded

Version: 6.3.0.0.alpha0+ (x64)
Build ID: de024e572dd7a588f82b84c68daa2051ec6b20e9
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-18_01:13:57
Locale: ja-JP (ja_JP); UI-Language: en-US
Calc: threaded</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>