Improve "Referencing Other Sheets" documentation

Change-Id: Iceb396337a189958919811206dfcfdf8510a24a7
Reviewed-on: https://gerrit.libreoffice.org/79482
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>

1 files changed, 5 insertions, 2 deletions

diff --git a/source/text/scalc/guide/cellreferences.xhp b/source/text/scalc/guide/cellreferences.xhp
index a9f3528951..3d3fbaa780 100644
--- a/source/text/scalc/guide/cellreferences.xhp
+++ b/source/text/scalc/guide/cellreferences.xhp
@@ -39,7 +39,7 @@
       <paragraph xml-lang="en-US" id="hd_id7122409" role="heading" level="2">To Reference a Cell in the Same Document</paragraph>
       <list type="ordered">
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id2078005" role="listitem">Open a new, empty spreadsheet.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id2078005" role="listitem">Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).</paragraph>
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_id4943693" role="listitem">By way of example, enter the following formula in cell A1 of Sheet1:</paragraph>
@@ -54,6 +54,8 @@
             <paragraph xml-lang="en-US" id="par_id809961" role="listitem">If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.</paragraph>
          </listitem>
       </list>
+      <paragraph role="tip" id="par_id3147338" xml-lang="en-US">When referencing a sheet with name containing spaces, use single quotes around the name: <item type="literal">='Sheet with spaces in name'.A1</item></paragraph>
+      <paragraph role="tip" id="par_id3147383" xml-lang="en-US">The example uses Calc formula syntax. It is also possible to use Excel A1 ot R1C1 formula syntax; this is configured on <link href="text/shared/optionen/01060900.xhp">Formula options page</link>.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id9209570" role="heading" level="2">To Reference a Cell in Another Document</paragraph>
       <list type="ordered">
          <listitem>
@@ -73,12 +75,13 @@
             <paragraph xml-lang="en-US" id="par_id7697683" role="listitem">Confirm the formula by clicking the green check mark.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id7099826" role="listitem">If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a "$" sign to designate it as an absolute reference.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id7099826" role="listitem">If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a "$" sign to designate it as an <link href="text/scalc/guide/relativ_absolut_ref.xhp">absolute reference</link>.</paragraph>
          </listitem>
       </list>
       <paragraph xml-lang="en-US" id="par_id674459" role="paragraph">If you examine the name of the other document in this formula, you will notice that it is written as a <link href="text/shared/00/00000002.xhp#url" name="URL">URL</link>. This means that you can also enter a URL from the Internet.</paragraph>
       <section id="relatedtopics">
          <embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/>
+         <embed href="text/scalc/guide/relativ_absolut_ref.xhp"/>
       </section>
    </body>
 </helpdocument>
\ No newline at end of file