summaryrefslogtreecommitdiff
path: root/source/en-GB/helpcontent2/source/text/scalc/guide.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/en-GB/helpcontent2/source/text/scalc/guide.po')
-rw-r--r--source/en-GB/helpcontent2/source/text/scalc/guide.po72
1 files changed, 40 insertions, 32 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/guide.po b/source/en-GB/helpcontent2/source/text/scalc/guide.po
index d82fab30f60..762515ee5da 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/guide.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2019-09-30 14:01+0200\n"
+"POT-Creation-Date: 2019-11-08 19:34+0100\n"
"PO-Revision-Date: 2019-01-16 00:13+0000\n"
"Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2410,14 +2410,14 @@ msgctxt ""
msgid "To Reference a Cell in the Same Document"
msgstr "To Reference a Cell in the Same Document"
-#. J2qBT
+#. EruAD
#: cellreferences.xhp
msgctxt ""
"cellreferences.xhp\n"
"par_id2078005\n"
"help.text"
-msgid "Open a new, empty spreadsheet."
-msgstr "Open a new, empty spreadsheet."
+msgid "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)."
+msgstr ""
#. paXnm
#: cellreferences.xhp
@@ -2455,6 +2455,24 @@ msgctxt ""
msgid "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."
msgstr "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 changes."
+#. Epbaf
+#: cellreferences.xhp
+msgctxt ""
+"cellreferences.xhp\n"
+"par_id3147338\n"
+"help.text"
+msgid "When referencing a sheet with name containing spaces, use single quotes around the name: <item type=\"literal\">='Sheet with spaces in name'.A1</item>"
+msgstr ""
+
+#. 3CbGE
+#: cellreferences.xhp
+msgctxt ""
+"cellreferences.xhp\n"
+"par_id3147383\n"
+"help.text"
+msgid "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>."
+msgstr ""
+
#. mK8vG
#: cellreferences.xhp
msgctxt ""
@@ -2518,14 +2536,14 @@ msgctxt ""
msgid "Confirm the formula by clicking the green check mark."
msgstr "Confirm the formula by clicking the green tick mark."
-#. fucwJ
+#. Vp5Cb
#: cellreferences.xhp
msgctxt ""
"cellreferences.xhp\n"
"par_id7099826\n"
"help.text"
-msgid "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."
-msgstr "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."
+msgid "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>."
+msgstr ""
#. hrgGP
#: cellreferences.xhp
@@ -12400,14 +12418,14 @@ msgctxt ""
msgid "Defining A Function Using %PRODUCTNAME Basic"
msgstr "Defining A Function Using %PRODUCTNAME Basic"
-#. ZP8Ut
+#. rA6xD
#: userdefined_function.xhp
msgctxt ""
"userdefined_function.xhp\n"
"par_id3148456\n"
"help.text"
-msgid "Choose <item type=\"menuitem\">Tools - Macros - Organize Macros - %PRODUCTNAME Basic</item>."
-msgstr "Choose <item type=\"menuitem\">Tools - Macros - Organise Macros - %PRODUCTNAME Basic</item>."
+msgid "Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>."
+msgstr ""
#. 5gEUD
#: userdefined_function.xhp
@@ -12418,14 +12436,14 @@ msgctxt ""
msgid "Click the <emph>Edit</emph> button. You will now see the Basic IDE."
msgstr "Click the <emph>Edit</emph> button. You will now see the Basic IDE."
-#. C5PDD
+#. G6mwG
#: userdefined_function.xhp
msgctxt ""
"userdefined_function.xhp\n"
"par_id3150327\n"
"help.text"
-msgid "Enter the function code. In this example, we define a <item type=\"literal\">VOL(a; b; c)</item> function that calculates the volume of a rectangular solid with side lengths <item type=\"literal\">a</item>, <item type=\"literal\">b</item> and <item type=\"literal\">c</item>:"
-msgstr "Enter the function code. In this example, we define a <item type=\"literal\">VOL(a; b; c)</item> function that calculates the volume of a rectangular solid with side lengths <item type=\"literal\">a</item>, <item type=\"literal\">b</item> and <item type=\"literal\">c</item>:"
+msgid "Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:"
+msgstr ""
#. eXWo3
#: userdefined_function.xhp
@@ -12472,14 +12490,14 @@ msgctxt ""
msgid "If you want to copy the user-defined function to a Calc document:"
msgstr "If you want to copy the user-defined function to a Calc document:"
-#. WfojE
+#. 9oRKW
#: userdefined_function.xhp
msgctxt ""
"userdefined_function.xhp\n"
"par_id3150304\n"
"help.text"
-msgid "Choose <item type=\"menuitem\">Tools - Macros - Organize Macros - %PRODUCTNAME Basic</item> ."
-msgstr "Choose <item type=\"menuitem\">Tools - Macros - Organise Macros - %PRODUCTNAME Basic</item> ."
+msgid "Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>."
+msgstr ""
#. HZciB
#: userdefined_function.xhp
@@ -12544,23 +12562,23 @@ msgctxt ""
msgid "Applying a User-defined Function in $[officename] Calc"
msgstr "Applying a User-Defined Function in $[officename] Calc"
-#. qyYrE
+#. cKHUA
#: userdefined_function.xhp
msgctxt ""
"userdefined_function.xhp\n"
"par_id3148869\n"
"help.text"
-msgid "Once you have defined the function <item type=\"literal\">VOL(a; b; c)</item> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc."
-msgstr "Once you have defined the function <item type=\"literal\">VOL(a; b; c)</item> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc."
+msgid "Once you have defined the function <literal>VOL(a; b; c)</literal> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc."
+msgstr ""
-#. VRybd
+#. WtG8F
#: userdefined_function.xhp
msgctxt ""
"userdefined_function.xhp\n"
"par_id3148606\n"
"help.text"
-msgid "Open a Calc document and enter numbers for the function parameters <item type=\"literal\">a</item>, <item type=\"literal\">b</item>, and <item type=\"literal\">c</item> in cells A1, B1, and C1."
-msgstr "Open a Calc document and enter numbers for the function parameters <item type=\"literal\">a</item>, <item type=\"literal\">b</item>, and <item type=\"literal\">c</item> in cells A1, B1, and C1."
+msgid "Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1."
+msgstr ""
#. TTo2C
#: userdefined_function.xhp
@@ -12571,15 +12589,6 @@ msgctxt ""
msgid "Set the cursor in another cell and enter the following:"
msgstr "Set the cursor in another cell and enter the following:"
-#. CjkGL
-#: userdefined_function.xhp
-msgctxt ""
-"userdefined_function.xhp\n"
-"par_id3155264\n"
-"help.text"
-msgid "=VOL(A1;B1;C1)"
-msgstr "=VOL(A1;B1;C1)"
-
#. frbse
#: userdefined_function.xhp
msgctxt ""
@@ -13281,4 +13290,3 @@ msgctxt ""
"help.text"
msgid "This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020."
msgstr "This means that if you enter a date of 01/01/30 or higher, it will be converted to the internal date 1930-01-01 or higher. All lower two-digit years are converted to the 20xx century. So, for example, 01/01/20 is converted into 2020-01-01."
-