aboutsummaryrefslogtreecommitdiff
path: root/source/sl/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/sl/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/sl/helpcontent2/source/text/scalc/01.po1250
1 files changed, 801 insertions, 449 deletions
diff --git a/source/sl/helpcontent2/source/text/scalc/01.po b/source/sl/helpcontent2/source/text/scalc/01.po
index f36bcf195ad..cafafb85413 100644
--- a/source/sl/helpcontent2/source/text/scalc/01.po
+++ b/source/sl/helpcontent2/source/text/scalc/01.po
@@ -1,10 +1,10 @@
#. extracted from helpcontent2/source/text/scalc/01
msgid ""
msgstr ""
-"Project-Id-Version: LibreOffice 7.2\n"
+"Project-Id-Version: LibreOffice 7.3\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-06-11 13:43+0200\n"
-"PO-Revision-Date: 2021-06-12 09:27+0200\n"
+"POT-Creation-Date: 2021-10-15 12:35+0200\n"
+"PO-Revision-Date: 2021-10-18 21:02+0200\n"
"Last-Translator: Martin Srebotnjak <miles@filmsi.net>\n"
"Language-Team: sl.libreoffice.org\n"
"Language: sl\n"
@@ -110,8 +110,8 @@ msgctxt ""
"02110000.xhp\n"
"par_id3156422\n"
"help.text"
-msgid "<ahelp hid=\".uno:Navigator\">Activates and deactivates the Navigator.</ahelp> The Navigator is a <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link>."
-msgstr "<ahelp hid=\".uno:Navigator\">Aktivira in deaktivira Krmarja.</ahelp> Krmar <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"plavajoče okno\">plavajoče okno</link>."
+msgid "<ahelp hid=\".uno:Navigator\">Activates and deactivates the Navigator.</ahelp> The Navigator is a <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">dockable window</link>."
+msgstr "<ahelp hid=\".uno:Navigator\">Aktivira in deaktivira Krmarja.</ahelp> Krmar <link href=\"text/shared/00/00000005.xhp#docking\" name=\"plavajoče okno\">plavajoče okno</link>."
#: 02110000.xhp
msgctxt ""
@@ -7366,8 +7366,8 @@ msgctxt ""
"04060104.xhp\n"
"par_id9841608\n"
"help.text"
-msgid "The type of the operating system. <br/>\"WNT\" for Microsoft Windows <br/>\"LINUX\" for Linux <br/>\"MACOSX\" for macOS<br/>\"SOLARIS\" for Solaris"
-msgstr "Vrsta operacijskega sistema.<br/>»WNT« za Microsoft Windows<br/>»LINUX« za Linux <br/>»MACOSX« za macOS<br/>»SOLARIS« za Solaris"
+msgid "The type of the operating system: <br/>\"AIX\" for Advanced Interactive Executive IBM computer operating systems<br/>\"ANDROID\" for Google mobile operating system<br/>\"DRAGONFLY\" for DragonFly operating system forked from FreeBSD<br/>\"EMSCRIPTEM\" for browser WebAssembly system<br/>\"FREEBSD\", \"OPENBSD\" or \"NETBSD\" for operating systems based on the Berkeley Software Distribution (BSD)<br/>\"HAIKU\" for BeOS compatible operating system<br/>\"iOS\" for Apple mobile operating system <br/>\"LINUX\" for GNU/Linux based operating systems<br/>\"MACOSX\" for Apple Mac OS X<br/>\"SOLARIS\" for Oracle Solaris operating system<br/>\"WNT\" for Microsoft Windows"
+msgstr "Vrsta operacijskega sistema: <br/>»AIX« za računalniške operacijske sisteme Advanced Interactive Executive podjetja IBM;<br/>»ANDROID« za operacijski sistem za mobilne naprave podjetja Google;<br/>»DRAGONFLY« za operacijski sistem DragonFly, razvit iz FreeBSD;<br/>»EMSCRIPTEM« za brskalniški sistem WebAssembly;<br/>»FREEBSD«, »OPENBSD« ali »NETBSD« za operacijske sisteme na osnovi BSD (Berkeley Software Distribution);<br/>»HAIKU« za operacijski sistem, združljiv z BeOS;<br/>»iOS« za operacijski sistem za mobilne naprave podjetja Apple;<br/>»LINUX« za operacijske sisteme na osnovi GNU/Linux;<br/>»MACOSX« za Mac OS X podjetja Apple;<br/>»SOLARIS« za operacijski sistem Solaris podjetja Oracle;<br/>»WNT« za Microsoft Windows."
#: 04060104.xhp
msgctxt ""
@@ -13278,31 +13278,71 @@ msgctxt ""
"04060106.xhp\n"
"par_id0908200902131122\n"
"help.text"
-msgid "<ahelp hid=\".\">Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.</ahelp>"
-msgstr "<ahelp hid=\".\">Pretvori vrednost iz enih merskih enot v druge. Faktorji pretvorbe so podani v seznamu nastavitev.</ahelp>"
+msgid "<ahelp hid=\".\">Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa.</ahelp> The conversion uses the fixed exchange rates at which the legacy currencies entered the euro."
+msgstr "<ahelp hid=\".\">V evre pretvori vrednost iz ene od opuščenih valut članic monetarne unije Evropske unije in obratno.</ahelp> Pretvorba uporablja fiksen menjalni tečaj, določen ob prehodu na evro."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id0908200902475420\n"
+"par_id581631900947319\n"
"help.text"
-msgid "At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies."
-msgstr "Nekoč je ta seznam faktorjev pretvorbe vključevala nekdanje evropske valute in evro (glejte spodnje primere). Če želite pretvoriti te valute, predlagamo uporabo nove funkcije EUROCONVERT."
+msgid "We recommend using the more flexible EUROCONVERT function for converting between these currencies. For converting between many different units of measure, use the CONVERT function."
+msgstr "Za pretvorbo met temi valutami priporočamo rabo bolj prilagodljive funkcije EUROCONVERT. Za pretvorbo med različnimi merskimi enotami pa uporabite funkcijo CONVERT."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902131191\n"
"help.text"
-msgid "CONVERT_OOO(value; \"text\"; \"text\")"
-msgstr "CONVERT_OOO(vrednost; \"besedilo\"; \"besedilo\")"
+msgid "CONVERT_OOO(Value; \"Text1\"; \"Text2\")"
+msgstr "CONVERT_OOO(vrednost; \"besedilo1\"; \"besedilo2\")"
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id901631901062056\n"
+"help.text"
+msgid "<emph>Value</emph> is the amount of the currency to be converted."
+msgstr "<emph>Vrednost</emph> je količina denarnih enot valute za pretvorbo."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id461631901137229\n"
+"help.text"
+msgid "<emph>Text1</emph> is a three-character string that specifies the currency to be converted from."
+msgstr "<emph>Besedilo1</emph> je tri znakovni niz, ki določa valuto, iz katere želite izvesti pretvorbo."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id351631901218862\n"
+"help.text"
+msgid "<emph>Text2</emph> is a three-character string that specifies the currency to be converted to."
+msgstr "<emph>Besedilo2</emph> je tri znakovni niz, ki določa valuto, v katero želite izvesti pretvorbo."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id1001631901312606\n"
+"help.text"
+msgid "<emph>Text1</emph> and <emph>Text2</emph> must each take one of the following values: \"ATS\", \"BEF\", \"CYP\", \"DEM\", \"EEK\", \"ESP\", \"EUR\", \"FIM\", \"FRF\", \"GRD\", \"IEP\", \"ITL\", \"LTL\", \"LUF\", \"LVL\", \"MTL\", \"NLG\", \"PTE\", \"SIT\", and \"SKK\"."
+msgstr "<emph>Besedilo1</emph> in <emph>besedilo2</emph> morata imeti eno od naslednjih vrednosti: \"ATS\", \"BEF\", \"CYP\", \"DEM\", \"EEK\", \"ESP\", \"EUR\", \"FIM\", \"FRF\", \"GRD\", \"IEP\", \"ITL\", \"LTL\", \"LUF\", \"LVL\", \"MTL\", \"NLG\", \"PTE\", \"SIT\" in \"SKK\"."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id111631901383901\n"
+"help.text"
+msgid "One, and only one, of <emph>Text1</emph> or <emph>Text2</emph> must be equal to \"EUR\"."
+msgstr "Natanko eden od parametrov, <emph>besedilo1</emph> ali <emph>besedilo2</emph> mora imeti vrednost \"EUR\"."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id090820090213112\n"
"help.text"
-msgid "<item type=\"input\">=CONVERT_OOO(100;\"ATS\";\"EUR\")</item> returns the Euro value of 100 Austrian Schillings."
+msgid "<item type=\"input\">=CONVERT_OOO(100;\"ATS\";\"EUR\")</item> returns the euro value of 100 Austrian schillings."
msgstr "<item type=\"input\">=CONVERT_OOO(100;\"SIT\";\"EUR\")</item> pretvori 100 slovenskih tolarjev v evre."
#: 04060106.xhp
@@ -13310,8 +13350,16 @@ msgctxt ""
"04060106.xhp\n"
"par_id0908200902475431\n"
"help.text"
-msgid "=CONVERT_OOO(100;\"EUR\";\"DEM\") converts 100 Euros into German Marks."
-msgstr "=CONVERT_OOO(100;\"EUR\";\"DEM\") pretvori 100 evrov v nemške marke."
+msgid "<input>=CONVERT_OOO(100;\"EUR\";\"DEM\")</input> converts 100 euros into German marks."
+msgstr "<input>=CONVERT_OOO(100;\"EUR\";\"DEM\")</input> pretvori 100 evrov v nemške marke."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id251631901851101\n"
+"help.text"
+msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT_OOO\" name=\"CONVERT_OOO Wiki\">CONVERT_OOO</link> wiki page for more details about this function."
+msgstr "Za podrobnosti o tej funkciji glejte <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT_OOO\" name=\"Wiki stran o funkciji CONVERT_OOO\">strani wiki o funkciji CONVERT_OOO</link> (v angl.)."
#: 04060106.xhp
msgctxt ""
@@ -13886,7 +13934,7 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3147273\n"
"help.text"
-msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>"
+msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>deleting; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>"
msgstr "<bookmark_value>matrike; funkcije</bookmark_value><bookmark_value>čarovnik za funkcije; polja</bookmark_value><bookmark_value>matrične formule</bookmark_value><bookmark_value>matrične konstante</bookmark_value> <bookmark_value>formule; polja</bookmark_value><bookmark_value>funkcije; funkcije polj</bookmark_value><bookmark_value>funkcije; funkcije matrik</bookmark_value><bookmark_value>urejanje; formule za polja</bookmark_value><bookmark_value>kopiranje; formule za polja</bookmark_value><bookmark_value>prilagajanje obsegov polj</bookmark_value><bookmark_value>računanje; pogojni izračuni</bookmark_value><bookmark_value>matrike; izračuni</bookmark_value><bookmark_value>pogojni izračuni s polji</bookmark_value><bookmark_value>implicitno rokovanje s polji</bookmark_value><bookmark_value>vsiljeno rokovanje s polji</bookmark_value>"
#: 04060107.xhp
@@ -14054,8 +14102,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3154342\n"
"help.text"
-msgid "The cells in a results array are automatically protected against changes. However, you can edit or copy the array formula by selecting the entire array cell range."
-msgstr "Celice v rezultatu matrike so samodejno zavarovane pred spremembami. Lahko pa urejate ali kopirate matrično formulo s tem, da izberete ves obseg celic matrike, torej celo matriko."
+msgid "The cells in a results array are automatically protected against changes. However, you can edit, delete or copy the array formula by selecting the entire array cell range."
+msgstr "Celice v matriki rezultatov so samodejno zavarovane pred spremembami. Lahko pa urejate, brišete ali kopirate matrično formulo s tem, da izberete ves obseg celic matrike, torej celo matriko."
#: 04060107.xhp
msgctxt ""
@@ -14190,8 +14238,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3149241\n"
"help.text"
-msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + /</emph>, where <emph>/</emph> is the <emph>Division</emph> key on the numeric keypad."
-msgstr "Označite obseg celic ali matriko, ki vsebuje matrično formulo. Za izbor cele matrike postavite celično kazalko v območje matrike, pritisnite tipke <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Cmd</emph></caseinline><defaultinline><emph>krmilka</emph></defaultinline></switchinline><emph>+/</emph>, kjer je <emph>/</emph> tipka <emph>Deljenje</emph> na numerični tipkovnici."
+msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad."
+msgstr "Označite obseg celic ali matriko, ki vsebuje matrično formulo. Za izbor cele matrike postavite celično kazalko v območje matrike, pritisnite tipke <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Cmd</keycode></caseinline><defaultinline><keycode>krmilka</keycode></defaultinline></switchinline><keycode>+/</keycode>, kjer je <keycode>/</keycode> tipka za deljenje na numerični tipkovnici."
#: 04060107.xhp
msgctxt ""
@@ -14220,6 +14268,30 @@ msgstr "Oblikujete lahko tudi posamezne dele matrike. Lahko npr. spremenite barv
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
+"hd_id541633516074226\n"
+"help.text"
+msgid "Deleting Array Formulae"
+msgstr "Brisanje matričnih formul"
+
+#: 04060107.xhp
+msgctxt ""
+"04060107.xhp\n"
+"par_id681633516103267\n"
+"help.text"
+msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad."
+msgstr "Označite obseg celic ali matriko, ki vsebuje matrično formulo. Za izbor cele matrike postavite celično kazalko v območje matrike, pritisnite tipke <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Cmd</keycode></caseinline><defaultinline><keycode>krmilka</keycode></defaultinline></switchinline><keycode>+/</keycode>, kjer je <keycode>/</keycode> tipka za deljenje na numerični tipkovnici."
+
+#: 04060107.xhp
+msgctxt ""
+"04060107.xhp\n"
+"par_id61633516164519\n"
+"help.text"
+msgid "Press <keycode>Delete</keycode> to delete the array contents, including the array formula, or press <keycode>Backspace</keycode> and this brings up the <link href=\"text/scalc/01/02150000.xhp\" name=\"delete contents\">Delete Contents</link> dialog box. Select <emph>Formula</emph> or <emph>Delete All</emph> and click <emph>OK</emph>."
+msgstr "Pritisnite <keycode>brisalko</keycode>, da izbrišete vsebino matrike oz. polja, vključno z matrično formulo, ali pritisnite <keycode>vračalko</keycode>, s čimer prikličete pogovorno okno <link href=\"text/scalc/01/02150000.xhp\" name=\"Izbriši vsebino\">Izbriši vsebino</link>. Izberite <emph>Formula</emph> ali <emph>Izbriši vse</emph> ter kliknite <emph>V redu</emph>."
+
+#: 04060107.xhp
+msgctxt ""
+"04060107.xhp\n"
"hd_id3145608\n"
"help.text"
msgid "Copying Array Formulas"
@@ -16902,7 +16974,7 @@ msgctxt ""
"04060109.xhp\n"
"par_id3147528\n"
"help.text"
-msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. This applies even when the search array is not sorted. For Type = -1, the first value that is larger or equal is returned."
+msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the first value that is larger or equal is returned."
msgstr "Če vnesemo vrsta = 1 ali če tretji parameter izpustimo, funkcija vrne zadnjo vrednost, ki je manjša ali enaka iskalnemu pogoju. To velja tudi, če iskalna matrika ni razvrščena. Če je vrsta = -1, funkcija vrne prvo vrednost, ki je večja ali enaka."
#: 04060109.xhp
@@ -17908,6 +17980,70 @@ msgstr "<variable id=\"texttext\">To poglavje vsebuje opise funkcij za <emph>bes
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
+"bm_id331624453577057\n"
+"help.text"
+msgid "<bookmark_value>using double quotation marks in formulas</bookmark_value> <bookmark_value>formulas; using double quotation marks</bookmark_value>"
+msgstr "<bookmark_value>dvojni narekovaji v formulah</bookmark_value><bookmark_value>formule; raba dvojnih narekovajev v formulah</bookmark_value>"
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"hd_id291624454173529\n"
+"help.text"
+msgid "Using double quotation marks in formulas"
+msgstr "Raba dvojnih narekovajev v formulah"
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id891624454058773\n"
+"help.text"
+msgid "To include a text string in a formula, place the text string between two double quotation marks (\") and Calc takes the characters in the string without attempting to interpret them. For example, the formula <input>=\"Hello world!\"</input> displays the text string <literal>Hello world!</literal> in the cell, with no surrounding double quotation marks."
+msgstr "Če želite v formulo vključiti besedilni niz, ga postavite med dva dvojna narekovaja (\") in Calc povzame znake v nizu brez interpretacije. Primer: formula <input>=\"Žive naj vsi narodi!\"</input> prikaže besedilni niz <literal>Žive naj vsi narodi!</literal> v celici brez obkrožajočih dvojnih narekovajev."
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id461624454425320\n"
+"help.text"
+msgid "The more complex formula <input>=CONCATENATE(\"Life is really simple, \"; \"but we insist on making it complicated \"; \"(Confucius).\")</input> concatenates three individual strings in double quotation marks, outputting <literal>Life is really simple, but we insist on making it complicated (Confucius).</literal>"
+msgstr "Kompleksnejša formula <input>=CONCATENATE(\"Življenje je resnično enostavno, \"; \"vendar vztrajamo, da ga naredimo zapletenega \"; \"(Konfucij).\")</input> spoji tri posamezne nize v narekovajih, tako da vrne <literal>Življenje je resnično enostavno, vendar vztrajamo, da ga naredimo zapletenega (Konfucij).</literal>"
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id711624454477483\n"
+"help.text"
+msgid "To place a literal double quotation mark within a string inside a formula, two methods can be used:"
+msgstr "Če želite v niz v formuli vstaviti dvojni narekovaj, sta na voljo dva načina:"
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id541624454496424\n"
+"help.text"
+msgid "You can \"escape\" the double quotation mark with an additional double quotation mark, and Calc treats the escaped double quotation mark as a literal value. For example, the formula <input>=\"My name is \"\"John Doe\"\".\"</input> outputs the string <literal>My name is \"John Doe\".</literal> Another simple example is the formula <input>=UNICODE(\"\"\"\")</input> which returns <literal>34</literal>, the decimal value of the Unicode quotation mark character (U+0022) — here the first and fourth double quotation marks indicate the beginning and end of the string, while the second double quotation mark escapes the third."
+msgstr "Dvojni narekovaj lahko podate z ubežnimi znaki, tako da dodate dvojni narekovaj, Calc pa obravnava takšen ubežen narekovaj kot dobesedno vrednost. Primer: formula <input>=\"Ime mi je \"\"Janez Novak\"\".\"</input> vrne niz <literal>Ime mi je \"Janez Novak\".</literal> Še en enostaven primer: formula <input>=UNICODE(\"\"\"\")</input>, ki vrne <literal>34</literal>, desetiško vrednost znaka Unicode za narekovaj (U+0022) — tukaj prvi in četrti dvojni narekovaj nakazujeta začetek in konec niza, drugi dvojni narekovaj pa ubeži tretjega."
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id21624454513641\n"
+"help.text"
+msgid "You can use the CHAR function or the UNICHAR function to insert a double quotation mark. For example, the formula <input>=UNICHAR(34) & \"The Catcher in the Rye\" & UNICHAR(34) & \" is a famous book by J. D. Salinger.\"</input> displays the string <literal>\"The Catcher in the Rye\" is a famous book by J. D. Salinger.</literal>"
+msgstr "Uporabite lahko funkcijo CHAR ali funkcijo UNICHAR, da vstavite dvojni narekov. Primer: formula <input>=UNICHAR(34) & \"Varuh v rži\" & UNICHAR(34) & \" je sloviti roman J. D. Salingerja.\"</input> izpiše niz <literal>\"Varuh v rži\" je sloviti roman J. D. Salingerja.</literal>"
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id401624454547945\n"
+"help.text"
+msgid "Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature."
+msgstr "Bodite pozorni, saj lahko funkcija Samopopravki modula Calc dvojne narekovaje spremeni. Samopopravki ne smejo spreminjati dvojnih narekovajev v celicah, lahko pa spremenijo tiste, uporabljene v celicah brez formul, ki vsebujejo besedilo. Primer: če kopirate niz, ki ga obkroža druga tipografska vrsta dvojnih narekovajev, kot sta npr. levi dvojni narekovaj (U+201C) in desni dvojni narekovaj (U+201D), in ga nato prilepite v celico s formulo, lahko pride do napake. Odprite področje <emph>Dvojni narekovaji</emph> v pogovornem oknu <menuitem>Orodja — Možnosti samopopravkov — Posebnosti jezika</menuitem>, da določite znake, ki bodo samodejno popravili začetne in končne tipografske dvojne narekovaje. Prekličite potrditev možnosti <menuitem>Zamenjaj</menuitem>, da onemogočite to funkcijo."
+
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
"bm_id3149384\n"
"help.text"
msgid "<bookmark_value>ARABIC function</bookmark_value>"
@@ -18086,8 +18222,8 @@ msgctxt ""
"04060110.xhp\n"
"par_id3153289\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"numbering system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used."
-msgstr "<ahelp hid=\"HID_FUNC_BASIS\">Pretvori pozitivno celo število v besedilo <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"številski sistem\">številskega sistema</link> na določeni osnovi.</ahelp> Uporabljajo se števila od 0-9 in črke od A-Z."
+msgid "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#number_system\" name=\"numbering system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used."
+msgstr "<ahelp hid=\"HID_FUNC_BASIS\">Pretvori pozitivno celo število v besedilo <link href=\"text/shared/00/00000005.xhp#number_system\" name=\"številski sistem\">številskega sistema</link> na določeni osnovi.</ahelp> Uporabljajo se števila od 0-9 in črke od A-Z."
#: 04060110.xhp
msgctxt ""
@@ -18398,8 +18534,8 @@ msgctxt ""
"04060110.xhp\n"
"par_id3156361\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DEZIMAL\">Converts text with characters from a <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"number system\">number system</link> to a positive integer in the base radix given.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs are ignored. The <emph>Text</emph> field is not case-sensitive."
-msgstr "<ahelp hid=\"HID_FUNC_DEZIMAL\">Pretvori besedilo z znaki iz izbranega <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"številski sistem\">številskega sistema</link> v pozitivno celo število na določeni osnovi.</ahelp> Vrednost korena mora biti med 2 in 36. Presledki in tabulatorji se ne upoštevajo. <emph>Besedilno</emph> polje ne loči malih in velikih črk."
+msgid "<ahelp hid=\"HID_FUNC_DEZIMAL\">Converts text with characters from a <link href=\"text/shared/00/00000005.xhp#number_system\" name=\"number system\">number system</link> to a positive integer in the base radix given.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs are ignored. The <emph>Text</emph> field is not case-sensitive."
+msgstr "<ahelp hid=\"HID_FUNC_DEZIMAL\">Pretvori besedilo z znaki iz izbranega <link href=\"text/shared/00/00000005.xhp#number_system\" name=\"številski sistem\">številskega sistema</link> v pozitivno celo število na določeni osnovi.</ahelp> Vrednost korena mora biti med 2 in 36. Presledki in tabulatorji se ne upoštevajo. <emph>Besedilno</emph> polje ne loči malih in velikih črk."
#: 04060110.xhp
msgctxt ""
@@ -18918,40 +19054,40 @@ msgctxt ""
"04060110.xhp\n"
"par_id2949141\n"
"help.text"
-msgid "<item type=\"input\">LEFTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)."
-msgstr "<item type=\"input\">LEFTB(\"中国\";1)</item> vrne » « (1 bajt je le pol znaka DBCS, zato funkcija vrne znak za presledek)."
+msgid "<item type=\"input\">=LEFTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)."
+msgstr "<item type=\"input\">=LEFTB(\"中国\";1)</item> vrne » « (1 bajt je le pol znaka DBCS, zato funkcija vrne znak za presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2949151\n"
"help.text"
-msgid "<item type=\"input\">LEFTB(\"中国\";2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)."
-msgstr "<item type=\"input\">LEFTB(\"中国\";2)</item> vrne »中« (2 bajta tvorita celovit znak DBCS)."
+msgid "<item type=\"input\">=LEFTB(\"中国\";2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)."
+msgstr "<item type=\"input\">=LEFTB(\"中国\";2)</item> vrne »中« (2 bajta tvorita celovit znak DBCS)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2949161\n"
"help.text"
-msgid "<item type=\"input\">LEFTB(\"中国\";3)</item> returns \"中 \" (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character)."
-msgstr "<item type=\"input\">LEFTB(\"中国\";3)</item> vrne »中 « (3 bajti tvorijo en znak DBCS in pol, zato je zadnji vrnjeni znak presledek)."
+msgid "<item type=\"input\">=LEFTB(\"中国\";3)</item> returns \"中 \" (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character)."
+msgstr "<item type=\"input\">=LEFTB(\"中国\";3)</item> vrne »中 « (3 bajti tvorijo en znak DBCS in pol, zato je zadnji vrnjeni znak presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2949171\n"
"help.text"
-msgid "<item type=\"input\">LEFTB(\"中国\";4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)."
-msgstr "<item type=\"input\">LEFTB(\"中国\";4)</item> vrne »中国« (4 bajti tvorijo dva celovita znaka DBCS)."
+msgid "<item type=\"input\">=LEFTB(\"中国\";4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)."
+msgstr "<item type=\"input\">=LEFTB(\"中国\";4)</item> vrne »中国« (4 bajti tvorijo dva celovita znaka DBCS)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2949181\n"
"help.text"
-msgid "<item type=\"input\">LEFTB(\"office\";3)</item> returns \"off\" (3 non-DBCS characters each consisting of 1 byte)."
-msgstr "<item type=\"input\">LEFTB(\"pisarna\";3)</item> vrne »pis« (3 znaki, ki niso znaki DBCS, vsak dolžine 1 bajt)."
+msgid "<item type=\"input\">=LEFTB(\"office\";3)</item> returns \"off\" (3 non-DBCS characters each consisting of 1 byte)."
+msgstr "<item type=\"input\">=LEFTB(\"pisarna\";3)</item> vrne »pis« (3 znaki, ki niso znaki DBCS, vsak dolžine 1 bajt)."
#: 04060110.xhp
msgctxt ""
@@ -19262,88 +19398,88 @@ msgctxt ""
"04060110.xhp\n"
"par_id2958417\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";1;0)</item> returns \"\" (0 bytes is always an empty string)."
-msgstr "<item type=\"input\">MIDB(\"中国\";1;0)</item> vrne »« (0 bajtov je vedno prazen niz)."
+msgid "<item type=\"input\">=MIDB(\"中国\";1;0)</item> returns \"\" (0 bytes is always an empty string)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";1;0)</item> vrne »« (0 bajtov je vedno prazen niz)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958427\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";1;1)</item> returns \" \" (1 byte is only half a DBCS character and therefore the result is a space character)."
-msgstr "<item type=\"input\">MIDB(\"中国\";1;1)</item> vrne » « (1 bajt predstavlja le polovico znaka DBCS, zato je rezultat znak za presledek)."
+msgid "<item type=\"input\">=MIDB(\"中国\";1;1)</item> returns \" \" (1 byte is only half a DBCS character and therefore the result is a space character)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";1;1)</item> vrne » « (1 bajt predstavlja le polovico znaka DBCS, zato je rezultat znak za presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958437\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";1;2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)."
-msgstr "<item type=\"input\">MIDB(\"中国\";1;2)</item> vrne »中« (2 bajta tvorita en celovit znak DBCS)."
+msgid "<item type=\"input\">=MIDB(\"中国\";1;2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";1;2)</item> vrne »中« (2 bajta tvorita en celovit znak DBCS)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958447\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";1;3)</item> returns \"中 \" (3 bytes constitute one and a half DBCS character; the last byte results in a space character)."
-msgstr "<item type=\"input\">MIDB(\"中国\";1;3)</item> vrne »中 « (3 bajti tvorijo en znak DBCS in pol, zato zadnji bajt vrne presledek)."
+msgid "<item type=\"input\">=MIDB(\"中国\";1;3)</item> returns \"中 \" (3 bytes constitute one and a half DBCS character; the last byte results in a space character)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";1;3)</item> vrne »中 « (3 bajti tvorijo en znak DBCS in pol, zato zadnji bajt vrne presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958457\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";1;4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)."
-msgstr "<item type=\"input\">MIDB(\"中国\";1;4)</item> vrne »中国« (4 bajti tvorijo dva celovita znaka DBCS)."
+msgid "<item type=\"input\">=MIDB(\"中国\";1;4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";1;4)</item> vrne »中国« (4 bajti tvorijo dva celovita znaka DBCS)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958467\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";2;1)</item> returns \" \" (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned)."
-msgstr "<item type=\"input\">MIDB(\"中国\";2;1)</item> vrne » « (bajt na položaju 2 ni na začetku znaka v nizu DBCS; vrnjen je 1 znak za presledek)."
+msgid "<item type=\"input\">=MIDB(\"中国\";2;1)</item> returns \" \" (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";2;1)</item> vrne » « (bajt na položaju 2 ni na začetku znaka v nizu DBCS; vrnjen je 1 znak za presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958477\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";2;2)</item> returns \" \" (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned)."
-msgstr "<item type=\"input\">MIDB(\"中国\";2;2)</item> vrne » « (bajt na položaju 2 kaže na drugo polovico prvega znaka v nizu DBCS; iskana 2 bajta zato tvorita drugo polovico prvega znaka in prvo polovico drugega znaka v nizu; zato funkcija vrne 2 znaka za presledek)."
+msgid "<item type=\"input\">=MIDB(\"中国\";2;2)</item> returns \" \" (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";2;2)</item> vrne » « (bajt na položaju 2 kaže na drugo polovico prvega znaka v nizu DBCS; iskana 2 bajta zato tvorita drugo polovico prvega znaka in prvo polovico drugega znaka v nizu; zato funkcija vrne 2 znaka za presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958487\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";2;3)</item> returns \" 国\" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2)."
-msgstr "<item type=\"input\">MIDB(\"中国\";2;3)</item> vrne » 国« (bajt na položaju 2 ni na začetku znaka v nizu DBCS; za bajt na položaju 2 vrne znak za presledek)."
+msgid "<item type=\"input\">=MIDB(\"中国\";2;3)</item> returns \" 国\" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";2;3)</item> vrne » 国« (bajt na položaju 2 ni na začetku znaka v nizu DBCS; za bajt na položaju 2 vrne znak za presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958497\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";3;1)</item> returns \" \" (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead)."
-msgstr "<item type=\"input\">MIDB(\"中国\";3;1)</item> vrne » « (bajt na položaju 3 je na začetku znaka v nizu DBCS, toda 1 bajt dolžine je le pol znaka DBCS, zato vrne znak za presledek)."
+msgid "<item type=\"input\">=MIDB(\"中国\";3;1)</item> returns \" \" (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";3;1)</item> vrne » « (bajt na položaju 3 je na začetku znaka v nizu DBCS, toda 1 bajt dolžine je le pol znaka DBCS, zato vrne znak za presledek)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958507\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"中国\";3;2)</item> returns \"国\" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character)."
-msgstr "<item type=\"input\">MIDB(\"中国\";3;2)</item> vrne »国« (bajt na položaju 3 je na začetku znaka v nizu DBCS; 2 bajta tvorita en znak DBCS)."
+msgid "<item type=\"input\">=MIDB(\"中国\";3;2)</item> returns \"国\" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character)."
+msgstr "<item type=\"input\">=MIDB(\"中国\";3;2)</item> vrne »国« (bajt na položaju 3 je na začetku znaka v nizu DBCS; 2 bajta tvorita en znak DBCS)."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id2958517\n"
"help.text"
-msgid "<item type=\"input\">MIDB(\"office\";2;3)</item> returns \"ffi\" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters)."
-msgstr "<item type=\"input\">MIDB(\"pisarna\";2;3)</item> vrne »isa« (bajt na položaju 2 je na začetku znaka v nizu, ki ni niz DBCS, tako 3 bajti takšnega niza tvorijo 3 znake)."
+msgid "<item type=\"input\">=MIDB(\"office\";2;3)</item> returns \"ffi\" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters)."
+msgstr "<item type=\"input\">=MIDB(\"pisarna\";2;3)</item> vrne »isa« (bajt na položaju 2 je na začetku znaka v nizu, ki ni niz DBCS, tako 3 bajti takšnega niza tvorijo 3 znake)."
#: 04060110.xhp
msgctxt ""
@@ -19524,18 +19660,18 @@ msgstr "<emph>Število</emph> je število ponovitev."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
-"par_id3149922\n"
+"par_id3148626\n"
"help.text"
-msgid "The result can be a maximum of 255 characters."
-msgstr "Rezultat lahko obsega največ 255 znakov."
+msgid "<item type=\"input\">=REPT(\"Good morning\";2)</item> returns Good morningGood morning."
+msgstr "<item type=\"input\">=REPT(\"Dobro jutro\";2)</item> vrne Dobro jutroDobro jutro."
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
-"par_id3148626\n"
+"par_id381626381556310\n"
"help.text"
-msgid "<item type=\"input\">=REPT(\"Good morning\";2)</item> returns Good morningGood morning."
-msgstr "<item type=\"input\">=REPT(\"Dobro jutro\";2)</item> vrne Dobro jutroDobro jutro."
+msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT\" name=\"REPT_Wiki\">REPT</link> wiki page for more details about this function."
+msgstr "Za podrobnosti o tej funkciji glejte <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT\" name=\"Stran wiki o funkciji REPT\">stran wiki o funkciji REPT</link> (v angl.)."
#: 04060110.xhp
msgctxt ""
@@ -19582,8 +19718,8 @@ msgctxt ""
"04060110.xhp\n"
"par_id3153350\n"
"help.text"
-msgid "<emph>Number</emph> (optional) is the number of characters from the right part of the text."
-msgstr "<emph>Število</emph> (neobvezno) je število znakov z desnega konca besedila."
+msgid "<emph>Number</emph> (optional) is the number of characters from the right part of the text. If this parameter is not defined, one character is returned."
+msgstr "<emph>Število</emph> (neobvezno) je število znakov od desnega konca besedila. Če tega parametra ne določite, funkcija vrne en znak."
#: 04060110.xhp
msgctxt ""
@@ -19638,8 +19774,8 @@ msgctxt ""
"04060110.xhp\n"
"par_id2953350\n"
"help.text"
-msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes."
-msgstr "<emph>Število_bajtov</emph> (neobvezno) je število vrnjenih znakov z desnega konca besedila, glede na bajte."
+msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes. If this parameter is not defined, one byte is returned."
+msgstr "<emph>Število_bajtov</emph> (neobvezno) določi število znakov, ki jih želite izluščiti s funkcijo RIGHTB, glede na bajte. Če tega parametra ne določite, vrne en bajt."
#: 04060110.xhp
msgctxt ""
@@ -20249,54 +20385,6 @@ msgctxt ""
msgid "<item type=\"input\">=UPPER(\"Good Morning\")</item> returns GOOD MORNING."
msgstr "<item type=\"input\">=UPPER(\"Dober večer\")</item> vrne DOBER VEČER."
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"bm_id3150802\n"
-"help.text"
-msgid "<bookmark_value>VALUE function</bookmark_value>"
-msgstr "<bookmark_value>funkcija VALUE</bookmark_value>"
-
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"hd_id3150802\n"
-"help.text"
-msgid "VALUE"
-msgstr "VALUE"
-
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id3152551\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_WERT\">Converts a text string into a number.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_WERT\">Besedilni niz spremeni v število.</ahelp>"
-
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id3153638\n"
-"help.text"
-msgid "VALUE(\"Text\")"
-msgstr "VALUE(\"besedilo\")"
-
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id3153651\n"
-"help.text"
-msgid "<emph>Text</emph> is the text to be converted to a number."
-msgstr "<emph>Besedilo</emph> je besedilo, ki bo pretvorjeno v število."
-
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id3144733\n"
-"help.text"
-msgid "<item type=\"input\">=VALUE(\"4321\")</item> returns 4321."
-msgstr "<item type=\"input\">=VALUE(\"4321\")</item> vrne 4321."
-
#: 04060111.xhp
msgctxt ""
"04060111.xhp\n"
@@ -20596,6 +20684,22 @@ msgstr "<emph>Besedilo</emph> je niz znakov, ki ga želite šifrirati. ROT13(ROT
#: 04060111.xhp
msgctxt ""
"04060111.xhp\n"
+"par_id151626469224135\n"
+"help.text"
+msgid "<input>=ROT13(\"Gur Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.\")</input> returns the string \"The Document Foundation was founded in September 2010.\". Notice how spaces, digits, and full stops are unaffected by ROT13."
+msgstr "<input>=ROT13(\"Gur Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.\")</input> vrne niz »The Document Foundation was founded in September 2010.«. Vidite lahko, da funkcija ROT13 ne vpliva na presledke, števke in pike."
+
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id221626469509161\n"
+"help.text"
+msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13\" name=\"ROT13_Wiki\">ROT13</link> wiki page for more details about this function."
+msgstr "Za podrobnosti o tej funkciji glejte <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13\" name=\"Stran wiki o funkciji ROT13\">stran wiki o funkciji ROT13</link> (v angl.)."
+
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
"bm_id3151300\n"
"help.text"
msgid "<bookmark_value>DAYSINYEAR function</bookmark_value><bookmark_value>number of days; in a specific year</bookmark_value>"
@@ -34070,48 +34174,56 @@ msgctxt ""
"04060184.xhp\n"
"par_id3150254\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_PHI\">Returns the values of the distribution function for a standard normal distribution.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_PHI\">Vrne vrednosti funkcije porazdelitve za standardno normalno porazdelitev.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_PHI\">Returns the value of the probability density function for a given value considering the standard normal distribution.</ahelp>"
+msgstr "<ahelp hid=\"HID_FUNC_PHI\">Vrne vrednosti funkcije gostote porazdelitve za standardno normalno porazdelitev.</ahelp>"
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
-"par_id3149976\n"
+"par_id151629986285891\n"
"help.text"
-msgid "PHI(Number)"
-msgstr "PHI(Število)"
+msgid "<input>PHI(Number)</input>"
+msgstr "<input>PHI(število)</input>"
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3156108\n"
"help.text"
-msgid "<emph>Number</emph> represents the value based on which the standard normal distribution is calculated."
-msgstr "<emph>Število</emph> predstavlja vrednost, na osnovi katere se izračuna standardna normalna porazdelitev."
+msgid "<emph>Number</emph> is the value for which the probability density function is calculated."
+msgstr "<emph>Število</emph> je vrednost, za katero bo izračunana funkcija gostote porazdelitve."
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3155849\n"
"help.text"
-msgid "<item type=\"input\">=PHI(2.25) </item>= 0.03"
-msgstr "<item type=\"input\">=PHI(2,25) </item>= 0,03"
+msgid "<input>=PHI(2.25)</input> returns 0.0317."
+msgstr "<input>=PHI(2,25)</input> vrne 0,0317."
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3143236\n"
"help.text"
-msgid "<item type=\"input\">=PHI(-2.25)</item> = 0.03"
-msgstr "<item type=\"input\">=PHI(-2,25)</item> = 0,03"
+msgid "<input>=PHI(-2.25)</input> also returns 0.0317 because the normal distribution is symmetrical."
+msgstr "<input>=PHI(-2,25)</input> prav tako vrne 0,0317, saj je normalna porazdelitev simetrična."
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3149286\n"
"help.text"
-msgid "<item type=\"input\">=PHI(0)</item> = 0.4"
-msgstr "<item type=\"input\">=PHI(0)</item> = 0,4"
+msgid "<input>=PHI(0)</input> returns 0.3989."
+msgstr "<input>=PHI(0)</input> vrne 0,3989."
+
+#: 04060184.xhp
+msgctxt ""
+"04060184.xhp\n"
+"par_id611629985664328\n"
+"help.text"
+msgid "Calling <input>PHI(Number)</input> is equivalent to calling <input>NORMDIST(Number,0,1,FALSE())</input> or <input>NORM.S.DIST(Number;FALSE())</input>, hence using the standard normal distribution with mean equal to 0 and standard deviation equal to 1 with the <emph>Cumulative</emph> argument set to <emph>False.</emph>"
+msgstr "Klic funkcije <input>PHI(število)</input> je ekvivalenten klicema <input>NORMDIST(število,0,1,FALSE())</input> in <input>NORM.S.DIST(število;FALSE())</input>, zato uporablja standardno normalno porazdelitev s srednjo vrednostjo enako 0 in standardni odklon enak 1 z argumentom <emph>kumulativno</emph> z vrednostjo <emph>False</emph>."
#: 04060184.xhp
msgctxt ""
@@ -37292,14 +37404,6 @@ msgstr "Seštevanje"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3153247\n"
-"help.text"
-msgid "1+1"
-msgstr "1+1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3159204\n"
"help.text"
msgid "- (Minus)"
@@ -37316,14 +37420,6 @@ msgstr "Odštevanje"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3153554\n"
-"help.text"
-msgid "2-1"
-msgstr "2-1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3153808\n"
"help.text"
msgid "- (Minus)"
@@ -37340,14 +37436,6 @@ msgstr "Negacija"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3154712\n"
-"help.text"
-msgid "-5"
-msgstr "-5"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3149873\n"
"help.text"
msgid "* (asterisk)"
@@ -37364,14 +37452,6 @@ msgstr "Množenje"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3149055\n"
-"help.text"
-msgid "2*2"
-msgstr "2*2"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3151341\n"
"help.text"
msgid "/ (Slash)"
@@ -37388,14 +37468,6 @@ msgstr "Deljenje"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3153027\n"
-"help.text"
-msgid "9/3"
-msgstr "9/3"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3156396\n"
"help.text"
msgid "% (Percent)"
@@ -37412,14 +37484,6 @@ msgstr "Odstotek"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3145632\n"
-"help.text"
-msgid "15%"
-msgstr "15 %"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3149722\n"
"help.text"
msgid "^ (Caret)"
@@ -37436,10 +37500,10 @@ msgstr "Potenciranje"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3157873\n"
+"par_id881623862728559\n"
"help.text"
-msgid "3^2"
-msgstr "3^2"
+msgid "Prefix \"-\" (negation) has a higher precedence than \"^\" (exponentiation). For example -3^2 equals 9, which is the square of a negative number."
+msgstr "Predpona »-« (negacija) ima višjo prednost kot »^« (eksponentno). Primer: -3^2 je enako 9, kar predstavlja kvadrat negativnega števila."
#: 04060199.xhp
msgctxt ""
@@ -37500,14 +37564,6 @@ msgstr "Enako"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3154546\n"
-"help.text"
-msgid "A1=B1"
-msgstr "A1=B1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3154807\n"
"help.text"
msgid "> (Greater than)"
@@ -37524,14 +37580,6 @@ msgstr "Večje kot"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3145138\n"
-"help.text"
-msgid "A1>B1"
-msgstr "A1>B1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3149507\n"
"help.text"
msgid "< (Less than)"
@@ -37548,14 +37596,6 @@ msgstr "Manjše kot"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3150901\n"
-"help.text"
-msgid "A1<B1"
-msgstr "A1<B1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3153078\n"
"help.text"
msgid ">= (Greater than or equal to)"
@@ -37572,14 +37612,6 @@ msgstr "Večje ali enako"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3153111\n"
-"help.text"
-msgid "A1>=B1"
-msgstr "A1>=B1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3153004\n"
"help.text"
msgid "<= (Less than or equal to)"
@@ -37596,14 +37628,6 @@ msgstr "Manjše ali enako"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3148760\n"
-"help.text"
-msgid "A1<=B1"
-msgstr "A1<=B1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3157994\n"
"help.text"
msgid "<> (Inequality)"
@@ -37620,14 +37644,6 @@ msgstr "Neenakost"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3149878\n"
-"help.text"
-msgid "A1<>B1"
-msgstr "A1<>B1"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"hd_id3145241\n"
"help.text"
msgid "Text operators"
@@ -37764,14 +37780,6 @@ msgstr "Obseg"
#: 04060199.xhp
msgctxt ""
"04060199.xhp\n"
-"par_id3148432\n"
-"help.text"
-msgid "A1:C108"
-msgstr "A1:C108"
-
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
"par_id3152592\n"
"help.text"
msgid "! (Exclamation point)"
@@ -38478,8 +38486,8 @@ msgctxt ""
"04080000.xhp\n"
"par_id3152576\n"
"help.text"
-msgid "The <emph>Function List</emph> window is a resizable <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link>. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters."
-msgstr "Okno <emph>Seznam funkcij</emph> je raztegljivo <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"plavajoče okno\">plavajoče okno</link>. Uporabite ga za hitro vnašanje funkcij v preglednico. Ko dvokliknete vnos v seznamu funkcij, je funkcija neposredno vstavljena z vsemi parametri."
+msgid "The <emph>Function List</emph> window is a resizable <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">dockable window</link>. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters."
+msgstr "Okno <emph>Seznam funkcij</emph> je raztegljivo <link href=\"text/shared/00/00000005.xhp#docking\" name=\"plavajoče okno\">plavajoče okno</link>. Uporabite ga za hitro vnašanje funkcij v preglednico. Ko dvokliknete vnos v seznamu funkcij, je funkcija neposredno vstavljena z vsemi parametri."
#: 04080000.xhp
msgctxt ""
@@ -39308,42 +39316,130 @@ msgstr "Spoji celice in poravnaj na sredino"
#: 05060000.xhp
msgctxt ""
"05060000.xhp\n"
+"bm_id501632012952361\n"
+"help.text"
+msgid "<bookmark_value>toggle merge and center cells</bookmark_value>"
+msgstr "<bookmark_value>spajanje celic;preklapljanje</bookmark_value><bookmark_value>poravnavanje;spojene celice</bookmark_value>"
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
"hd_id3149785\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05060000.xhp\" name=\"Merge and Center Cells\">Merge and Center Cells</link>"
-msgstr "<link href=\"text/scalc/01/05060000.xhp\" name=\"Spoji celice in poravnaj na sredino\">Spoji celice in poravnaj na sredino</link>"
+msgid "<variable id=\"togglemergecells\"><link href=\"text/scalc/01/05060000.xhp\" name=\"Merge and Center Cells\">Merge and Center Cells</link></variable>"
+msgstr "<variable id=\"togglemergecells\"><link href=\"text/scalc/01/05060000.xhp\" name=\"Spoji celice in poravnaj na sredino\">Spoji celice in poravnaj na sredino</link></variable>"
#: 05060000.xhp
msgctxt ""
"05060000.xhp\n"
"par_id3151246\n"
"help.text"
-msgid "<ahelp hid=\".\">Combines the selected cells into a single cell or splits merged cells. Aligns cell content centered.</ahelp>"
-msgstr "<ahelp hid=\".\">Združi izbrane celice v eno samo celico ali razdeli spojene celice. Vsebino celice poravna sredinsko.</ahelp>"
+msgid "<ahelp hid=\".\">This is a toggleable control that joins all cells in a rectangular selection into a single cell, or returns merged cells to the original individual cells. When merging it will format the merged cell as center aligned.</ahelp>"
+msgstr "<ahelp hid=\".\">To je preklopni kontrolnik, ki spoji vse celice v pravokotnem izboru v eno celico ali povrne spojene celice nazaj v izvorne posamezne celice. Pri spajanju oblikuje spojeno celico kot sredinsko poravnano.</ahelp>"
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id541633057818950\n"
+"help.text"
+msgid "The control is shown toggled-on whenever there are merged cells in the selection, indicating that clicking the control will unmerge those cells."
+msgstr "Kontrolnik se prikaže vklopljen, kadar so v izboru spojene celice, kar nakazuje, da s klikom kontrolnika te celice razdružite."
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id3153718\n"
+"help.text"
+msgid "Merging cells can lead to calculation errors in formulas in the table."
+msgstr "Spajanje celic lahko privede do napak v izračunih formul v tabelah."
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id441632808439621\n"
+"help.text"
+msgid "Do one of the following:"
+msgstr "Naredite nekaj od naslednjega:"
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id691632803588118\n"
+"help.text"
+msgid "In the <emph>Formatting</emph> toolbar, click:"
+msgstr "V vrstici <emph>Oblikovanje</emph> kliknite"
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id521632804983642\n"
+"help.text"
+msgid "<image id=\"img_id811632804983642\" src=\"cmd/sc_togglemergecells.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id921632804983642\">Icon Merge and Center Cells</alt></image>"
+msgstr "<image id=\"img_id811632804983642\" src=\"cmd/sc_togglemergecells.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id921632804983642\">Ikona Spoji celice in poravnaj na sredino</alt></image>"
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id491632804983642\n"
+"help.text"
+msgid "Merge and Center Cells"
+msgstr "Spoji celice in poravnaj na sredino"
#: 05060000.xhp
msgctxt ""
"05060000.xhp\n"
"par_id3154020\n"
"help.text"
-msgid "Choose <emph>Format - Merge Cells - Merge and Center Cells</emph>"
-msgstr "Izberite <emph>Oblika – Spoji celice – Spoji celice in poravnaj na sredino</emph>."
+msgid "Or, choose <variable id=\"format_mergecells_menu\"><menuitem>Format - Merge and Unmerge Cells - </menuitem></variable><menuitem> Merge and Center Cells</menuitem>."
+msgstr "Izberite <variable id=\"format_mergecells_menu\"><menuitem>Oblika – Spoji in razdeli spojene celice – </menuitem></variable><menuitem> Spoji celice in poravnaj na sredino</menuitem>."
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id3149665\n"
+"help.text"
+msgid "Cells cannot be merged again without first unmerging them."
+msgstr "Poprej spojenih celic ni možno nadalje spajati z drugimi celicami, ne da bi jih pred tem razdelili."
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id581632979766784\n"
+"help.text"
+msgid "Merging a cell selection that partially includes merged cells is generally possible with <emph>Unmerge Cells</emph> followed by <emph>Merge Cells</emph>, without altering the initial selection. The result will be largely depend on previous choices when merging cells made with the <emph>Merge Cells Dialog</emph> options described below."
+msgstr "Spajanje izbora celic, ki delno vsebuje spojene celice je v splošnem možno z ukazom <emph>Razdruži spojene celice</emph> in nato z ukazom <emph>Spoji celice</emph>, ne da bi vmes spreminjali začetni izbor. Rezultat je v veliki meri odvisen od prejšnjih izbir pri spajanju celic s spodaj opisanimi možnostmi v <emph>pogovornem oknu Spoji celice</emph>."
#: 05060000.xhp
msgctxt ""
"05060000.xhp\n"
"par_id3148552\n"
"help.text"
-msgid "The merged cell receives the name of the first cell of the original cell range. Merged cells cannot be merged a second time with other cells. The range must form a rectangle, multiple selection is not supported."
-msgstr "Spojena celica dobi ime prve celice izvirnega obsega celice. Spojenih celic ni mogoče še enkrat spojiti z drugimi celicami. Obseg mora tvoriti pravokotnik, večkratna izbira ni podprta."
+msgid "Multiple selection is not supported, that is, the selection must be rectangular."
+msgstr "Večkratni izbor oz. izbor nestičnih celic ni podprt; izbor mora imeti pravokotno obliko."
#: 05060000.xhp
msgctxt ""
"05060000.xhp\n"
-"par_id3149665\n"
+"par_id211632985508898\n"
"help.text"
-msgid "If the cells to be merged have any contents, a security dialog is shown."
-msgstr "Če imajo celice, ki jih boste spojili, kakršnokoli vsebino, se prikaže pogovorno okno zaščite."
+msgid "The merged cell receives the name and content of the first cell of the selection."
+msgstr "Spojena celica prevzame ime in vsebino prve celice v izboru."
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id271632985709781\n"
+"help.text"
+msgid "If more than one cell to be merged has content the <emph>Merge Cells</emph> dialog opens."
+msgstr "Če ima več kot ena od celic, ki jih boste spojili, kakršnokoli vsebino, se prikaže pogovorno okno <emph>Spoji Celice</emph>."
+
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id391632360383197\n"
+"help.text"
+msgid "Merge Cells Dialog Options"
+msgstr "Možnosti pogovornega okna Spoji celice"
#: 05060000.xhp
msgctxt ""
@@ -39377,14 +39473,6 @@ msgctxt ""
msgid "<emph>Empty the contents of the hidden cells</emph>: <ahelp hid=\".\">The contents of the hidden cells are removed; the results of formulas referring to the hidden cells will be updated.</ahelp>"
msgstr "<emph>Izprazni vsebino skritih celic.</emph> <ahelp hid=\".\">Vsebina skritih celic je odstranjena; rezultati formul, ki se sklicujejo na skrite celice, bodo posodobljeni.</ahelp>"
-#: 05060000.xhp
-msgctxt ""
-"05060000.xhp\n"
-"par_id3153718\n"
-"help.text"
-msgid "Merging cells can lead to calculation errors in formulas in the table."
-msgstr "Spajanje celic lahko privede do napak v izračunih formul v tabelah."
-
#: 05070000.xhp
msgctxt ""
"05070000.xhp\n"
@@ -39406,8 +39494,8 @@ msgctxt ""
"05070000.xhp\n"
"hd_id3157910\n"
"help.text"
-msgid "Page Style"
-msgstr "Slog strani"
+msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"Page Style\">Page Style</link>"
+msgstr "<link href=\"text/scalc/01/05070000.xhp\" name=\"Slog strani\">Slog strani</link>"
#: 05070000.xhp
msgctxt ""
@@ -39654,16 +39742,16 @@ msgctxt ""
"05070500.xhp\n"
"par_id3155378\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Select this option if you want the first page to start with a number other than 1.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Izberite to možnost, če ne želite, da se prva stran začne z 1.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Select this option if you want this style to restart page numbering.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Izberite to možnost, če želite, da začne ta slog znova oštevilčevati strani.</ahelp>"
#: 05070500.xhp
msgctxt ""
"05070500.xhp\n"
"par_id3145389\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Enter the number of the first page.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Vnesite številko prve strani.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Enter the number you want to restart at.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Vnesite številko, s katero želite začeti znova oštevilčevati strani.</ahelp>"
#: 05070500.xhp
msgctxt ""
@@ -39942,8 +40030,8 @@ msgctxt ""
"05080300.xhp\n"
"par_id3159488\n"
"help.text"
-msgid "<variable id=\"druckbereichetext\"><ahelp hid=\".uno:EditPrintArea\">Opens a dialog where you can specify the print range.</ahelp></variable> You can also set the rows or columns which are to be repeated in every page."
-msgstr "<variable id=\"druckbereichetext\"><ahelp hid=\".uno:EditPrintArea\">Odpre pogovorno okno, kjer lahko podate obseg tiskanja.</ahelp></variable> Prav tako lahko nastavite vrstice ali stolpce, ki se bodo ponavljali na vsaki strani."
+msgid "<variable id=\"printrangestext\"><ahelp hid=\".uno:EditPrintArea\">Opens a dialog where you can specify the print range.</ahelp></variable> You can also set the rows or columns which are to be repeated in every page."
+msgstr "<variable id=\"printrangestext\"><ahelp hid=\".uno:EditPrintArea\">Odpre pogovorno okno, kjer lahko podate obseg tiskanja.</ahelp></variable> Prav tako lahko nastavite vrstice ali stolpce, ki se bodo ponavljali na vsaki strani."
#: 05080300.xhp
msgctxt ""
@@ -40086,8 +40174,8 @@ msgctxt ""
"05100000.xhp\n"
"par_id3149665\n"
"help.text"
-msgid "The Styles <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link> can remain open while editing the document."
-msgstr "<link href=\"text/shared/00/00000005.xhp#andocken\" name=\"plavajoče okno\">Plavajoče okno</link> Slogi lahko med urejanjem dokumenta ostane odprto."
+msgid "The Styles <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">dockable window</link> can remain open while editing the document."
+msgstr "<link href=\"text/shared/00/00000005.xhp#docking\" name=\"plavajoče okno\">Plavajoče okno</link> Slogi lahko med urejanjem dokumenta ostane odprto."
#: 05100000.xhp
msgctxt ""
@@ -40345,70 +40433,6 @@ msgctxt ""
msgid "<ahelp hid=\"SFX2_HID_TEMPLATE_FILTER\">Lists the available style groups.</ahelp>"
msgstr "<ahelp hid=\"SFX2_HID_TEMPLATE_FILTER\">Navede razpoložljive skupine slogov.</ahelp>"
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"tit\n"
-"help.text"
-msgid "Merge Cells"
-msgstr "Spoji celice"
-
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"hd_id3154765\n"
-"help.text"
-msgid "Merge Cells"
-msgstr "Spoji celice"
-
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"par_id3147406\n"
-"help.text"
-msgid "<ahelp hid=\".\">Combines the contents of the selected cells into a single cell.</ahelp>"
-msgstr "<ahelp hid=\".\">Spoji vsebino izbranih celic tabele v eno samo celico.</ahelp>"
-
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"par_id3154351\n"
-"help.text"
-msgid "Choose <emph>Format - Merge Cells - Merge Cells</emph>"
-msgstr "Izberite <emph>Oblika – Spoji celice – Spoji celice</emph>."
-
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"tit\n"
-"help.text"
-msgid "Split Cells"
-msgstr "Razdeli celice"
-
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"hd_id3154654\n"
-"help.text"
-msgid "Split Cells"
-msgstr "Razdeli celice"
-
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"par_id3083451\n"
-"help.text"
-msgid "<ahelp hid=\".\">Splits previously merged cells.</ahelp>"
-msgstr "<ahelp hid=\".\">Razdeli poprej spojene celice.</ahelp>"
-
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"par_id3154023\n"
-"help.text"
-msgid "Choose <emph>Format - Merge Cells - Split Cells</emph>"
-msgstr "Izberite <emph>Oblika – Spoji celice – Razdeli celice</emph>."
-
#: 05110000.xhp
msgctxt ""
"05110000.xhp\n"
@@ -40436,6 +40460,14 @@ msgstr "<variable id=\"autoformattext\"><ahelp hid=\".\">Ta ukaz uporabite, da u
#: 05110000.xhp
msgctxt ""
"05110000.xhp\n"
+"par_id181630332690300\n"
+"help.text"
+msgid "The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu."
+msgstr "Ukaz Samooblikovanje je na voljo le, če je izbran obseg celic z najmanj tremi stolpci in tremi vrsticami. Sicer je ta ukaz v meniju prikazan osivelo."
+
+#: 05110000.xhp
+msgctxt ""
+"05110000.xhp\n"
"hd_id3148455\n"
"help.text"
msgid "Format"
@@ -40660,42 +40692,58 @@ msgstr "<bookmark_value>pogojno oblikovanje; pogoji</bookmark_value>"
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
+"hd_id71624649758112\n"
+"help.text"
+msgid "Condition list"
+msgstr "Seznam pogojev"
+
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
"par_id3149413\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">List of the conditions defined for the cell range in order of evaluation.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Seznam pogojev, določenih za obseg celic v zaporedju ovrednotenja.</ahelp>"
+msgid "List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want."
+msgstr "Seznam pogojev, določenih za obseg celic v zaporedju ovrednotenja. Določite lahko poljubno število pogojev."
+
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"hd_id41624649786605\n"
+"help.text"
+msgid "Up"
+msgstr "Navzgor"
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
"par_id3149414\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Increase priority of the selected condition.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Poviša prioriteto izbranega pogoja.</ahelp>"
+msgid "<ahelp hid=\".\">Increase priority of the selected condition.</ahelp>"
+msgstr "<ahelp hid=\".\">Poviša prioriteto izbranega pogoja.</ahelp>"
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id3149415\n"
+"hd_id861624649792266\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Decrease priority of the selected condition.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Zniža prioriteto izbranega pogoja.</ahelp>"
+msgid "Down"
+msgstr "Navzdol"
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"hd_id31531891\n"
+"par_id3149415\n"
"help.text"
-msgid "Condition"
-msgstr "Pogoj"
+msgid "<ahelp hid=\".\">Decrease priority of the selected condition.</ahelp>"
+msgstr "<ahelp hid=\".\">Zniža prioriteto izbranega pogoja.</ahelp>"
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494131\n"
+"hd_id31531891\n"
"help.text"
-msgid "You can define as many conditions as you want."
-msgstr "Določite lahko toliko pogojev, kolikor želite."
+msgid "Condition list entry"
+msgstr "Vnos seznama pogojev"
#: 05120000.xhp
msgctxt ""
@@ -43278,16 +43326,16 @@ msgctxt ""
"12040000.xhp\n"
"tit\n"
"help.text"
-msgid "Filter"
-msgstr "Filter"
+msgid "More Filters"
+msgstr "Več filtrov"
#: 12040000.xhp
msgctxt ""
"12040000.xhp\n"
"hd_id3150767\n"
"help.text"
-msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filters</link>"
-msgstr "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filtri</link>"
+msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">More Filters</link>"
+msgstr "<link href=\"text/scalc/01/12040000.xhp\" name=\"Več filtrov\">Več filtrov</link>"
#: 12040000.xhp
msgctxt ""
@@ -43300,10 +43348,10 @@ msgstr "<ahelp hid=\".\">Pokaže ukaze, s katerimi filtrirate svoje podatke.</ah
#: 12040000.xhp
msgctxt ""
"12040000.xhp\n"
-"par_id3146119\n"
+"par_id911633127394220\n"
"help.text"
-msgid "$[officename] automatically recognizes predefined database ranges."
-msgstr "$[officename] samodejno prepozna preddoločene obsege zbirke podatkov."
+msgid "%PRODUCTNAME automatically recognizes predefined database ranges."
+msgstr "%PRODUCTNAME samodejno prepozna vnaprej določene obsege zbirke podatkov."
#: 12040000.xhp
msgctxt ""
@@ -43764,10 +43812,10 @@ msgstr "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/edfilterarea\">Izberi
#: 12040300.xhp
msgctxt ""
"12040300.xhp\n"
-"hd_id3153188\n"
+"hd_id331625165680452\n"
"help.text"
-msgid "<link href=\"text/scalc/01/12040201.xhp\" name=\"More\">More</link>"
-msgstr "<link href=\"text/scalc/01/12040201.xhp\" name=\"Dodatno\">Dodatno</link>"
+msgid "Options"
+msgstr "Možnosti"
#: 12040400.xhp
msgctxt ""
@@ -47318,8 +47366,8 @@ msgctxt ""
"12120300.xhp\n"
"par_id3153379\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Define the error message that is displayed when invalid data is entered in a cell.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Določite sporočilo o napaki, ki bo prikazano ob vnosu neveljavnih podatkov v celico.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Defines the error message that is displayed when invalid data is entered in a cell.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Določa sporočilo o napaki, ki bo prikazano ob vnosu neveljavnih podatkov v celico.</ahelp>"
#: 12120300.xhp
msgctxt ""
@@ -47433,6 +47481,70 @@ msgctxt ""
msgid "Sample macro:"
msgstr "Vzorčni makro:"
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"par_id521625929022780\n"
+"help.text"
+msgid "Below is a sample function that can be called when an error occurs. Note that the macro takes in two parameters that are passed on by %PRODUCTNAME when the function is called:"
+msgstr "Spodaj je primer funkcije, ki jo lahko kličete, ko pride do napake. Upoštevajte, da makro poda dva parametra, ki jih posreduje %PRODUCTNAME ob klicu funkcije:"
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"par_id981625929097216\n"
+"help.text"
+msgid "<emph>CellValue</emph>: The value entered by the user, as a String."
+msgstr "<emph>VrednostCelice</emph>: vrednost, ki jo vnese uporabnik, podana kot niz."
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"par_id421625929100152\n"
+"help.text"
+msgid "<emph>CellAddress</emph>: The address of the cell where the value was entered, as a String prefixed with the sheet name (e.g: \"Sheet1.A1\")."
+msgstr "<emph>NaslovCelice</emph>: naslov celice, kjer je vnesena vrednost, podan kot niz s predpono imena delovnega lista (npr. »DelovniList1.A1«)."
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"par_id101625929384030\n"
+"help.text"
+msgid "The function must return a Boolean value. If it returns <literal>True</literal>, the entered value is kept. If the function returns <literal>False</literal>, the entered value is erased and the previous value is restored."
+msgstr "Funkcija mora vrniti logično vrednost. Če vrne <literal>True</literal>, se vnesena vrednost ohrani. Če funkcija vrne <literal>False</literal>, se vnesena vrednost izbriše in obnovi se prejšnja vrednost."
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"par_id531545240216611\n"
+"help.text"
+msgid "msg = \"Invalid value: \" & \"'\" & CellValue & \"'\""
+msgstr "msg = \"Neveljavna vrednost: \" & \"'\" & VrednostCelice & \"'\""
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"bas_id971625928577365\n"
+"help.text"
+msgid "msg = msg & \" in cell: \" & \"'\" & CellAddress & \"'\""
+msgstr "msg = msg & \" v celici: \" & \"'\" & NaslovCelice & \"'\""
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"bas_id181625928577640\n"
+"help.text"
+msgid "msg = msg & Chr(10) & \"Accept anyway?\""
+msgstr "msg = msg & Chr(10) & \"Ali jo želite vseeno sprejeti?\""
+
+#: 12120300.xhp
+msgctxt ""
+"12120300.xhp\n"
+"bas_id941625928578118\n"
+"help.text"
+msgid "iAnswer = MsgBox (msg , MB_FLAGS, \"Error message\")"
+msgstr "iAnswer = MsgBox (msg , MB_FLAGS, \"Sporočilo o napaki\")"
+
#: ODFF.xhp
msgctxt ""
"ODFF.xhp\n"
@@ -47524,6 +47636,14 @@ msgstr "Primer"
#: common_func.xhp
msgctxt ""
"common_func.xhp\n"
+"hd_id281996\n"
+"help.text"
+msgid "Examples"
+msgstr "Primeri"
+
+#: common_func.xhp
+msgctxt ""
+"common_func.xhp\n"
"par_id301616845402409\n"
"help.text"
msgid "This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href=\"text/scalc/01/03080000.xhp\" name=\"value highlight\">value highlighting</link> feature."
@@ -53510,8 +53630,8 @@ msgctxt ""
"func_findb.xhp\n"
"par_id481573517830373\n"
"help.text"
-msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
-msgstr "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> vrne 19."
+msgid "<input>=FINDB(\"a\"; \"LibreOffice Calc\")</input> returns 15. The <emph>Find Text</emph> argument is a text string that comprises a full-width, double-byte \"a\" character, while the <emph>Text</emph> argument comprises 12 single-byte characters followed by four full-width, double-byte characters."
+msgstr "<input>=FINDB(\"a\"; \"LibreOffice Calc\")</input> vrne 15. Argument <emph>Najdi besedilo</emph> je besedilni niz, ki ga vključuje znak »a« polne širine, dvojnih bajtov, medtem ko argument <emph>Besedilo</emph> predstavlja 12 eno-bajtnih znakov, ki mu sledijo štirje znaki polne širine, dvojnih bajtov."
#: func_floor.xhp
msgctxt ""
@@ -56358,15 +56478,15 @@ msgctxt ""
"func_numbervalue.xhp\n"
"hd_id3145621\n"
"help.text"
-msgid "<variable id=\"datevalue\"> <link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link> </variable>"
-msgstr "<variable id=\"datevalue\"><link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE </link></variable>"
+msgid "<variable id=\"numbervalue_h1\"><link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link></variable>"
+msgstr "<variable id=\"numbervalue_h1\"><link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link></variable>"
#: func_numbervalue.xhp
msgctxt ""
"func_numbervalue.xhp\n"
"par_id3145087\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Convert text to number, in a locale-independent way.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Converts the string representation of a number into a locale-independent numeric value.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Pretvori besedilo v številko ne glede na izbrane krajevne oz. jezikovne nastavitve.</ahelp>"
#: func_numbervalue.xhp
@@ -56374,48 +56494,96 @@ msgctxt ""
"func_numbervalue.xhp\n"
"par_id3149281\n"
"help.text"
-msgid "Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator"
-msgstr "Omejitve: LEN(decimalno_ločilo) = 1, decimalno_ločilo se ne sme pojaviti v ločilu_skupin."
+msgid "The input text may be in a locale-dependent or other bespoke format."
+msgstr "Vhodno besedilo je lahko v obliki, odvisni od krajevnih oz. jezikovnih nastavitev."
#: func_numbervalue.xhp
msgctxt ""
"func_numbervalue.xhp\n"
-"par_id3149268\n"
+"par_id381625600941159\n"
+"help.text"
+msgid "The output number is formatted as a valid floating point value and shown using the current cell's number format."
+msgstr "Izhodno število je oblikovano kot veljavna vrednost plavajoče vejice in je prikazana v obliki števil trenutne celice."
+
+#: func_numbervalue.xhp
+msgctxt ""
+"func_numbervalue.xhp\n"
+"par_id351625601754290\n"
"help.text"
-msgid "NUMBERVALUE(\"Text\" [;decimal_separator [;group_separator]])"
-msgstr "NUMBERVALUE(\"Besedilo\" [;decimalno_ločilo [;ločilo_skupin]])"
+msgid "Refer to the <embedvar href=\"text/shared/01/05020300.xhp#NumbersLink\"/> help page to learn how to change the format of numbers in a cell."
+msgstr "Glejte stran pomoči <embedvar href=\"text/shared/01/05020300.xhp#NumbersLink\"/>, če vas zanima, kako spremenite obliko števil v celici.***"
+
+#: func_numbervalue.xhp
+msgctxt ""
+"func_numbervalue.xhp\n"
+"par_id721625602228575\n"
+"help.text"
+msgid "NUMBERVALUE(Text[; Decimal Separator[; Group Separator]])"
+msgstr "NUMBERVALUE(Besedilo[; decimalno_ločilo[; ločilo_skupin]])"
#: func_numbervalue.xhp
msgctxt ""
"func_numbervalue.xhp\n"
"par_id3154819\n"
"help.text"
-msgid "<emph>Text</emph> is a valid number expression and must be entered with quotation marks."
-msgstr "<emph>Besedilo</emph> je veljavni številski izraz in ga je potrebno vnesti z navednicami."
+msgid "<emph>Text</emph> is a string that contains the number to be converted."
+msgstr "<emph>Besedilo</emph> je niz, ki vsebuje število, ki ga želite pretvoriti."
#: func_numbervalue.xhp
msgctxt ""
"func_numbervalue.xhp\n"
"par_id3154820\n"
"help.text"
-msgid "<emph>decimal_separator</emph> (optional) defines the character used as the decimal separator."
-msgstr "<emph>Decimalno_ločilo</emph> (neobvezno) določa znak, ki bo uporabljen kot desetiško ločilo."
+msgid "<emph>Decimal Separator</emph> is a single character that specifies the decimal separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any decimal or group separators."
+msgstr "<emph>Decimalno ločilo</emph> je enojni znak, ki določa descimalno ločilo v podanem <emph>Besedilu</emph>. Lahko ga izpustite, če <emph>Besedilo</emph> ne vključuje decimalnega ločila ali ločila skupin."
#: func_numbervalue.xhp
msgctxt ""
"func_numbervalue.xhp\n"
"par_id3154821\n"
"help.text"
-msgid "<emph>group_separator</emph> (optional) defines the character(s) used as the group separator."
-msgstr "<emph>Ločilo_skupin</emph> (neobvezno) določa znake, ki bodo uporabljeni kot ločilo skupin."
+msgid "<emph>Group Separator</emph> is a string that specifies the character(s) used as the group separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any group separators. The <emph>Decimal Separator</emph> character should not be used in <emph>Group Separator</emph>."
+msgstr "<emph>Ločilo skupin</emph> je niz, ki določa znak(e), uporabljene kot ločila skupin v <emph>Besedilu</emph>. Lahko ga izpustite, če <emph>Besedilo</emph> ne vključuje ločil skupin. Znak za <emph>decimalno ločilo</emph> ne sme biti enak znaku za <emph>ločilo skupin</emph>."
#: func_numbervalue.xhp
msgctxt ""
"func_numbervalue.xhp\n"
"par_id3155841\n"
"help.text"
-msgid "<item type=\"input\">=NUMBERVALUE(\"123.456\";\".\";\",\")</item> yields 123.456"
-msgstr "<item type=\"input\">=NUMBERVALUE(\"123,456\";\",\";\".\")</item> vrne 123,456."
+msgid "<input>=NUMBERVALUE(\"1.234.567,89\"; \",\"; \".\")</input> returns 1234567.89 (considering en-US locale). The function removes the two group separators and changes the decimal separator from a comma to a full stop."
+msgstr "<input>=NUMBERVALUE(\"1,234,567.89\"; \".\"; \",\")</input> vrne 1234567,89 (glede na krajevno nastavitev sl-SI). Funkcija odstrani ločili skupin in spremeni decimalno ločilo iz pike v vejico."
+
+#: func_numbervalue.xhp
+msgctxt ""
+"func_numbervalue.xhp\n"
+"par_id721625603302860\n"
+"help.text"
+msgid "<input>=NUMBERVALUE(\"123·4\"; \"·\")</input> returns 123.4 (considering en-US locale). The function changes the decimal separator from a \"·\" to a full stop. No group separator is used in the supplied number and so the <emph>Group Separator</emph> argument is omitted."
+msgstr "<input>=NUMBERVALUE(\"123·4\"; \"·\")</input> vrne 123,4 (gleda na krajevno nastavitev sl-SI). Funkcija spremeni decimalno ločilo iz »·« v vejico. Ločilo tisočic v podanem številu ni uporabljeno, zato je argument <emph>Ločilo skupin</emph> izpuščen."
+
+#: func_numbervalue.xhp
+msgctxt ""
+"func_numbervalue.xhp\n"
+"par_id491625603415715\n"
+"help.text"
+msgid "<input>=NUMBERVALUE(\"123e12\")</input> returns 1.23E+14 (considering en-US locale). No decimal or group separators are used in the supplied number and so the <emph>Decimal Separator</emph> and <emph>Group Separator</emph> arguments are omitted."
+msgstr "<input>=NUMBERVALUE(\"123e12\")</input> vrne 1,23E+14 (glede na krajevno nastavitev sl-SI). V podanem številu ni decimalnega ločila niti ločila tisočic, zato sta argumenta <emph>Decimalno ločilo</emph> in <emph>Ločilo skupin</emph> izpuščena."
+
+#: func_numbervalue.xhp
+msgctxt ""
+"func_numbervalue.xhp\n"
+"par_id801625603497421\n"
+"help.text"
+msgid "<input>=NUMBERVALUE(\"1#!234#!567\"; \".\"; \"#!\")</input> returns 1234567 (considering en-US locale). Note that in this case the group separator is specified as a two-character string."
+msgstr "<input>=NUMBERVALUE(\"1#!234#!567\"; \".\"; \"#!\")</input> vrne 1234567 (glede na krajevno nastavitev sl-SI). Upoštevajte, da je v tem primeru ločilo tisočic določeno kot dvoznakovni niz."
+
+#: func_numbervalue.xhp
+msgctxt ""
+"func_numbervalue.xhp\n"
+"par_id451626100385699\n"
+"help.text"
+msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE\" name=\"NUMBERVALUE_Wiki\">NUMBERVALUE</link> wiki page for more details about this function."
+msgstr "Za podrobnosti o tej funkciji glejte <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE\" name=\"Stran wiki o funkciji NUMBERVALUE\">stran wiki o funkciji NUMBERVALUE</link> (v angl.)."
#: func_opt_barrier.xhp
msgctxt ""
@@ -57004,6 +57172,14 @@ msgstr "Za klic funkcije sta potrebna vsaj dva parametra."
#: func_rawsubtract.xhp
msgctxt ""
"func_rawsubtract.xhp\n"
+"par_id271624030692893\n"
+"help.text"
+msgid "RAWSUBTRACT() processes arguments from left to right. For example, RAWSUBTRACT(1;2;3;4) calculates 1-2-3-4 or ((1-2)-3)-4 in \"natural\" order."
+msgstr "RAWSUBTRACT() obdeluje argumente od leve proti desni. Primer: RAWSUBTRACT(1;2;3;4) izračuna 1-2-3-4 ali ((1-2)-3)-4 v »naravnem« zaporedju."
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
"par_2016112109236\n"
"help.text"
msgid "<input>=RAWSUBTRACT(0.987654321098765, 0.9876543210987)</input> returns 6.53921361504217E-14"
@@ -57070,8 +57246,8 @@ msgctxt ""
"func_regex.xhp\n"
"par_id211542232209275\n"
"help.text"
-msgid "<emph>Expression</emph>: A text representing the regular expression, using <link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>. If there is no match and <emph>Replacement</emph> is not given, #N/A is returned."
-msgstr "<emph>Izraz</emph>: besedilo, ki predstavlja regularni izraz z uporabo <link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">regularnih izrazov ICU</link>. Če ni zadetkov in <emph>zamenjava</emph> ni podana, vrne #N/A."
+msgid "<emph>Expression</emph>: A text representing the regular expression, using <link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html\" name=\"ICU REGEXP\">ICU regular expressions</link>. If there is no match and <emph>Replacement</emph> is not given, #N/A is returned."
+msgstr "<emph>Izraz</emph>: besedilo, ki predstavlja regularni izraz z uporabo <link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html\" name=\"ICU REGEXP\">. Če ni zadetkov in <emph>zamenjava</emph> ni podana, vrne #N/A."
#: func_regex.xhp
msgctxt ""
@@ -57150,8 +57326,8 @@ msgctxt ""
"func_regex.xhp\n"
"par_id431542233650614\n"
"help.text"
-msgid "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>"
-msgstr "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"Dokumentacija regularnih izrazov ICU\">Dokumentacija regularnih izrazov ICU</link> (v angl.)"
+msgid "<link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html\" name=\"ICU REGEXP\">ICU regular expressions</link>"
+msgstr "<link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html\" name=\"Regularni izrazi ICU\">Regularni izrazi ICU</link> (v angl.)"
#: func_replaceb.xhp
msgctxt ""
@@ -57198,24 +57374,24 @@ msgctxt ""
"func_replaceb.xhp\n"
"par_id331573510857418\n"
"help.text"
-msgid "<emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the characters are to be replaced."
-msgstr "<emph>Besedilo</emph>: besedilo ali sklic na celico, ki vsebuje besedilni izraz, v katerem naj se zamenjajo znaki."
+msgid "<emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the bytes are to be replaced."
+msgstr "<emph>Besedilo</emph>: besedilo ali sklic na celico, ki vsebuje besedilni izraz, v katerem naj se zamenjajo bajti."
#: func_replaceb.xhp
msgctxt ""
"func_replaceb.xhp\n"
"par_id431573510862075\n"
"help.text"
-msgid "<emph>Position</emph>: the character position from which text is to be replaced."
-msgstr "<emph>Položaj</emph>: položaj znaka, kjer bo zamenjano besedilo."
+msgid "<emph>Position</emph>: the byte position from which text is to be replaced."
+msgstr "<emph>Položaj</emph>: položaj bajta, kjer bo zamenjano besedilo."
#: func_replaceb.xhp
msgctxt ""
"func_replaceb.xhp\n"
"par_id481573510866260\n"
"help.text"
-msgid "<emph>Length</emph>: the number of characters to be replaced."
-msgstr "<emph>Dolžina</emph>: število znakov, ki bodo zamenjani."
+msgid "<emph>Length</emph>: the number of bytes to be replaced."
+msgstr "<emph>Dolžina</emph>: število bajtov, ki bodo zamenjani."
#: func_replaceb.xhp
msgctxt ""
@@ -57233,6 +57409,14 @@ msgctxt ""
msgid "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> returns \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" ."
msgstr "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> vrne \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" ."
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id721626381053212\n"
+"help.text"
+msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB\" name=\"REPLACEB_Wiki\">REPLACEB</link> wiki page for more details about this function."
+msgstr "Za podrobnosti o tej funkciji glejte <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB\" name=\"Stran wiki o funkciji REPLACEB\">stran wiki o funkciji REPLACEB</link> (v angl.)."
+
#: func_roundsig.xhp
msgctxt ""
"func_roundsig.xhp\n"
@@ -58145,6 +58329,118 @@ msgctxt ""
msgid "<item type=\"input\">TODAY()</item> returns the current computer system date."
msgstr "<item type=\"input\">TODAY()</item> vrne trenutni sistemski datum računalnika."
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"tit\n"
+"help.text"
+msgid "VALUE Function"
+msgstr "Funkcija VALUE"
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"bm_id831542233029549\n"
+"help.text"
+msgid "<bookmark_value>VALUE function</bookmark_value> <bookmark_value>text functions;convert text to numeric value</bookmark_value>"
+msgstr "<bookmark_value>funkcija VALUE</bookmark_value><bookmark_value>besedilne funkcije;pretvorba besedil v numerične vrednosti</bookmark_value>"
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"hd_id881628776094597\n"
+"help.text"
+msgid "<variable id=\"Value_h1\"><link href=\"text/scalc/01/func_value.xhp\" name=\"function VALUE\">VALUE</link></variable>"
+msgstr "<variable id=\"Value_h1\"><link href=\"text/scalc/01/func_value.xhp\" name=\"Funkcija VALUE\">VALUE</link></variable>"
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id541542230672101\n"
+"help.text"
+msgid "<variable id=\"func_value_desc\"><ahelp hid=\".\">Converts the string representation of a number to numeric form. If the supplied string is a valid date, time, or date-time, the corresponding date-time serial number is returned.</ahelp></variable>"
+msgstr "<variable id=\"func_value_desc\"><ahelp hid=\".\">Pretvori zapis števila kot niza v numerično obliko. Če je podani niz veljaven datum, čas ali datum-čas, vrne ustrezno serijsko število datum/čas.</ahelp></variable>"
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id701542231253817\n"
+"help.text"
+msgid "<input>VALUE(Text)</input>"
+msgstr "<input>=VALUE(Besedilo)</input>"
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id621542232197446\n"
+"help.text"
+msgid "<emph>Text</emph>: A string (in quotation marks), a number, or a reference to a cell containing one of those types, that contains the value to be converted."
+msgstr "<emph>Besedilo</emph>: besedilo (v narekovajih), število ali sklic na celico, ki vsebuje podatek ene od teh vrst z vrednostjo, ki naj se pretvori."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id731628787003937\n"
+"help.text"
+msgid "If the <emph>Text</emph> argument is a string representing a date, time, currency or a numeric value with decimal and thousands separators, the string must comply with current locale settings."
+msgstr "Če je argument <emph>besedilo</emph> niz, ki predstavlja datum, čas, valuto ali številsko vrednost z decimalnim ločilom in ločilom tisočic, mora biti niz skladen s trenutnimi krajevnimi nastavitvami."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id451628776707264\n"
+"help.text"
+msgid "<input>=VALUE(\"1234\")</input> returns the numeric value 1234."
+msgstr "<input>=VALUE(\"1234\")</input> vrne številsko vrednost 1234."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id101628778036375\n"
+"help.text"
+msgid "<input>=VALUE(\"+1,234.567\")</input> returns 1234.567 (considering en-US locale). Note that the \"+\" sign could have been omitted."
+msgstr "<input>=VALUE(\"+1,234.567\")</input> vrne 1234,567 (glede na krajevne nastavitve sl-SI). Upoštevajte, da bi lahko znak »+« izpustili."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id991628779914913\n"
+"help.text"
+msgid "<input>=VALUE(\"$100\")</input> returns 100 (considering en-US locale). Note that the currency prefix must match the current locale settings."
+msgstr "<input>=VALUE(\"100 EUR\")</input> vrne 100 (v primeru krajevnih nastavitev sl-SI). Upoštevajte, da mora biti predpona skladna s trenutnimi krajevnimi nastavitvami."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id101628780114427\n"
+"help.text"
+msgid "<input>=VALUE(\"50%\")</input> returns 0.5. Note that the character \"%\" causes the numeric part to be divided by 100."
+msgstr "<input>=VALUE(\"50%\")</input> vrne 0,5. Upoštevajte, da znak \"%\" povzroči, da se številski del deli s številom 100."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id731628780240876\n"
+"help.text"
+msgid "<input>=VALUE(\"07/30/2021\")</input> returns 44407 (considering en-US locale) which is the date-time sequence number corresponding to the specified date."
+msgstr "<input>=VALUE(\"30.07.2021\")</input> vrne 44407 (v primeru krajevnih nastavitev sl-SI), kar je sekvenčno število datum/čas glede na podani datum."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id501628780340635\n"
+"help.text"
+msgid "<input>=VALUE(\"09:20:25\")</input> returns 0.389178240740741 which is the date-time sequence number corresponding to the specified time value."
+msgstr "<input>=VALUE(\"09:20:25\")</input> vrne 0,389178240740741, kar je sekvenčno število datum/čas glede na podano časovno vrednost."
+
+#: func_value.xhp
+msgctxt ""
+"func_value.xhp\n"
+"par_id801628779804928\n"
+"help.text"
+msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\" name=\"VALUE Wiki\">VALUE</link> wiki page for more details about this function."
+msgstr "Za podrobnosti o tej funkciji glejte <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\" name=\"Stran wiki o funkciji VALUE\">stran wiki o funkciji VALUE</link> (v angl.)."
+
#: func_webservice.xhp
msgctxt ""
"func_webservice.xhp\n"
@@ -59470,8 +59766,8 @@ msgctxt ""
"live_data_stream.xhp\n"
"bm_id240920171018528200\n"
"help.text"
-msgid "<bookmark_value>Data Stream;Live data stream</bookmark_value>"
-msgstr "<bookmark_value>toki podatkov;živi toki podatkov</bookmark_value>"
+msgid "<bookmark_value>Data Stream;Live data stream</bookmark_value> <bookmark_value>Data Stream;Streams</bookmark_value>"
+msgstr "<bookmark_value>toki podatkov</bookmark_value><bookmark_value>podatki;toki</bookmark_value>"
#: live_data_stream.xhp
msgctxt ""
@@ -59486,24 +59782,24 @@ msgctxt ""
"live_data_stream.xhp\n"
"par_id240920171003293400\n"
"help.text"
-msgid "<ahelp hid=\".\">Live data stream for spreadsheets</ahelp>"
-msgstr "<ahelp hid=\".\">Živi tok podatkov za preglednice</ahelp>"
+msgid "<ahelp hid=\".\"><variable id=\"streams_desc\">Create live data streams for spreadsheets.</variable></ahelp>"
+msgstr "<ahelp hid=\".\"><variable id=\"streams_desc\">Ustvari žive toke podatkov za preglednice.</variable></ahelp>"
#: live_data_stream.xhp
msgctxt ""
"live_data_stream.xhp\n"
"par_id240920171007389295\n"
"help.text"
-msgid "Menu <item type=\"menuitem\">Data – Streams...</item>"
-msgstr "Izberite <item type=\"menuitem\">Podatki – Toki podatkov</item>"
+msgid "Menu <menuitem>Data – Streams...</menuitem>"
+msgstr "Izberite <menuitem>Podatki – Toki podatkov</menuitem>."
#: live_data_stream.xhp
msgctxt ""
"live_data_stream.xhp\n"
-"par_id240920171007419799\n"
+"par_id921633126951835\n"
"help.text"
-msgid "Data streams"
-msgstr "Toki podatkov"
+msgid "This is an experimental feature and is disabled by default. To enable it, go to <menuitem>Tools - Options - Advanced</menuitem> and check the option <emph>Enable experimental features (may be unstable)</emph>."
+msgstr "To je poskusna funkcionalnost in je privzeto onemogočena. Če jo želite omogočiti, izberite <switchinline select=\\\"sys\\\"><caseinline select=\\\"MAC\\\"><menuitem>%PRODUCTNAME – Nastavitve</menuitem></caseinline><defaultinline><menuitem>Orodja – Možnosti</menuitem></defaultinline></switchinline><menuitem> – %PRODUCTNAME – Napredno</menuitem> in potrdite polje <emph>Omogoči poskusne funkcionalnosti (lahko je nestabilno)</emph>.***"
#: solver.xhp
msgctxt ""
@@ -61278,24 +61574,24 @@ msgctxt ""
"statistics_descriptive.xhp\n"
"par_id1000690\n"
"help.text"
-msgid "Column 1"
-msgstr "Stolpec 1"
+msgid "Maths"
+msgstr "Matematika"
#: statistics_descriptive.xhp
msgctxt ""
"statistics_descriptive.xhp\n"
"par_id1000700\n"
"help.text"
-msgid "Column 2"
-msgstr "Stolpec 2"
+msgid "Physics"
+msgstr "Fizika"
#: statistics_descriptive.xhp
msgctxt ""
"statistics_descriptive.xhp\n"
"par_id1000710\n"
"help.text"
-msgid "Column 3"
-msgstr "Stolpec 3"
+msgid "Biology"
+msgstr "Biologija"
#: statistics_descriptive.xhp
msgctxt ""
@@ -61806,8 +62102,8 @@ msgctxt ""
"statistics_regression.xhp\n"
"bm_id2764278\n"
"help.text"
-msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value>"
-msgstr "<bookmark_value>dodatek Analiza;regresijska analiza</bookmark_value><bookmark_value>analitični dodatek;regresijska analiza</bookmark_value><bookmark_value>regresijska analiza;dodatek Analiza</bookmark_value><bookmark_value>statistika podatkov;regresijska analiza</bookmark_value>"
+msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value><bookmark_value>Confidence level;regression analysis</bookmark_value><bookmark_value>regression analysis;linear</bookmark_value><bookmark_value>regression analysis;power</bookmark_value><bookmark_value>regression analysis;logarithmic</bookmark_value>"
+msgstr "<bookmark_value>dodatek Analiza;regresijska analiza</bookmark_value><bookmark_value>regresijska analiza;dodatek Analiza</bookmark_value><bookmark_value>analitični dodatek;regresijska analiza</bookmark_value><bookmark_value>statistika podatkov;regresijska analiza</bookmark_value><bookmark_value>raven zaupanja;regresijska analiza</bookmark_value><bookmark_value>regresijska analiza;linearna</bookmark_value><bookmark_value>regresijska analiza;eksponentna</bookmark_value><bookmark_value>regresijska analiza;logaritemska</bookmark_value>"
#: statistics_regression.xhp
msgctxt ""
@@ -61822,8 +62118,16 @@ msgctxt ""
"statistics_regression.xhp\n"
"par_id1001240\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the regression analysis of a data set</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Izdela regresijsko analizo množice podatkov.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Performs linear, logarithmic, or power regression analysis of a data set comprising one dependent variable and multiple independent variables.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Izdela linearno, logaritemsko ali eksponentno regresijsko analizo množice podatkov, sestavljenih iz ene odvisne spremenljivke in več neodvisnih spremenljivk.</ahelp>"
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"par_id431629832333206\n"
+"help.text"
+msgid "For example, a crop yield (dependent variable) may be related to rainfall, temperature conditions, sunshine, humidity, soil quality and more, all of them independent variables."
+msgstr "Primer: donos posevka (odvisna spremenljivka) je morda povezana s količino padavin, vrednosti temperature, osončenosti, vlažnosti, kakovosti prsti idr., ki so vse neodvisne spremenljivke."
#: statistics_regression.xhp
msgctxt ""
@@ -61844,122 +62148,170 @@ msgstr "Več informacij o regresijski analizi najdete <link href=\"https://en.wi
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"hd_id1000070\n"
+"hd_id891629830986496\n"
"help.text"
-msgid "Output Regression Type"
-msgstr "Vrsta izhodne regresije"
+msgid "Data"
+msgstr "Podatki"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1001280\n"
+"hd_id101629830993962\n"
"help.text"
-msgid "Set the regression type. Three types are available:"
-msgstr "Določite vrsto regresije. Na voljo so tri vrste:"
+msgid "Independent variable(s) (X) range:"
+msgstr "Obseg neodvisne_ih spremenljivk_e (X):"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201620334364\n"
+"par_id961629834099308\n"
"help.text"
-msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data."
-msgstr "<emph>Linearna regresija</emph>: poišče ravno črto v obliki <item type=\"literal\">y = a.x + b</item>, kjer je <item type=\"literal\">a</item> naklon in <item type=\"literal\">b</item> presečišče, ki najbolj ustreza podatkom."
+msgid "Enter a single range that contains multiple independent variable observations (along columns or rows). All X variable observations need to be entered adjacent to each other in the same table."
+msgstr "Vnesite posamičen obseg, ki vsebuje več opazovanj neodvisnih spremenljivk (vzdolž stolpcev ali vrstic). Vsa opazovanja spremenljivke X je potrebno vnesti soležno ene k drugi v isti tabeli."
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201620340168\n"
+"hd_id871629830998653\n"
"help.text"
-msgid "<emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type=\"literal\">y = a.ln(x) + b</item>, where <item type=\"literal\">a</item> is the slope, <item type=\"literal\">b</item> is the intercept and <item type=\"literal\">ln(x)</item> is the natural logarithm of <item type=\"literal\">x</item>, that best fits the data."
-msgstr "<emph>Logaritemska regresija</emph>: poišče logaritemsko krivuljo v obliki <item type=\"literal\">y = a.ln(x) + b</item>, kjer je <item type=\"literal\">a</item> naklon, <item type=\"literal\">b</item> presečišče in <item type=\"literal\">ln(x)</item> naravni logaritem <item type=\"literal\">x</item>, ki najbolje ustreza podatkom."
+msgid "Dependent variable (Y) range:"
+msgstr "Obseg odvisne spremenljivke (Y):"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201620340139\n"
+"par_id391629834089370\n"
"help.text"
-msgid "<emph>Power regression</emph>: Find a power curve in the form of <item type=\"literal\">y = a.x^b</item>, where <item type=\"literal\">a</item> is the coefficient, <item type=\"literal\">b</item> is the power that best fits the data."
-msgstr "<emph>Eksponentna regresija</emph>: poišče eksponentno krivuljo v obliki <item type=\"literal\">y = a.x^b</item>, kjer je <item type=\"literal\">a</item> koeficient in <item type=\"literal\">b</item> eksponent, ki najbolj ustreza podatkom."
+msgid "Enter the range that contains the dependent variable whose regression is to be calculated."
+msgstr "Vnesite obseg, ki vsebuje odvisno spremenljivko, za katero bo izračunana regresija."
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1001310\n"
+"hd_id931629831003368\n"
"help.text"
-msgid "The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below."
-msgstr "Rezultati treh vrst <emph>regresijske analize</emph> meritev iz zgornje tabele so prikazani spodaj."
+msgid "Both X and Y ranges have labels"
+msgstr "Obsega X in Y imata oznake"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090526\n"
+"par_id261629834071776\n"
"help.text"
-msgid "Regression"
-msgstr "Regresija"
+msgid "Check to use the first line (or column) of the data sets as variable names in the output range."
+msgstr "Potrdite, če želite uporabiti prvo vrstico (ali stolpec) množic podatkov kot imena spremenljivk v izhodnem obsegu."
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090542\n"
+"hd_id11629831014811\n"
"help.text"
-msgid "Regression Model"
-msgstr "Model regresije"
+msgid "Results to:"
+msgstr "Rezultati v:"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090596\n"
+"par_id441629834000533\n"
"help.text"
-msgid "Linear"
-msgstr "Linearno"
+msgid "The reference of the top left cell of the range where the results will be displayed."
+msgstr "Sklic na levo vrhnjo celico obsega, kjer naj bodo prikazani rezultati."
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090586\n"
+"hd_id1000070\n"
"help.text"
-msgid "Logarithmic"
-msgstr "Logaritemska"
+msgid "Output Regression Types"
+msgstr "Vrste izhodne regresije"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090555\n"
+"par_id1001280\n"
"help.text"
-msgid "Power"
-msgstr "Potenčna"
+msgid "Set the regression type. Three types are available:"
+msgstr "Določite vrsto regresije. Na voljo so tri vrste:"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090553\n"
+"par_id1701201620334364\n"
"help.text"
-msgid "R^2"
-msgstr "R^2"
+msgid "<emph>Linear Regression</emph>: finds a linear function in the form of y = b + a<sub>1</sub>.[x<sub>1</sub>] + a<sub>2</sub>.[x<sub>2</sub>] + a<sub>3</sub>.[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th slope, [x<sub>i</sub>] is the i-th independent variable, and b is the intercept that best fits the data."
+msgstr "<emph>Linearna regresija</emph>: poišče linearno funkcijo v obliki y = b + a<sub>1</sub>.[x<sub>1</sub>] + a<sub>2</sub>.[x<sub>2</sub>] + a<sub>3</sub>.[x<sub>3</sub>] ..., kjer je a<sub>i</sub> i-ti naklon, [x<sub>i</sub>] i-ta neodvisna spremenljivka, b pa presečišče, ki najbolje ustreza podatkom."
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090595\n"
+"par_id1701201620340168\n"
"help.text"
-msgid "Standard Error"
-msgstr "Standardna napaka"
+msgid "<emph>Logarithmic regression</emph>: finds a logarithmic curve in the form of y = b + a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th coefficient, b is the intercept and ln[x<sub>i</sub>] is the natural logarithm of the i-th independent variable, that best fits the data."
+msgstr "<emph>Logaritemska regresija</emph>: poišče logaritemsko krivuljo v obliki y = b + a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>], kjer je <sub>i</sub> i-ti koeficient, b presečišče in ln[x<sub>i</sub>] naravni logaritem i-te neodvisne spremenljivke, ki najbolje ustreza podatkom."
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"par_id1701201620340139\n"
+"help.text"
+msgid "<emph>Power regression</emph>: finds a power curve in the form of y = exp( b + a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ...), where a<sub>i</sub> is the i-th power, [x<sub>i</sub>] is the i-th independent variable, and b is intercept that best fits the data."
+msgstr "<emph>Eksponentna regresija</emph>: poišče eksponentno krivuljo v obliki y = exp( b + a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ..., kjer je <sub>i</sub> i-ta potenca, [x<sub>i</sub>] i-ta neodvisna spremenljivka, b pa presečišče, ki najbolje ustreza podatkom."
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"hd_id331629834218606\n"
+"help.text"
+msgid "Options"
+msgstr "Možnosti"
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"hd_id481629834269509\n"
+"help.text"
+msgid "Confidence level"
+msgstr "Raven zaupanja"
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"par_id971629835636129\n"
+"help.text"
+msgid "A numeric value between 0 and 1 (exclusive), default is 0.95. Calc uses this percentage to compute the corresponding confidence intervals for each of the estimates (namely the slopes and intercept)."
+msgstr "Številska vrednost med 0 in 1 (izključujoče obe vrednosti), privzeto ima vrednost 0,95. Calc uporablja ta odstotek za izračun ustreznih intervalov zaupanja za vsako od ocenjenih vrednosti (in sicer naklonov in presečišča)."
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"hd_id751629834274709\n"
+"help.text"
+msgid "Calculate residuals"
+msgstr "Izračunaj preostanke"
+
+#: statistics_regression.xhp
+msgctxt ""
+"statistics_regression.xhp\n"
+"par_id401629835408653\n"
+"help.text"
+msgid "Select whether to opt in or out of computing the residuals, which may be beneficial in cases where you are interested only in the slopes and intercept estimates and their statistics. The residuals give information on how far the actual data points deviate from the predicted data points, based on the regression model."
+msgstr "Določite, ali želite, da se preostanki izračunajo, kar je lahko koristno v primerih, ko vas zanimajo zgolj ocene naklonov in presečišč ter njihova statistika. Ostanki ponujajo informacije o tem, kako dejanske podatkovne točke odstopajo od napovedanih podatkovnih točk na osnovi modela regresije."
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090563\n"
+"hd_id861629834279039\n"
"help.text"
-msgid "Slope"
-msgstr "Naklon"
+msgid "Force intercept to be zero"
+msgstr "Vsili nič za presečišče"
#: statistics_regression.xhp
msgctxt ""
"statistics_regression.xhp\n"
-"par_id1701201618090642\n"
+"par_id121629837424848\n"
"help.text"
-msgid "Intercept"
-msgstr "Presečišče"
+msgid "Calculates the regression model using zero as the intercept, thus forcing the model to pass through the origin."
+msgstr "Izračuna model regresije z uporabo nič kot presečiščem, kar vsili model, da prečka izhodišče."
#: statistics_sampling.xhp
msgctxt ""