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@lists.freedesktop.org
Reporter: olivier.hal...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs