<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 - HYPERLINK function cannot concatenate URL's strings"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136938">136938</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>HYPERLINK function cannot concatenate URL's strings
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice Online
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</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>normal
</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>olivier.hallot@libreoffice.org
</td>
</tr>
<tr>
<th>Blocks</th>
<td>120543
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=165743" name="attach_165743" title="Image of the HYPERLINK issue">attachment 165743</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=165743&action=edit" title="Image of the HYPERLINK issue">[details]</a></span>
Image of the HYPERLINK issue
(The following issue work in the desktop 7.0 version , but not in LibreOffice
Online.)
HYPERLINK function does not render string concatenation for its first argument
(URL)
Step to reproduce:
1) Place "ABS" in cell B2
2) Place
=HYPERLINK("<a href="https:/wiki.documentfoundation.org/Documentation/Calc_Functions/">https:/wiki.documentfoundation.org/Documentation/Calc_Functions/</a>" &
B2;B2)
in any other cell
3) Click in the hyperlink created in the cell
Results:
The link created is
<a href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/&B2">https://wiki.documentfoundation.org/Documentation/Calc_Functions/&B2</a>
Expected results:
<a href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ABS">https://wiki.documentfoundation.org/Documentation/Calc_Functions/ABS</a>
Further info
LibreOffice Online
This version of LibreOffice Online is powered by
LOOLWSD
7.0.0
Served by: 390cd11e
LOKit
LibreOffice 7.0.1.2 (git hash: 00(Buil)
"Debian GNU/Linux 10 (buster)"
Copyright © 2020, The Document Foundation
(actually this is in the TDF NextCloud instance)</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Bugs and enhancements around hyperlinks in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120543">Bug 120543</a>] [META] Bugs and enhancements around hyperlinks in Calc
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>