source/text/scalc/01/04060109.xhp | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit 55e53682d9285f018385e273774a7d106a34efd4
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Sun Jan 23 23:47:24 2022 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Sun Jan 23 23:57:39 2022 +0100
HYPERLINK() clarify that it is not "CellText" but CellValue
i.e. the argument and thus function result does not have to be of
type text.
Change-Id: I8e1917ecc5f740f880b5321c4c91f7512c9e3245
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128844
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 98b802017..99e061ae0 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -638,12 +638,12 @@
</bookmark>
<h2 id="par_idN11798">HYPERLINK</h2>
<paragraph xml-lang="en-US" id="par_idN117F1" role="paragraph"><ahelp
hid="HID_FUNC_HYPERLINK">When you click a cell that contains the HYPERLINK
function, the hyperlink opens.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_idN11800" role="paragraph">If you
use the optional <emph>CellText</emph> parameter, the formula locates the URL,
and then displays the text or number.</paragraph>
+ <paragraph xml-lang="en-US" id="par_idN11800" role="paragraph">If you
use the optional <emph>CellValue</emph> parameter, the formula locates the URL,
and then displays the text or number.</paragraph>
<tip id="par_idN11803">To open a hyperlinked cell with the keyboard,
select the cell, press F2 to enter the Edit mode, move the cursor in front of
the hyperlink, press Shift+F10, and then choose <emph>Open
Hyperlink</emph>.</tip>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_idN1180E"
role="code">HYPERLINK("URL" [; "CellText"])</paragraph>
+ <paragraph xml-lang="en-US" id="par_idN1180E"
role="code">HYPERLINK("URL" [; CellValue])</paragraph>
<paragraph xml-lang="en-US" id="par_idN11811" role="paragraph">
- <emph>URL</emph> specifies the link target. The optional
<emph>CellText</emph> parameter is the text or a number that is displayed in
the cell and will be returned as the result. If the <emph>CellText</emph>
parameter is not specified, the <emph>URL</emph> is displayed in the cell text
and will be returned as the result.</paragraph>
+ <emph>URL</emph> specifies the link target. The optional
<emph>CellValue</emph> parameter is the text or a number that is displayed in
the cell and will be returned as the result. If the <emph>CellValue</emph>
parameter is not specified, the <emph>URL</emph> is displayed in the cell text
and will be returned as the result.</paragraph>
<paragraph xml-lang="en-US" id="par_id0907200912224576"
role="paragraph">The number 0 is returned for empty cells and matrix
elements.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_idN11827" role="paragraph">
