diff options
Diffstat (limited to 'source/text/scalc/guide/cellreferences.xhp')
| -rw-r--r-- | source/text/scalc/guide/cellreferences.xhp | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/source/text/scalc/guide/cellreferences.xhp b/source/text/scalc/guide/cellreferences.xhp index 3d3fbaa780..e976710350 100644 --- a/source/text/scalc/guide/cellreferences.xhp +++ b/source/text/scalc/guide/cellreferences.xhp @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- * This file is part of the LibreOffice project. * @@ -18,8 +18,8 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - + + <meta> <topic id="textscalcguidecellreferencesxml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Referencing a Cell in Another Document</title> @@ -32,11 +32,11 @@ <bookmark_value>cells; operating in another document</bookmark_value> <bookmark_value>documents;references</bookmark_value> </bookmark><comment>mw made "sheet references;" a one level entry</comment><comment>MW changed "references;" and added "documents;"</comment> -<paragraph xml-lang="en-US" id="hd_id3147436" role="heading" level="1"><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp" name="Referencing Other Sheets">Referencing Other Sheets</link> -</variable></paragraph> +<h1 id="hd_id3147436"><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp" name="Referencing Other Sheets">Referencing Other Sheets</link> +</variable></h1> <paragraph xml-lang="en-US" id="par_id9663075" role="paragraph">In a sheet cell you can show a reference to a cell in another sheet.</paragraph> <paragraph xml-lang="en-US" id="par_id1879329" role="paragraph">In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file.</paragraph> - <paragraph xml-lang="en-US" id="hd_id7122409" role="heading" level="2">To Reference a Cell in the Same Document</paragraph> + <h2 id="hd_id7122409">To Reference a Cell in the Same Document</h2> <list type="ordered"> <listitem> <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> @@ -54,9 +54,9 @@ <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> + <tip id="par_id3147338">When referencing a sheet with name containing spaces, use single quotes around the name: <item type="literal">='Sheet with spaces in name'.A1</item></tip> + <tip id="par_id3147383">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>.</tip> + <h2 id="hd_id9209570">To Reference a Cell in Another Document</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id5949278" role="listitem">Choose <emph>File - Open</emph>, to load an existing spreadsheet document.</paragraph> @@ -81,7 +81,7 @@ <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"/> + <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |