diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-10-29 07:34:19 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-10-29 11:56:05 +0100 |
commit | 6161594437048386c4ac6013be119fbac340daad (patch) | |
tree | 27383e739a4193d4022529a0e1210410e90c1210 /source/text/scalc/guide | |
parent | ae2945ec0d27a1ba10672f8dc89c86687fbbeb9c (diff) |
Fix wrong/obsolete embeds
Change-Id: I59e5a18c403caef79b1f08a8575c310faa724f08
Reviewed-on: https://gerrit.libreoffice.org/81659
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/guide')
-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> |