Created attachment 165743 [details] 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)
Hi, I also found a very similar issue: - Put =HYPERLINK(CONCATENATE("https://test.com/",A2)) as cell value - the pop up link will show http://concatenate(https//test.com/ 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,
Confirmed.