diff options
| author | Eike Rathke <erack@redhat.com> | 2022-01-23 23:47:24 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2022-01-23 23:57:39 +0100 |
| commit | 55e53682d9285f018385e273774a7d106a34efd4 (patch) | |
| tree | 07ec2329dd8535476c79c3b175b152af4c454f31 | |
| parent | cc64499cecf5d0695bcf9b70b75ab99013270e38 (diff) | |
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 <erack@redhat.com>
Tested-by: Jenkins
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 98b8020177..99e061ae0c 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"> |