Bug 124201 - Completion of double quotes for HYPERLINK functions.
Summary: Completion of double quotes for HYPERLINK functions.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.0.alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Wizard Calc-Function Hyperlink-Dialog
  Show dependency tree / graph
 
Reported: 2019-03-19 09:26 UTC by baffclan
Modified: 2024-03-13 05:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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