update translations from weblate

Change-Id: I75a99d8d1567ffce961a404c6f054b9bd07b62a0

2 files changed, 64 insertions, 38 deletions

diff --git a/source/nb/helpcontent2/source/text/scalc/01.po b/source/nb/helpcontent2/source/text/scalc/01.po
index a6db767366c..2a93ccdab59 100644
--- a/source/nb/helpcontent2/source/text/scalc/01.po
+++ b/source/nb/helpcontent2/source/text/scalc/01.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-10-14 14:31+0200\n"
+"POT-Creation-Date: 2019-11-08 20:19+0100\n"
 "PO-Revision-Date: 2019-02-28 13:53+0000\n"
 "Last-Translator: Karl Morten Ramberg <karl.m.ramberg@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4741,14 +4741,14 @@ msgctxt ""
 msgid "<emph>SearchCriteria</emph> is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored."
 msgstr "<emph> Søkekriteria </emph> er celleområdet som inneholder søkekriterier. Hvis du skriver flere kriterier i én rad, er de forbundet med AND. Hvis du skriver kriteriene i forskjellige rader, er de forbundet med OR. Tomme celler i søkekriteriene vil bli ignorert."
 
-#. 6EVHB
+#. k58yy
 #: 04060101.xhp
 msgctxt ""
 "04060101.xhp\n"
 "par_id3151188\n"
 "help.text"
-msgid "Choose <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\">%PRODUCTNAME Calc - Calculate</link> to define how $[officename] Calc acts when searching for identical entries."
-msgstr "Velg <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Innstillinger</caseinline><defaultinline>Verktøy→ Alternativer</defaultinline></switchinline> → <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\">%PRODUCTNAME Calc → Regn ut</link> for å definere hvordan $[officename] Calc skal søke etter identiske poster."
+msgid "Choose <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> to define how $[officename] Calc acts when searching for identical entries."
+msgstr ""
 
 #. GCPCd
 #: 04060101.xhp
@@ -14461,6 +14461,15 @@ msgctxt ""
 msgid "See COUNTIF() for some more syntax examples that can be used with SUMIF()."
 msgstr "Se TELL.HVIS() for flere eksempler på syntaks som kan brukes med SUMMER.HVIS()."
 
+#. Z8TrQ
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id72921259523046\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>"
+msgstr ""
+
 #. BHGzQ
 #: 04060106.xhp
 msgctxt ""
@@ -33091,13 +33100,13 @@ msgctxt ""
 msgid "<emph>Range</emph> is the range to which the criteria are to be applied."
 msgstr ""
 
-#. PESCm
+#. HvRLc
 #: 04060181.xhp
 msgctxt ""
 "04060181.xhp\n"
 "par_id3165000\n"
 "help.text"
-msgid "<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. If regular expressions are enabled in calculation options you may also enter a search text in the form of a regular expression, e.g. b.* for all cells that begin with b. If wildcards are enabled in calculation options you may enter a search text with wildcards, e.g. b* for all cells that begin with b. You may also indicate a cell address that contains the search criterion. If you search for literal text, enclose the text in double quotes."
+msgid "<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted."
 msgstr ""
 
 #. ZpDRv
@@ -33163,6 +33172,15 @@ msgctxt ""
 msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>"
 msgstr ""
 
+#. jGBjw
+#: 04060181.xhp
+msgctxt ""
+"04060181.xhp\n"
+"hd_id224412044220134\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>"
+msgstr ""
+
 #. GWdLd
 #: 04060181.xhp
 msgctxt ""
diff --git a/source/nb/helpcontent2/source/text/scalc/guide.po b/source/nb/helpcontent2/source/text/scalc/guide.po
index e4b74c8d7e4..fdf5f58a2f2 100644
--- a/source/nb/helpcontent2/source/text/scalc/guide.po
+++ b/source/nb/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-08-07 21:08+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2410,14 +2410,14 @@ msgctxt ""
 msgid "To Reference a Cell in the Same Document"
 msgstr "Referere til en celle i et annet dokument"
 
-#. J2qBT
+#. EruAD
 #: cellreferences.xhp
 msgctxt ""
 "cellreferences.xhp\n"
 "par_id2078005\n"
 "help.text"
-msgid "Open a new, empty spreadsheet."
-msgstr "Åpne et nytt, tomt regneark."
+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 "Om du nå går tilbake til ark 1, vil du se det samme innholdet i celle A1 på dette arket også. Dersom innholdet i celle Ark2.A1 endres, vil innholdet i Ark1.A1 endre seg tilsvarande."
 
+#. 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 "Bekreft formelen ved å trykke på den grønne haken."
 
-#. 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 "Hvis du drar i håndtaket nederst til høyre i den aktive cellen og velger et celleområde, setter $[officename] automatisk inn tilsvarende referanser i nabocellene. Et resultat av dette er at et dollartegn settes foran arknavnet for å angi det som en absolutt referanse."
+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 "Lage en funksjon med %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 "Velg <item type=\"menuitem\">Verktøy → Makroer → Organiser makroer → %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 "Velg <emph>Rediger</emph>. Du får nå opp Basic-utviklingsmiljøet."
 
-#. 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 "Skriv inn funksjonskoden. I dette eksemplet lager vi en <item type=\"literal\">VOLUM(a; b; c)</item>-funksjon som beregner volumet til et rektangulært legeme med lengde<item type=\"literal\">a</item>, bredde <item type=\"literal\">b</item> og høyde <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 "Hvis du vil kopiere den selvlagde funksjonen til et Calc-dokument, gjøre følgende:"
 
-#. 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 "Velg <item type=\"menuitem\">Verktøy → Makroer → Organiser makroer → %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 "Bruke en selvlagd funksjon i $[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 "Når du har lagd funksjonen <item type=\"literal\">VOLUM(a; b; c)</item> i Basic-utviklingsmiljøet, kan du bruke det på samme måte som innebygde funksjoner i $[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 "Åpne et Calc-dokument og skriv inn tall for funksjonsparametrene <item type=\"literal\">a</item>, <item type=\"literal\">b</item> og <item type=\"literal\">c</item> i cellene A1, B1 og 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 "Plasser markøren i en annen celle og skriv inn følgende:"
 
-#. CjkGL
-#: userdefined_function.xhp
-msgctxt ""
-"userdefined_function.xhp\n"
-"par_id3155264\n"
-"help.text"
-msgid "=VOL(A1;B1;C1)"
-msgstr "=VOLUM(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 "Dette betyr at hvis du skriver inn datoen 1.1.30 eller høyere, blir det tolket som 1.1.1930 eller høyere. Alle lavere to-sifrede år blir tolket som år i det 21. århundret. For eksempel blir 1.1.20 til 1.1.2020."
-