[Libreoffice-bugs] [Bug 136938] New: HYPERLINK function cannot concatenate URL's strings

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136938

            Bug ID: 136938
           Summary: HYPERLINK function cannot concatenate URL's strings
           Product: LibreOffice Online
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: olivier.hallot at libreoffice.org
            Blocks: 120543

Created attachment 165743
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165743&action=edit
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("https:/wiki.documentfoundation.org/Documentation/Calc_Functions/" &
B2;B2)

in any other cell

3) Click in the hyperlink created in the cell

Results:
The link created is 
https://wiki.documentfoundation.org/Documentation/Calc_Functions/&B2

Expected results:
https://wiki.documentfoundation.org/Documentation/Calc_Functions/ABS

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)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=120543
[Bug 120543] [META] Bugs and enhancements around hyperlinks in Calc
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200921/e1554681/attachment.htm>