source/text/scalc/01/04060109.xhp | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)
New commits:
commit e42644369803fbcff1f1c487616dad5bf9f11801
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Fri Feb 5 14:25:32 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Feb 5 16:58:16 2021 +0100
Clarify the Help description for Calc’s SHEET function.
Remove potential ambiguity from first sentence and provide an example of
using a string as an argument.
Affects file 04060109.xhp.
Change-Id: I3406679155b4eac512f8f64f64c8ddc930eb9048
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110441
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index c571dc97a..0e232ea29 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -300,14 +300,16 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TABELLE" id="bm_id3154693"
localize="false"/>
<h2 id="hd_id3153905">SHEET</h2>
- <paragraph xml-lang="en-US" id="par_id3150309"
role="paragraph"><ahelp hid="HID_FUNC_TABELLE">Returns the sheet number of a
reference or a string representing a sheet name.</ahelp> If you do not enter
any parameters, the result is the sheet number of the spreadsheet containing
the formula.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150309"
role="paragraph"><ahelp hid="HID_FUNC_TABELLE">Returns the sheet number of
either a reference or a string representing a sheet name.</ahelp> If you do not
enter any parameters, the result is the sheet number of the spreadsheet
containing the formula.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153095"
role="code">SHEET([Reference])</paragraph>
<paragraph xml-lang="en-US" id="par_id3154588" role="paragraph">
<emph>Reference</emph> is optional and is the reference to a cell,
an area, or a sheet name string.</paragraph>
- <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3146988" role="paragraph">
- <item type="input">=SHEET(Sheet2.A1)</item> returns 2 if Sheet2 is
the second sheet in the spreadsheet document.</paragraph>
+ <input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second
sheet in the spreadsheet document.</paragraph>
+ <paragraph role="paragraph" id="par_id491612531793751">
+ <input>=SHEET("Sheet3")</input> returns 3 if Sheet3 is the third
sheet in the spreadsheet document.</paragraph>
</section>
<section id="Section11">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148829"><bookmark_value>number of sheets; function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
