[Libreoffice-commits] help.git: source/text

[Steve Fanning (via logerrit)]

 source/text/scalc/01/04060109.xhp |    8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

New commits:
commit e42644369803fbcff1f1c487616dad5bf9f11801
Author:     Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Fri Feb 5 14:25:32 2021 +0100
Commit:     Olivier Hallot <olivier.hallot at 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.hallot at 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>