Bug 124201

Summary: Completion of double quotes for HYPERLINK functions.
Product: LibreOffice Reporter: baffclan <baffclan>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: buzea.bogdan
Priority: medium    
Version: 6.3.0.0.alpha0+   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 105582, 108827, 112125    

Description baffclan 2019-03-19 09:26:47 UTC 
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 [http://www.libreoffice.org/] 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:
> {"libreoffice";"http://www.libreoffice.org/"}
Formula:
> =HYPERLINK("http://www.libreoffice.org/","libreoffice")




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
Comment 1 IM 2019-08-01 15:23:40 UTC 
Thank you for reporting the bug. I can confirm that the bug is present in:

Version: 6.2.5.2 (x86)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: pl-PL (pl_PL); UI-Language: en-US
Calc: threaded

Version: 6.4.0.0.alpha0+ (x86)
Build ID: 5c30c20101f72d973ff28c228f755e635cad14d5
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: pl-PL (pl_PL); UI-Language: en-US
Calc: threaded
Comment 2 Andreas Heinisch 2022-07-14 07:54:02 UTC 
This holds for a lot of functions that require arguments of type string.
Comment 3 baffclan 2022-07-17 03:50:06 UTC 
There is also a way to supplement the explanation.

 KEYID:  XFwBY
 "The clickable URL."
  -> 
 "The clickable URL. Enclose the URL in double quotation."
Comment 4 BogdanB 2024-03-13 05:55:58 UTC 
Still repro with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e5548dceb9086a6f0c8fa70bce8de6da0be72e40
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded