source/text/scalc/guide/cellreferences.xhp | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
New commits:
commit d35f3a21557aa82b76d41f2526783d7935615d2d
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Wed Sep 25 07:28:57 2019 +0200
Commit: Mike Kaganski <mike.kagan...@collabora.com>
CommitDate: Sat Oct 26 08:45:45 2019 +0200
Improve "Referencing Other Sheets" documentation
Change-Id: Iceb396337a189958919811206dfcfdf8510a24a7
Reviewed-on: https://gerrit.libreoffice.org/79482
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
diff --git a/source/text/scalc/guide/cellreferences.xhp
b/source/text/scalc/guide/cellreferences.xhp
index a9f352895..3d3fbaa78 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
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
