Updated Slovenian translation

Change-Id: I746c06d065b19e021d5c76dfd90d779e4ea79c2a

1 files changed, 352 insertions, 282 deletions

diff --git a/source/sl/helpcontent2/source/text/scalc/01.po b/source/sl/helpcontent2/source/text/scalc/01.po
index d6b9c882f33..2fdb3f7adf5 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 5.3\n"
+"Project-Id-Version: LibreOffice 5.4\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2016-11-20 22:22+0100\n"
-"PO-Revision-Date: 2016-11-22 00:01+0200\n"
+"POT-Creation-Date: 2017-04-10 17:20+0200\n"
+"PO-Revision-Date: 2017-04-11 11:52+0200\n"
 "Last-Translator: Martin Srebotnjak <miles@filmsi.net>\n"
 "Language-Team: sl.libreoffice.org\n"
 "Language: sl\n"
@@ -218,8 +218,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_id3152994\n"
 "help.text"
-msgid "<image id=\"img_id3150515\" src=\"sw/imglst/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150515\">Icon</alt></image>"
-msgstr "<image id=\"img_id3150515\" src=\"sw/imglst/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150515\">Ikona</alt></image>"
+msgid "<image id=\"img_id3150515\" src=\"sw/res/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150515\">Icon</alt></image>"
+msgstr "<image id=\"img_id3150515\" src=\"sw/res/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150515\">Ikona</alt></image>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -253,8 +253,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_id3159170\n"
 "help.text"
-msgid "<image id=\"img_id3148871\" src=\"sw/imglst/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3148871\">Icon</alt></image>"
-msgstr "<image id=\"img_id3148871\" src=\"sw/imglst/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3148871\">Ikona</alt></image>"
+msgid "<image id=\"img_id3148871\" src=\"sw/res/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3148871\">Icon</alt></image>"
+msgstr "<image id=\"img_id3148871\" src=\"sw/res/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3148871\">Ikona</alt></image>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -288,8 +288,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_id3152869\n"
 "help.text"
-msgid "<image id=\"img_id3149126\" src=\"sw/imglst/sc20244.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3149126\">Icon</alt></image>"
-msgstr "<image id=\"img_id3149126\" src=\"sw/imglst/sc20244.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3149126\">Ikona</alt></image>"
+msgid "<image id=\"img_id3149126\" src=\"sw/res/sc20244.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3149126\">Icon</alt></image>"
+msgstr "<image id=\"img_id3149126\" src=\"sw/res/sc20244.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3149126\">Ikona</alt></image>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -323,8 +323,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_id3155597\n"
 "help.text"
-msgid "<image id=\"img_id3154738\" src=\"sw/imglst/sc20233.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154738\">Icon</alt></image>"
-msgstr "<image id=\"img_id3154738\" src=\"sw/imglst/sc20233.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154738\">Ikona</alt></image>"
+msgid "<image id=\"img_id3154738\" src=\"sw/res/sc20233.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154738\">Icon</alt></image>"
+msgstr "<image id=\"img_id3154738\" src=\"sw/res/sc20233.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154738\">Ikona</alt></image>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -358,8 +358,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_id3148745\n"
 "help.text"
-msgid "<image id=\"img_id3159256\" src=\"sc/imglst/na07.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3159256\">Icon</alt></image>"
-msgstr "<image id=\"img_id3159256\" src=\"sc/imglst/na07.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3159256\">Ikona</alt></image>"
+msgid "<image id=\"img_id3159256\" src=\"sc/res/na07.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3159256\">Icon</alt></image>"
+msgstr "<image id=\"img_id3159256\" src=\"sc/res/na07.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3159256\">Ikona</alt></image>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -391,8 +391,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_idN10A7B\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_SCENARIO_DELETE\">Deletes the selected scenario.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_SCENARIO_DELETE\">Izbriše izbrani scenarij.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/scenariomenu/delete\">Deletes the selected scenario.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/scenariomenu/delete\">Izbriše izbran scenarij.</ahelp>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -407,8 +407,8 @@ msgctxt ""
 "02110000.xhp\n"
 "par_idN10A96\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_SCENARIO_EDIT\">Opens the <link href=\"text/scalc/01/06050000.xhp\">Edit scenario</link> dialog, where you can edit the scenario properties.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_SCENARIO_EDIT\">Odpre pogovorno okno <link href=\"text/scalc/01/06050000.xhp\">Uredi scenarij</link>, kjer lahko urejate lastnosti scenarija.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/scenariomenu/edit\">Opens the <link href=\"text/scalc/01/06050000.xhp\">Edit scenario</link> dialog, where you can edit the scenario properties.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/scenariomenu/edit\">Odpre pogovorno okno <link href=\"text/scalc/01/06050000.xhp\">Uredi scenarij</link>, kjer lahko urejate lastnosti scenarija.</ahelp>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -460,8 +460,8 @@ msgctxt ""
 "par_id3146938\n"
 "30\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_DROPMODE_URL\">Inserts a hyperlink when you drag-and-drop an object from the Navigator into a document.</ahelp> You can later click the created hyperlink to set the cursor and the view to the respective object."
-msgstr "<ahelp hid=\"HID_SC_DROPMODE_URL\">Vstavi hiperpovezavo, ko povlečete in spustite predmet iz Krmarja v dokument.</ahelp> Kasneje lahko kliknete ustvarjeno hiperpovezavo, da bi kazalko in pogled prilagodili predmetu."
+msgid "<ahelp hid=\"modules/scalc/ui/dropmenu/hyperlink\">Inserts a hyperlink when you drag-and-drop an object from the Navigator into a document.</ahelp> You can later click the created hyperlink to set the cursor and the view to the respective object."
+msgstr "<ahelp hid=\"modules/scalc/ui/dropmenu/hyperlink\">Vstavi hiperpovezavo, ko povlečete in spustite predmet iz Krmarja v dokument.</ahelp> Kasneje lahko kliknete ustvarjeno hiperpovezavo, da bi kazalko in pogled prilagodili predmetu."
 
 #: 02110000.xhp
 msgctxt ""
@@ -486,8 +486,8 @@ msgctxt ""
 "par_id3150746\n"
 "32\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_DROPMODE_LINK\">Creates a link when you drag-and-drop an object from the Navigator into a document.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_DROPMODE_LINK\">Ustvari povezavo, ko povlečete in izpustite predmet iz Krmarja v dokument.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/dropmenu/link\">Creates a link when you drag-and-drop an object from the Navigator into a document.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/dropmenu/link\">Ustvari povezavo, ko povlečete in izpustite predmet iz Krmarja v dokument.</ahelp>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -504,8 +504,8 @@ msgctxt ""
 "par_id3147471\n"
 "34\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_DROPMODE_COPY\">Generates a copy when you drag-and-drop an object from the Navigator into a document.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_DROPMODE_COPY\">Ustvari kopijo, ko povlečete in izpustite predmet iz Krmarja v dokument.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/dropmenu/copy\">Generates a copy when you drag-and-drop an object from the Navigator into a document.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/dropmenu/copy\">Ustvari kopijo, ko povlečete in izpustite predmet iz Krmarja v dokument.</ahelp>"
 
 #: 02110000.xhp
 msgctxt ""
@@ -2423,7 +2423,7 @@ msgctxt ""
 "7\n"
 "help.text"
 msgid "You cannot delete a sheet while <emph>Edit - Track Changes - Record Changes</emph> is activated."
-msgstr "Delovnega lista ne morete izbrisati, če je vklopljeno sledenje spremembam z ukazom <emph>Uredi – Sledenje spremembam – Beleži spremembe</emph>."
+msgstr "Delovnega lista ne morete izbrisati, če je vklopljeno sledenje spremembam z ukazom <emph>Uredi – Sledi spremembam – Beleži spremembe</emph>."
 
 #: 02170000.xhp
 msgctxt ""
@@ -3582,8 +3582,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_idN105D1\n"
 "help.text"
-msgid "<ahelp hid=\"26275\">Inserts a sheet from a different spreadsheet file.</ahelp>"
-msgstr "<ahelp hid=\"26275\">Vstavi delovni list iz druge preglednice.</ahelp>"
+msgid "<ahelp hid=\".\">Inserts a sheet from a different spreadsheet file.</ahelp>"
+msgstr "<ahelp hid=\".\">Vstavi delovni list iz druge preglednice.</ahelp>"
 
 #: 04050100.xhp
 msgctxt ""
@@ -3632,8 +3632,8 @@ msgctxt ""
 "par_id3145271\n"
 "2\n"
 "help.text"
-msgid "<variable id=\"funktionsautopilottext\"><ahelp hid=\".uno:FunctionDialog\">Opens the <emph>Function Wizard</emph>, which helps you to interactively create formulas.</ahelp></variable> Before you start the Wizard, select a cell or a range of cells from the current sheet, in order to determine the position at which the formula will be inserted."
-msgstr "<variable id=\"funktionsautopilottext\"><ahelp hid=\".uno:FunctionDialog\">Odpre <emph>Čarovnika za funkcije</emph>, ki vam interaktivno pomaga pri pisanju formul.</ahelp></variable> Preden zaženete Čarovnika, izberite celico ali obseg celic na trenutnem delovnem listu in tako določite mesto, kamor bo formula vstavljena."
+msgid "<variable id=\"funktionsautopilottext\"><ahelp hid=\".\">Opens the <emph>Function Wizard</emph>, which helps you to interactively create formulas.</ahelp></variable> Before you start the Wizard, select a cell or a range of cells from the current sheet, in order to determine the position at which the formula will be inserted."
+msgstr "<variable id=\"funktionsautopilottext\"><ahelp hid=\".\">Odpre <emph>Čarovnika za funkcije</emph>, ki vam interaktivno pomaga pri pisanju formul.</ahelp></variable> Preden zaženete Čarovnika, izberite celico ali obseg celic na trenutnem delovnem listu in tako določite mesto, kamor bo formula vstavljena."
 
 #: 04060000.xhp
 msgctxt ""
@@ -3664,11 +3664,19 @@ msgstr "Zavihek Funkcije"
 #: 04060000.xhp
 msgctxt ""
 "04060000.xhp\n"
-"par_id3149378\n"
-"5\n"
+"hd_id3154731\n"
+"help.text"
+msgid "Search"
+msgstr "Išči"
+
+#: 04060000.xhp
+#, fuzzy
+msgctxt ""
+"04060000.xhp\n"
+"par_id3155440\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/04060100.xhp\" name=\"List of Categories and Functions\">List of Categories and Functions</link>"
-msgstr "<link href=\"text/scalc/01/04060100.xhp\" name=\"Seznam kategorij in funkcij\">Seznam kategorij in funkcij</link>"
+msgid "<ahelp hid=\"formula/ui/functionpage/search\">Search for a part of the function name.</ahelp>"
+msgstr "<ahelp hid=\"formula/ui/functionpage/search\">Iščite po delu imena funkcije.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
@@ -3685,8 +3693,16 @@ msgctxt ""
 "par_id3153417\n"
 "37\n"
 "help.text"
-msgid "<variable id=\"kategorienliste\"><ahelp hid=\"SC:LISTBOX:RID_SCTAB_FUNCTION:LB_CATEGORY\">Lists all the categories to which the different functions are assigned. Select a category to view the appropriate functions in the list field below.</ahelp> Select \"All\" to view all functions in alphabetical order, irrespective of category. \"Last Used\" lists the functions you have most recently used. </variable>"
-msgstr "<variable id=\"kategorienliste\"><ahelp hid=\"SC:LISTBOX:RID_SCTAB_FUNCTION:LB_CATEGORY\">Našteje vse kategorije, ki so jim dodeljene različne funkcije. Ko izberete kategorijo, se v seznamskem polju pos njim pokažejo ustrezne funkcije.</ahelp> Za prikaz vseh funkcij po abecednem redu, ne glede na kategorijo, izberite »Vse«. »Nazadnje uporabljeno« pokaže seznam funkcij, ki ste jih nazadnje uporabili. </variable>"
+msgid "<variable id=\"kategorienliste\"><ahelp hid=\"formula/ui/functionpage/category\">Lists all the categories to which the different functions are assigned. Select a category to view the appropriate functions in the list field below.</ahelp> Select \"All\" to view all functions in alphabetical order, irrespective of category. \"Last Used\" lists the functions you have most recently used. </variable>"
+msgstr "<variable id=\"kategorienliste\"><ahelp hid=\"formula/ui/functionpage/category\">Našteje vse kategorije, ki so jim dodeljene različne funkcije. Ko izberete kategorijo, se v seznamskem polju pos njim pokažejo ustrezne funkcije.</ahelp> Za prikaz vseh funkcij po abecednem redu, ne glede na kategorijo, izberite »Vse«. »Nazadnje uporabljeno« pokaže seznam funkcij, ki ste jih nazadnje uporabili. </variable>"
+
+#: 04060000.xhp
+msgctxt ""
+"04060000.xhp\n"
+"par_id3149378\n"
+"help.text"
+msgid "You can browse the full <link href=\"text/scalc/01/04060100.xhp\" name=\"List of Categories and Functions\">List of Categories and Functions</link>"
+msgstr "Ogledate si lahko tudi celoten <link href=\"text/scalc/01/04060100.xhp\" name=\"Seznam kategorij in funkcij\">seznam kategorij in funkcij</link>."
 
 #: 04060000.xhp
 msgctxt ""
@@ -3703,8 +3719,8 @@ msgctxt ""
 "par_id3155445\n"
 "7\n"
 "help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCTAB_FUNCTION:LB_FUNCTION\">Displays the functions found under the selected category. Double-click to select a function.</ahelp> A single-click displays a short function description."
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCTAB_FUNCTION:LB_FUNCTION\">Prikaže funkcije, ki so v izbrani kategoriji. Dvokliknite funkcijo, ki jo želite izbrati.</ahelp> Če kliknete samo enkrat, se prikaže kratek opis funkcije."
+msgid "<ahelp hid=\"formula/ui/functionpage/function\">Displays the functions found under the selected category. Double-click to select a function.</ahelp> A single-click displays a short function description."
+msgstr "<ahelp hid=\"formula/ui/functionpage/function\">Prikaže funkcije, ki so v izbrani kategoriji. Dvokliknite funkcijo, ki jo želite izbrati.</ahelp> Če kliknete samo enkrat, se prikaže kratek opis funkcije."
 
 #: 04060000.xhp
 msgctxt ""
@@ -3721,8 +3737,8 @@ msgctxt ""
 "par_id3149566\n"
 "9\n"
 "help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_FORMULA:BTN_MATRIX\">Specifies that the selected function is inserted into the selected cell range as an array formula. </ahelp> Array formulas operate on multiple cells. Each cell in the array contains the formula, not as a copy but as a common formula shared by all matrix cells."
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_FORMULA:BTN_MATRIX\">Določi, da se izbrana funkcija v izbrani obseg celic vstavi kot matrična formula. </ahelp>Matrične formule delujejo v več celicah. Vsaka celica v matriki vsebuje formulo, ne kot kopijo, ampak kot skupno formulo, ki si jo delijo vse matrične celice."
+msgid "<ahelp hid=\"formula/ui/formuladialog/array\">Specifies that the selected function is inserted into the selected cell range as an array formula. </ahelp> Array formulas operate on multiple cells. Each cell in the array contains the formula, not as a copy but as a common formula shared by all matrix cells."
+msgstr "<ahelp hid=\"formula/ui/formuladialog/array\">Določi, da se izbrana funkcija v izbrani obseg celic vstavi kot matrična formula. </ahelp>Matrične formule delujejo v več celicah. Vsaka celica v matriki vsebuje formulo, ne kot kopijo, ampak kot skupno formulo, ki si jo delijo vse matrične celice."
 
 #: 04060000.xhp
 msgctxt ""
@@ -3802,8 +3818,8 @@ msgctxt ""
 "par_id3157980\n"
 "24\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_FAP_BTN_FX4\">Allows you to access a subordinate level of the <emph>Function Wizard</emph> in order to nest another function within the function, instead of a value or reference.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_FAP_BTN_FX4\">Omogoči dostop do podrejene stopnje <emph>Čarovnika za funkcije</emph>, da lahko namesto vrednosti ali sklica ugnezdite funkcijo znotraj funkcije.</ahelp>"
+msgid "<ahelp hid=\".\">Allows you to access a subordinate level of the <emph>Function Wizard</emph> in order to nest another function within the function, instead of a value or reference.</ahelp>"
+msgstr "<ahelp hid=\".\">Omogoči dostop do podrejene stopnje <emph>Čarovnika za funkcije</emph>, da lahko namesto vrednosti ali sklica ugnezdite funkcijo znotraj funkcije.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
@@ -3820,8 +3836,8 @@ msgctxt ""
 "par_id3159097\n"
 "26\n"
 "help.text"
-msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_FORMULA:ED_REF\">The number of visible text fields depends on the function. Enter arguments either directly into the argument fields or by clicking a cell in the table.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_FORMULA:ED_REF\">Število besedilnih polj je odvisno od funkcije. Argumente lahko vnesete neposredno v polja za argumente ali pa s klikom celice v tabeli.</ahelp>"
+msgid "The number of visible text fields depends on the function. Enter arguments either directly into the argument fields or by clicking a cell in the table."
+msgstr "Število vidnih besedilnih polj je odvisno od funkcije. Argumente lahko vnesete neposredno v polja za argumente ali pa s klikom celice v tabeli."
 
 #: 04060000.xhp
 msgctxt ""
@@ -3838,8 +3854,8 @@ msgctxt ""
 "par_id3150211\n"
 "52\n"
 "help.text"
-msgid "Displays the calculation result or an error message."
-msgstr "Prikaže rezultat računa ali sporočilo o napaki."
+msgid "<ahelp hid=\"formula/ui/formuladialog/formula_result\">Displays the calculation result or an error message.</ahelp>"
+msgstr "<ahelp hid=\"formula/ui/formuladialog/formula_result\">Prikaže rezultat računa ali sporočilo o napaki.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
@@ -3856,8 +3872,8 @@ msgctxt ""
 "par_id3149898\n"
 "44\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_FAP_FORMULA\">Displays the created formula. Type your entries directly, or create the formula using the wizard.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_FAP_FORMULA\">Prikaže ustvarjeno formulo. Formulo vnesite neposredno ali pa jo ustvarite s čarovnikom.</ahelp>"
+msgid "<ahelp hid=\"formula/ui/formuladialog/ed_formula\">Displays the created formula. Type your entries directly, or create the formula using the wizard.</ahelp>"
+msgstr "<ahelp hid=\"formula/ui/formuladialog/ed_formula\">Prikaže ustvarjeno formulo. Formulo vnesite neposredno ali pa jo ustvarite s čarovnikom.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
@@ -3874,8 +3890,8 @@ msgctxt ""
 "par_id3152869\n"
 "53\n"
 "help.text"
-msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_BACKWARD\">Moves the focus back through the formula components, marking them as it does so.</ahelp>"
-msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_BACKWARD\">Premakne pozornost nazaj po komponentah formule in jih pri tem označuje.</ahelp>"
+msgid "<ahelp hid=\"formula/ui/formuladialog/back\">Moves the focus back through the formula components, marking them as it does so.</ahelp>"
+msgstr "<ahelp hid=\"formula/ui/formuladialog/back\">Premakne pozornost nazaj po komponentah formule in jih pri tem označuje.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
@@ -3901,8 +3917,8 @@ msgctxt ""
 "par_id3149316\n"
 "55\n"
 "help.text"
-msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD\">Moves forward through the formula components in the formula window.</ahelp> This button can also be used to assign functions to the formula. If you select a function and click the <emph>Next </emph>button, the selection appears in the formula window."
-msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD\">S tem ukazom se premikate naprej po komponentah v oknu s formulo.</ahelp>S tem gumbom lahko formuli tudi dodelite funkcije. Če izberete funkcijo in kliknete na gumb <emph>Naslednji</emph>, se bo izbrana funkcija pokazala v oknu s formulo."
+msgid "<ahelp hid=\"formula/ui/formuladialog/next\">Moves forward through the formula components in the formula window.</ahelp> This button can also be used to assign functions to the formula. If you select a function and click the <emph>Next </emph>button, the selection appears in the formula window."
+msgstr "<ahelp hid=\"formula/ui/formuladialog/next\">S tem ukazom se premikate naprej po komponentah v oknu s formulo.</ahelp> S tem gumbom lahko formuli tudi dodelite funkcije. Če izberete funkcijo in kliknete na gumb <emph>Naslednji</emph>, se bo izbrana funkcija pokazala v oknu s formulo."
 
 #: 04060000.xhp
 msgctxt ""
@@ -3916,24 +3932,6 @@ msgstr "Dvokliknite funkcijo v izbirnem oknu, če jo želite prenesti v okno s f
 #: 04060000.xhp
 msgctxt ""
 "04060000.xhp\n"
-"hd_id3148745\n"
-"58\n"
-"help.text"
-msgid "Cancel"
-msgstr "Prekliči"
-
-#: 04060000.xhp
-msgctxt ""
-"04060000.xhp\n"
-"par_id3147402\n"
-"59\n"
-"help.text"
-msgid "Closes the dialog without implementing the formula."
-msgstr "Pogovorno okno se zapre, ne da bi se formula izvedla."
-
-#: 04060000.xhp
-msgctxt ""
-"04060000.xhp\n"
 "hd_id3150534\n"
 "32\n"
 "help.text"
@@ -3946,17 +3944,26 @@ msgctxt ""
 "par_id3153029\n"
 "33\n"
 "help.text"
-msgid "Ends the <emph>Function Wizard</emph>, and transfers the formula to the selected cells."
-msgstr "Zapre <emph>Čarovnika za funkcije</emph> in prenese formulo v izbrane celice."
+msgid "<ahelp hid=\"formula/ui/formuladialog/ok\">Ends the <emph>Function Wizard</emph>, and transfers the formula to the selected cells.</ahelp>"
+msgstr "<ahelp hid=\"formula/ui/formuladialog/ok\">Zapre <emph>Čarovnika za funkcije</emph> in prenese formulo v izbrane celice.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
 "04060000.xhp\n"
-"par_id3156400\n"
-"34\n"
+"hd_id3148745\n"
+"58\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/04060100.xhp\" name=\"List of Categories and Functions\">List of Categories and Functions</link>"
-msgstr "<link href=\"text/scalc/01/04060100.xhp\" name=\"Seznam kategorij in funkcij\">Seznam kategorij in funkcij</link>"
+msgid "Cancel"
+msgstr "Prekliči"
+
+#: 04060000.xhp
+msgctxt ""
+"04060000.xhp\n"
+"par_id3147402\n"
+"59\n"
+"help.text"
+msgid "<ahelp hid=\"formula/ui/formuladialog/cancel\">Closes the dialog without implementing the formula.</ahelp>"
+msgstr "<ahelp hid=\"formula/ui/formuladialog/cancel\">Pogovorno okno se zapre, ne da bi se formula izvedla.</ahelp>"
 
 #: 04060000.xhp
 msgctxt ""
@@ -4000,8 +4007,8 @@ msgctxt ""
 "par_id3150481\n"
 "50\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_FAP_STRUCT\">Displays a hierarchical representation of the current function.</ahelp> You can hide or show the arguments by a click on the plus or minus sign in front."
-msgstr "<ahelp hid=\"HID_SC_FAP_STRUCT\">Pokaže hierarhičen prikaz trenutne funkcije.</ahelp>Argumente lahko skrijete ali pokažete tako, da kliknete na plus ali minus pred argumentom."
+msgid "<ahelp hid=\"formula/ui/structpage/struct\">Displays a hierarchical representation of the current function.</ahelp> You can hide or show the arguments by a click on the plus or minus sign in front."
+msgstr "<ahelp hid=\"formula/ui/structpage/struct\">Pokaže hierarhičen prikaz trenutne funkcije.</ahelp> Argumente lahko skrijete ali pokažete tako, da kliknete na plus ali minus pred argumentom."
 
 #: 04060000.xhp
 msgctxt ""
@@ -5673,22 +5680,6 @@ msgctxt ""
 msgid "Functions"
 msgstr "Funkcije"
 
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id231020162315043955\n"
-"help.text"
-msgid "<embed href=\"text/scalc/01/func_networkdays.intl.xhp#networkdaysintl\"/>"
-msgstr "<embed href=\"text/scalc/01/func_networkdays.intl.xhp#networkdaysintl\"/>"
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id231020163315043955\n"
-"help.text"
-msgid "<embed href=\"text/scalc/01/func_workdays.intl.xhp#workdaysintl\"/>"
-msgstr "<embed href=\"text/scalc/01/func_workdays.intl.xhp#workdaysintl\"/>"
-
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
@@ -7700,6 +7691,14 @@ msgstr "<ahelp hid=\"HID_FUNC_IKV\">Izračuna notranje obrestne mere dobička za
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
+"par_idN10E621\n"
+"help.text"
+msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">XIRR</link> function."
+msgstr "Če plačila niso opravljena ob rednih intervalih, uporabite funkcijo <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">XIRR</link>."
+
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
 "hd_id3150599\n"
 "130\n"
 "help.text"
@@ -13648,7 +13647,7 @@ msgctxt ""
 "par_id3163792\n"
 "help.text"
 msgid "If the spreadsheet is exported to MS Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
-msgstr "Če preglednico izvozite v zapisu MS Excel, se funkcija CEILING izvozi kot enakovredna funkcija CEILING.MATH, ki obstaja od različice Excel 2013. Če nameravate uporabljati preglednico z zgodnejšimi različicami Excela, uporabite CEILING.PRECISE, ki obstaja od Excel 2010, ali CEILING.XCL, ki se izvozi kot funkcija CEILING, združljiva z vsemi različicami Excela. Upoštevajte, da CEILING.XCL vedno zaokroža na vrednost stran od nič."
+msgstr "Če preglednico izvozite v zapisu MS Excel, se funkcija CEILING izvozi kot enakovredna funkcija CEILING.MATH, ki obstaja od različice Excel 2013 naprej. Če nameravate uporabljati preglednico z zgodnejšimi različicami Excela, uporabite CEILING.PRECISE, ki obstaja od Excel 2010, ali CEILING.XCL, ki se izvozi kot funkcija CEILING, združljiva z vsemi različicami Excela. Upoštevajte, da CEILING.XCL vedno zaokroža na vrednost stran od nič."
 
 #: 04060106.xhp
 msgctxt ""
@@ -16104,7 +16103,7 @@ msgctxt ""
 "par_id3163894\n"
 "help.text"
 msgid "If the spreadsheet is exported to MS Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
-msgstr "Če preglednico izvozite v zapisu MS Excel, se funkcija FLOOR izvozi kot enakovredna funkcija FLOOR.MATH, ki obstaja od različice Excel 2013. Če nameravate uporabljati preglednico z zgodnejšimi različicami Excela, uporabite FLOOR.PRECISE, ki obstaja od Excel 2010, ali FLOOR.XCL, ki se izvozi kot funkcija FLOOR, združljiva z vsemi različicami Excela. Upoštevajte, da FLOOR.XCL vedno zaokroža na vrednost proti nič."
+msgstr "Če preglednico izvozite v zapisu MS Excel, se funkcija FLOOR izvozi kot enakovredna funkcija FLOOR.MATH, ki obstaja od različice Excel 2013 naprej. Če nameravate uporabljati preglednico z zgodnejšimi različicami Excela, uporabite FLOOR.PRECISE, ki obstaja od Excel 2010, ali FLOOR.XCL, ki se izvozi kot funkcija FLOOR, združljiva z vsemi različicami Excela. Upoštevajte, da FLOOR.XCL vedno zaokroža na vrednost proti nič."
 
 #: 04060106.xhp
 msgctxt ""
@@ -20331,7 +20330,7 @@ msgctxt ""
 "par_id3154842\n"
 "32\n"
 "help.text"
-msgid "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item>applications have the server name \"soffice\"."
+msgid "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"soffice\"."
 msgstr "<emph>strežnik</emph> je ime strežniškega programa. Programi <item type=\"productname\">%PRODUCTNAME</item> imajo strežniško ime »soffice«."
 
 #: 04060109.xhp
@@ -20644,8 +20643,8 @@ msgctxt ""
 "par_id3150691\n"
 "57\n"
 "help.text"
-msgid "<item type=\"input\">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names - Define</emph>."
-msgstr "<item type=\"input\">=INDEX(SumX;4;1)</item> vrne vrednost iz območja <emph>VsotaX</emph> iz 4. vrstice in 1. stolpca, kot ga določimo v <emph>Vstavi – Imena – Določi</emph>."
+msgid "<item type=\"input\">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>."
+msgstr "<item type=\"input\">=INDEX(VsotaX;4;1)</item> vrne vrednost iz območja <emph>VsotaX</emph> iz 4. vrstice in 1. stolpca, kot ga določimo v <emph>Delovni list – Imenovani obsegi in izrazi – Določi</emph>."
 
 #: 04060109.xhp
 msgctxt ""
@@ -20669,8 +20668,8 @@ msgctxt ""
 "par_id3158419\n"
 "58\n"
 "help.text"
-msgid "<item type=\"input\">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Insert - Names - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type=\"input\">2</item> as the <emph>range</emph> parameter."
-msgstr "<item type=\"input\">=INDEX((multi);4;1)</item> nakazuje na vrednost, vsebovano v 4. vrstici in 1. stolpcu, kot ste jo poimenovali v <emph>Vstavi – Imena – Določi</emph>, kot <emph>večkratno</emph>. Večkratni obseg lahko sestavlja več pravokotnih obsegov, vsak z vrstico 4 in stolpcem 1. Če zdaj želite priklicati drugi blok tega večkratnega obsega, vnesite število <item type=\"input\">2</item> kot parameter <emph>obsega</emph>."
+msgid "<item type=\"input\">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Sheet - Named Ranges and Expressions - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type=\"input\">2</item> as the <emph>range</emph> parameter."
+msgstr "<item type=\"input\">=INDEX((večkratno);4;1)</item> nakazuje na vrednost, vsebovano v 4. vrstici in 1. stolpcu, kot ste jo poimenovali v <emph>Delovni list – Imenovani obsegi in izrazi – Določi</emph>, kot <emph>večkratno</emph>. Večkratni obseg lahko sestavlja več pravokotnih obsegov, vsak z vrstico 4 in stolpcem 1. Če zdaj želite priklicati drugi blok tega večkratnega obsega, vnesite število <item type=\"input\">2</item> kot parameter <emph>obsega</emph>."
 
 #: 04060109.xhp
 msgctxt ""
@@ -21023,7 +21022,7 @@ msgctxt ""
 "88\n"
 "help.text"
 msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order."
-msgstr "<ahelp hid=\"HID_FUNC_SVERWEIS\">Navpično iskanje s sklicem na sosednje celice na desni.</ahelp> Ta funkcija preverja, če se v prvem stolpcu matrike nahaja določena vrednost. Funkcija potem vrne vrednost, ki se nahaja v isti vrstici, in sicer v stolpcu, ki ga navedete v <item type=\"literal\">kazalu</item>. Če je parameter <item type=\"literal\">vrstni_red_razvrščanja</item> izpuščen ali nastavljen na TRUE, se privzame, da gre za podatke, ki so razvrščeni v naraščajočem vrstnem redu. Če <item type=\"literal\">iskalnemu_pogoju</item> natanko enaka vrednost ni najdena, funkcija vrne zadnjo vrednost, ki je bila manjša od iskane. Če nastavite <item type=\"literal\">vrstni_red_razvrščanja</item> na FALSE ali na nič, funkcija najde točno isto vrednost, ali pa vrne kot rezultat napako <emph>Napaka: vrednost ni na voljo</emph>. Zato pri vrednosti nič ni potrebno, da so podatki razvrščeni v naraščajočem vrstnem redu."
+msgstr "<ahelp hid=\"HID_FUNC_SVERWEIS\">Navpično iskanje s sklicem na sosednje celice na desni.</ahelp> Ta funkcija preverja, če se v prvem stolpcu matrike nahaja določena vrednost. Funkcija potem vrne vrednost, ki se nahaja v isti vrstici, in sicer v stolpcu, ki ga navedete v <item type=\"literal\">kazalu</item>. Če je parameter <item type=\"literal\">razvrščeno</item> izpuščen ali nastavljen na TRUE, se privzame, da gre za podatke, ki so razvrščeni v naraščajočem vrstnem redu. Če <item type=\"literal\">iskalnemu_pogoju</item> natanko enaka vrednost ni najdena, funkcija vrne zadnjo vrednost, ki je bila manjša od iskane. Če nastavite <item type=\"literal\">razvrščeno</item> na FALSE ali na nič, funkcija najde točno isto vrednost, ali pa vrne kot rezultat napako <emph>Napaka: vrednost ni na voljo</emph>. Zato pri vrednosti nič ni potrebno, da so podatki razvrščeni v naraščajočem vrstnem redu."
 
 #: 04060109.xhp
 msgctxt ""
@@ -32414,8 +32413,8 @@ msgctxt ""
 "04060118.xhp\n"
 "par_idN10E62\n"
 "help.text"
-msgid "If the payments take place at regular intervals, use the IRR function."
-msgstr "Če so plačila opravljena ob rednih intervalih, uporabite funkcijo IRR."
+msgid "If the payments take place at regular intervals, use the <link href=\"text/scalc/01/04060103.xhp#irr\" name=\"IRR\">IRR</link> function."
+msgstr "Če so plačila opravljena ob rednih intervalih, uporabite funkcijo <link href=\"text/scalc/01/04060103.xhp#irr\" name=\"IRR\">IRR</link>."
 
 #: 04060118.xhp
 msgctxt ""
@@ -32654,7 +32653,7 @@ msgctxt ""
 "04060118.xhp\n"
 "par_id3153904\n"
 "help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_XNPV\">Calculates the capital value (net present value)for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years."
+msgid "<ahelp hid=\"HID_AAI_FUNC_XNPV\">Calculates the capital value (net present value) for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years."
 msgstr "<ahelp hid=\"HID_AAI_FUNC_XNPV\">Izračuna čisto vrednost (neto) za seznam plačil, opravljene ob različnih datumih.</ahelp> Izračun temelji na osnovi 365 dni na leti, brez prestopnih let."
 
 #: 04060118.xhp
@@ -32662,8 +32661,8 @@ msgctxt ""
 "04060118.xhp\n"
 "par_idN11138\n"
 "help.text"
-msgid "If the payments take place at regular intervals, use the NPV function."
-msgstr "Če se plačila opravijo ob rednih intervalih, uporabite funkcijo NPV."
+msgid "If the payments take place at regular intervals, use the <link href=\"text/scalc/01/04060119.xhp#npv\" name=\"NPV\">NPV</link> function."
+msgstr "Če se plačila opravijo ob rednih intervalih, uporabite funkcijo <link href=\"text/scalc/01/04060119.xhp#npv\" name=\"NPV\">NPV</link>."
 
 #: 04060118.xhp
 msgctxt ""
@@ -35382,7 +35381,6 @@ msgstr "NPV"
 msgctxt ""
 "04060119.xhp\n"
 "par_id3145308\n"
-"302\n"
 "help.text"
 msgid "<ahelp hid=\"HID_FUNC_NBW\">Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_NBW\">Vrne trenutno vrednost naložbe na osnovi niza plačil po obdobjih in diskontne stopnje. Neto trenutno vrednost dobimo tako, da od vrnjene vrednosti odštejemo stroške projekta (začetno plačilo).</ahelp>"
@@ -35390,6 +35388,14 @@ msgstr "<ahelp hid=\"HID_FUNC_NBW\">Vrne trenutno vrednost naložbe na osnovi ni
 #: 04060119.xhp
 msgctxt ""
 "04060119.xhp\n"
+"par_idN111381\n"
+"help.text"
+msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xnpv\" name=\"XNPV\">XNPV</link> function."
+msgstr "Če se plačila ne opravijo ob rednih intervalih, uporabite funkcijo <link href=\"text/scalc/01/04060118.xhp#xnpv\" name=\"XNPV\">XNPV</link>."
+
+#: 04060119.xhp
+msgctxt ""
+"04060119.xhp\n"
 "hd_id3149937\n"
 "303\n"
 "help.text"
@@ -38340,7 +38346,7 @@ msgctxt ""
 "04060181.xhp\n"
 "par_id289760\n"
 "help.text"
-msgid "<emph>Alpha</emph>The border probability that is attained or exceeded."
+msgid "<emph>Alpha</emph> The border probability that is attained or exceeded."
 msgstr "<emph>Alfa</emph> je mejna verjetnost, ki bo dosežena ali presežena."
 
 #: 04060181.xhp
@@ -45241,8 +45247,8 @@ msgctxt ""
 "par_id3147238\n"
 "124\n"
 "help.text"
-msgid "PERCENTRANK(Data; Value)"
-msgstr "PERCENTRANK(Podatki; Vrednosti)"
+msgid "PERCENTRANK(Data; Value; Significance)"
+msgstr "PERCENTRANK(Podatki; Vrednost; Značilno_število)"
 
 #: 04060184.xhp
 msgctxt ""
@@ -45265,6 +45271,14 @@ msgstr "<emph>Vrednost</emph> predstavlja vrednost, za katero je potrebno določ
 #: 04060184.xhp
 msgctxt ""
 "04060184.xhp\n"
+"par_id2748477\n"
+"help.text"
+msgid "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. If omitted, a value of 3 is used."
+msgstr "<emph>Značilno_število</emph> je število, na katerega večkratnik želimo vrednost zaokrožiti navzgor. Če je izpuščeno, bo uporabljena vrednost 3."
+
+#: 04060184.xhp
+msgctxt ""
+"04060184.xhp\n"
 "hd_id3155364\n"
 "127\n"
 "help.text"
@@ -49833,8 +49847,8 @@ msgctxt ""
 "04070000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Names"
-msgstr "Imena"
+msgid "Named Ranges and Expressions"
+msgstr "Imenovani obsegi in izrazi"
 
 #: 04070000.xhp
 msgctxt ""
@@ -49842,8 +49856,8 @@ msgctxt ""
 "hd_id3153951\n"
 "1\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/04070000.xhp\" name=\"Names\">Names</link>"
-msgstr "<link href=\"text/scalc/01/04070000.xhp\" name=\"Imena\">Imena</link>"
+msgid "<link href=\"text/scalc/01/04070000.xhp\" name=\"Names\">Named Ranges and Expressions</link>"
+msgstr "<link href=\"text/scalc/01/04070000.xhp\" name=\"Imena\">Imenovani obsegi in izrazi</link>"
 
 #: 04070000.xhp
 msgctxt ""
@@ -49949,8 +49963,8 @@ msgctxt ""
 "par_id3163712\n"
 "29\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/edit\">Enter the name of the area for which you want to define a reference or a formula expression. All area names already defined in the spreadsheet are listed in the text field below.</ahelp> If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames."
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/edit\">Vnesite ime območja, za katerega želite določiti sklic ali izraz formule. Vsa imena območij, ki so že določena v preglednici, so navedena v spodnjem besedilnem polju.</ahelp> Če kliknete ime s seznama, se bo ustrezni sklic v dokumentu prikazal v modrem okviru. Če več obsegov celic pripada istemu imenu območja, so prikazani v okvirih različnih barv."
+msgid "<ahelp hid=\".\">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames."
+msgstr "<ahelp hid=\".\">Vnesite ime območja, za katerega želite določiti sklic ali izraz formule.</ahelp> Vsa imena območij, ki so že določena v preglednici, so navedena v spodnjem besedilnem polju. Če kliknete ime s seznama, se bo ustrezni sklic v dokumentu prikazal v modrem okviru. Če več obsegov celic pripada istemu imenu območja, so prikazani v okvirih različnih barv."
 
 #: 04070100.xhp
 msgctxt ""
@@ -49967,8 +49981,8 @@ msgctxt ""
 "par_id3147435\n"
 "10\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/range\">The reference of the selected area name is shown here as an absolute value.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/range\">Sklic izbranega imena območja je tukaj prikazan kot absolutna vrednost.</ahelp>"
+msgid "<ahelp hid=\".\">The reference of the selected area name is shown here as an absolute value.</ahelp>"
+msgstr "<ahelp hid=\".\">Sklic izbranega imena območja je tukaj prikazan kot absolutna vrednost.</ahelp>"
 
 #: 04070100.xhp
 msgctxt ""
@@ -49994,8 +50008,8 @@ msgctxt ""
 "hd_id31547291\n"
 "13\n"
 "help.text"
-msgid "Select the scope of the named range or named formula. Document(Global) means the name is valid for the whole document. Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet."
-msgstr "Izberite doseg poimenovanega obsega ali poimenovane formule. Dokument(Global) pomeni, da je ime veljavno za celoten dokument. Vsako drugo izbrano ime delovnega lista bo omejilo doseg poimenovanega obsega ali izraza formule na ta delovni list."
+msgid "<ahelp hid=\".\">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet."
+msgstr "<ahelp hid=\".\">Izberite doseg poimenovanega obsega ali poimenovane formule. Dokument(Global) pomeni, da je ime veljavno za celoten dokument.</ahelp> Vsako drugo izbrano ime delovnega lista bo omejilo doseg poimenovanega obsega ali izraza formule na ta delovni list."
 
 #: 04070100.xhp
 msgctxt ""
@@ -50012,8 +50026,8 @@ msgctxt ""
 "par_id3149958\n"
 "14\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/more\">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/more\">Omogoča vam, da podate <emph>Vrsto območja</emph> (neobvezno) za sklic.</ahelp>"
+msgid "<ahelp hid=\".\">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp>"
+msgstr "<ahelp hid=\".\">Omogoča vam, da podate <emph>Vrsto območja</emph> (neobvezno) za sklic.</ahelp>"
 
 #: 04070100.xhp
 msgctxt ""
@@ -50039,8 +50053,8 @@ msgctxt ""
 "par_id3150751\n"
 "18\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/printarea\">Defines the area as a print range.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/printarea\">Določi območje kot obseg tiskanja.</ahelp>"
+msgid "<ahelp hid=\".\">Defines the area as a print range.</ahelp>"
+msgstr "<ahelp hid=\".\">Določi področje kot obseg tiskanja.</ahelp>"
 
 #: 04070100.xhp
 msgctxt ""
@@ -50057,8 +50071,8 @@ msgctxt ""
 "par_id3155766\n"
 "20\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/filter\">Defines the selected area to be used in an <link href=\"text/scalc/01/12040300.xhp\" name=\"advanced filter\">advanced filter</link>.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/filter\">Določi izbrano območje, ki se bo uporabljalo v <link href=\"text/scalc/01/12040300.xhp\" name=\"napredni filter\">naprednem filtru</link>.</ahelp>"
+msgid "<ahelp hid=\".\">Defines the selected area to be used in an <link href=\"text/scalc/01/12040300.xhp\" name=\"advanced filter\">advanced filter</link>.</ahelp>"
+msgstr "<ahelp hid=\".\">Določi izbrano območje, ki se bo uporabljalo v <link href=\"text/scalc/01/12040300.xhp\" name=\"napredni filter\">naprednem filtru</link>.</ahelp>"
 
 #: 04070100.xhp
 msgctxt ""
@@ -50075,8 +50089,8 @@ msgctxt ""
 "par_id3149565\n"
 "22\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/colheader\">Defines the area as a repeating column.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/colheader\">Določi območje kot ponavljajoči stolpec.</ahelp>"
+msgid "<ahelp hid=\".\">Defines the area as a repeating column.</ahelp>"
+msgstr "<ahelp hid=\".\">Določi območje kot ponavljajoči se stolpec.</ahelp>"
 
 #: 04070100.xhp
 msgctxt ""
@@ -50093,8 +50107,8 @@ msgctxt ""
 "par_id3150300\n"
 "24\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definename/rowheader\">Defines the area as a repeating row.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/definename/rowheader\">Določi območje kot ponavljajočo vrstico.</ahelp>"
+msgid "<ahelp hid=\".\">Defines the area as a repeating row.</ahelp>"
+msgstr "<ahelp hid=\".\">Določi območje kot ponavljajočo se vrstico.</ahelp>"
 
 #: 04070100.xhp
 msgctxt ""
@@ -50102,8 +50116,8 @@ msgctxt ""
 "hd_id3155112\n"
 "27\n"
 "help.text"
-msgid "Add/Modify"
-msgstr "Dodaj/Spremeni"
+msgid "Add"
+msgstr "Dodaj"
 
 #: 04070100.xhp
 msgctxt ""
@@ -50111,33 +50125,40 @@ msgctxt ""
 "par_id3159236\n"
 "28\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/managenamesdialog/add\">Click the <emph>Add</emph> button to add the defined name to the list. Click the <emph>Modify</emph> button to enter another name for an already existing name selected from the list.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/managenamesdialog/add\">Kliknite gumb <emph>Dodaj</emph>, da dodate določeno ime na seznam. Kliknite gumb <emph>Spremeni</emph>, da vnesete drugo ime za že obstoječe ime s seznama.</ahelp>"
+msgid "<ahelp hid=\".\">Click the <emph>Add</emph> button to add a new defined name.</ahelp>"
+msgstr "<ahelp hid=\".\">Kliknite gumb <emph>Dodaj</emph>, da dodate novo določeno ime.</ahelp>"
+
+#: 04070100.xhp
+msgctxt ""
+"04070100.xhp\n"
+"par_id3150301\n"
+"help.text"
+msgid "<ahelp hid=\"modules/scalc/ui/managenamesdialog/names\" visibility=\"hidden\">Select a named range or named formula from the list to modify its properties.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/managenamesdialog/names\" visibility=\"hidden\">S seznama izberite imenovan obseg ali imenovano formulo, da spremenite njene lastnosti.</ahelp>"
 
 #: 04070200.xhp
 msgctxt ""
 "04070200.xhp\n"
 "tit\n"
 "help.text"
-msgid "Insert Name"
-msgstr "Vstavi ime"
+msgid "Paste Names"
+msgstr "Prilepi imena"
 
 #: 04070200.xhp
 msgctxt ""
 "04070200.xhp\n"
 "bm_id3153195\n"
 "help.text"
-msgid "<bookmark_value>cell ranges; inserting named ranges</bookmark_value><bookmark_value>inserting; cell ranges</bookmark_value>"
-msgstr "<bookmark_value>obsegi celic; vstavljanje poimenovanih obsegov</bookmark_value><bookmark_value>vstavljanje; obsegi celic</bookmark_value>"
+msgid "<bookmark_value>cell ranges; inserting named ranges</bookmark_value><bookmark_value>inserting; cell ranges</bookmark_value> <bookmark_value>pasting; cell ranges</bookmark_value>"
+msgstr "<bookmark_value>obsegi celic; vstavljanje imenovanih obsegov</bookmark_value><bookmark_value>vstavljanje; obsegi celic</bookmark_value><bookmark_value>lepljenje; obsegi celic</bookmark_value>"
 
 #: 04070200.xhp
 msgctxt ""
 "04070200.xhp\n"
 "hd_id3153195\n"
-"1\n"
 "help.text"
-msgid "Insert Name"
-msgstr "Vstavi ime"
+msgid "Paste Names"
+msgstr "Prilepi imena"
 
 #: 04070200.xhp
 msgctxt ""
@@ -50161,37 +50182,49 @@ msgstr "Območja celice lahko vstavite šele potem, ko ste določili ime za obmo
 msgctxt ""
 "04070200.xhp\n"
 "hd_id3153160\n"
-"3\n"
 "help.text"
-msgid "Insert name"
-msgstr "Vstavi ime"
+msgid "Table area"
+msgstr "Območje tabele"
 
 #: 04070200.xhp
 msgctxt ""
 "04070200.xhp\n"
 "par_id3154944\n"
-"4\n"
 "help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_NAMES_PASTE:LB_ENTRYLIST\">Lists all defined cell areas. Double-click an entry to insert the named area into the active sheet at the current cursor position.</ahelp>"
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_NAMES_PASTE:LB_ENTRYLIST\">Navede vse določena območja celic. Če želite vstaviti imenovano območje v aktivni list na trenutnem položaju kazalke, dvokliknite vnos.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/insertname/ctrl\">Lists all defined cell areas. Double-click an entry to insert the named area into the active sheet at the current cursor position.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/insertname/ctrl\">Navede vse določena območja celic. Če želite vstaviti imenovano območje v aktivni list na trenutnem položaju kazalke, dvokliknite vnos.</ahelp>"
 
 #: 04070200.xhp
 msgctxt ""
 "04070200.xhp\n"
 "hd_id3153418\n"
-"5\n"
 "help.text"
-msgid "Insert All"
-msgstr "Vstavi vse"
+msgid "Paste All"
+msgstr "Prilepi vse"
 
 #: 04070200.xhp
 msgctxt ""
 "04070200.xhp\n"
 "par_id3155066\n"
-"6\n"
 "help.text"
-msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_NAMES_PASTE:BTN_ADD\">Inserts a list of all named areas and the corresponding cell references at the current cursor position.</ahelp>"
-msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_NAMES_PASTE:BTN_ADD\">Vstavi seznam vseh poimenovanih območij in ustrezne sklice celic pri trenutnem položaju kazalke.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/insertname/pasteall\">Inserts a list of all named areas and the corresponding cell references at the current cursor position.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/insertname/pasteall\">Vstavi seznam vseh poimenovanih območij in ustrezne sklice celic pri trenutnem položaju kazalke.</ahelp>"
+
+#: 04070200.xhp
+msgctxt ""
+"04070200.xhp\n"
+"hd_id3153419\n"
+"help.text"
+msgid "Paste"
+msgstr "Prilepi"
+
+#: 04070200.xhp
+msgctxt ""
+"04070200.xhp\n"
+"par_id3155067\n"
+"help.text"
+msgid "<ahelp hid=\"modules/scalc/ui/insertname/paste\">Inserts the selected named area and the corresponding cell reference at the current cursor position.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/insertname/paste\">Vstavi seznam poimenovanega območja in ustrezni sklic celic pri trenutnem položaju kazalke.</ahelp>"
 
 #: 04070300.xhp
 msgctxt ""
@@ -50233,8 +50266,8 @@ msgctxt ""
 "par_id3156280\n"
 "13\n"
 "help.text"
-msgid "Select the area containing all the ranges that you want to name. Then choose <emph>Insert - Names - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want."
-msgstr "Izberite območje, ki vsebuje vse obsege, ki jih želite poimenovati. Nato izberite <emph>Vstavi – Imena – Izdelaj</emph>. Odpre se pogovorno okno <emph>Izdelaj imena</emph>, kjer lahko izberete želene možnosti za poimenovanje."
+msgid "Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want."
+msgstr "Izberite območje, ki vsebuje vse obsege, ki jih želite poimenovati. Nato izberite <emph>Delovni list – Imenovani obsegi in izrazi – Ustvari</emph>. Odpre se pogovorno okno <emph>Ustvari imena</emph>, kjer lahko izberete želene možnosti za poimenovanje."
 
 #: 04070300.xhp
 msgctxt ""
@@ -51469,7 +51502,7 @@ msgctxt ""
 "par_id3155879\n"
 "help.text"
 msgid "<emph>Move the contents of the hidden cells into the first cell</emph>: the actual contents of the hidden cells are concatenated to the first cell, and hidden cells are emptied; the results of formulas referring to the hidden cells or the first cell will be updated."
-msgstr "<emph>Premakni vsebino skritih celic v prvo celico</emph>: dejanska vsebina skritih celic se konkatenira v prvo celico in skrite celice se izpraznijo; rezultati formul, ki se sklicujejo na skrite celice ali prvo celico, bodo posodobljene."
+msgstr "<emph>Premakni vsebino skritih celic v prvo celico</emph>: dejanska vsebina skritih celic se spoji v prvi celici in skrite celice se izpraznijo; rezultati formul, ki se sklicujejo na skrite celice ali prvo celico, bodo posodobljene."
 
 #: 05060000.xhp
 msgctxt ""
@@ -52120,8 +52153,8 @@ msgctxt ""
 "par_id3145174\n"
 "5\n"
 "help.text"
-msgid "Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Insert - Names - Define</emph> command, this name will be displayed and can be selected from the list box."
-msgstr "Izberite <emph>-brez-</emph>, če želite odstraniti definicijo obsega tiskanja za trenutno preglednico. Izberite <emph>-celotni list-</emph>, da nastavite trenutni list kot obseg tiskanja. Izberite <emph>-izbira-</emph>, da določite izbrana območja preglednice kot obseg tiskanja. Če izberete <emph>-uporabniško določen-</emph>, lahko določite obseg tiskanja, ki ste ga že določili z ukazom <emph>Oblika – Obsegi tiskanja – Določi</emph>. Če ste obseg poimenovali z ukazom <emph>Vnesi – Imena – Določi</emph>, bo prikazano to ime, izberete ga lahko v oknu s seznamom."
+msgid "Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Sheet - Named Ranges and Expressions - Define</emph> command, this name will be displayed and can be selected from the list box."
+msgstr "Izberite <emph>-brez-</emph>, če želite odstraniti definicijo obsega tiskanja za trenutno preglednico. Izberite <emph>-celotni list-</emph>, da nastavite trenutni list kot obseg tiskanja. Izberite <emph>-izbira-</emph>, da določite izbrana območja preglednice kot obseg tiskanja. Če izberete <emph>-uporabniško določen-</emph>, lahko določite obseg tiskanja, ki ste ga že določili z ukazom <emph>Oblika – Obsegi tiskanja – Določi</emph>. Če ste obseg poimenovali z ukazom <emph>Delovni list – Imenovani obsegi in izrazi – Določi</emph>, bo prikazano to ime, izberete ga lahko v oknu s seznamom."
 
 #: 05080300.xhp
 msgctxt ""
@@ -52329,8 +52362,8 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3159100\n"
 "help.text"
-msgid "<image id=\"img_id3149814\" src=\"sw/imglst/sf04.png\"><alt id=\"alt_id3149814\">Icon</alt></image>"
-msgstr "<image id=\"img_id3149814\" src=\"sw/imglst/sf04.png\"><alt id=\"alt_id3149814\">Ikona</alt></image>"
+msgid "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\"><alt id=\"alt_id3149814\">Icon</alt></image>"
+msgstr "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\"><alt id=\"alt_id3149814\">Ikona</alt></image>"
 
 #: 05100000.xhp
 msgctxt ""
@@ -52353,8 +52386,8 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3155531\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window.</ahelp>"
-msgstr "<ahelp hid=\"HID_TEMPLDLG_WATERCAN\">Vključi in izključi način Napolni obliko. Uporabite posodo z barvo, da dodelite Slog, izbran v oknu Slogi in oblikovanje.</ahelp>"
+msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window.</ahelp>"
+msgstr "<ahelp hid=\"SFX2_HID_TEMPLDLG_WATERCAN\">Vključi in izključi način Napolni obliko. Uporabite posodo z barvo, da dodelite Slog, izbran v oknu Slogi in oblikovanje.</ahelp>"
 
 #: 05100000.xhp
 msgctxt ""
@@ -52425,8 +52458,8 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3149499\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TEMPLDLG_NEWBYEXAMPLE\">Creates a new style based on the formatting of a selected object.</ahelp> Assign a name for the style in the <link href=\"text/shared/01/05140100.xhp\" name=\"Create Style\">Create Style</link> dialog."
-msgstr "<ahelp hid=\"HID_TEMPLDLG_NEWBYEXAMPLE\">Ustvari nov slog na osnovi oblikovanja izbranega predmeta.</ahelp> Dodelite ime za slog v pogovornem oknu <link href=\"text/shared/01/05140100.xhp\" name=\"Ustvari slog\">Ustvari slog</link>."
+msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_NEWBYEXAMPLE\">Creates a new style based on the formatting of a selected object.</ahelp> Assign a name for the style in the <link href=\"text/shared/01/05140100.xhp\" name=\"Create Style\">Create Style</link> dialog."
+msgstr "<ahelp hid=\"SFX2_HID_TEMPLDLG_NEWBYEXAMPLE\">Ustvari nov slog na osnovi oblikovanja izbranega predmeta.</ahelp> Dodelite ime za slog v pogovornem oknu <link href=\"text/shared/01/05140100.xhp\" name=\"Ustvari slog\">Ustvari slog</link>."
 
 #: 05100000.xhp
 msgctxt ""
@@ -52457,8 +52490,8 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3154707\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object.</ahelp>"
-msgstr "<ahelp hid=\"HID_TEMPLDLG_UPDATEBYEXAMPLE\">Posodobi izbrani slog v oknu Slogi in oblikovanje s trenutnim oblikovanjem izbranega predmeta.</ahelp>"
+msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object.</ahelp>"
+msgstr "<ahelp hid=\"SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE\">Posodobi izbrani slog v oknu Slogi in oblikovanje s trenutnim oblikovanjem izbranega predmeta.</ahelp>"
 
 #: 05100000.xhp
 msgctxt ""
@@ -52489,8 +52522,8 @@ msgctxt ""
 "05100000.xhp\n"
 "par_idN109C2\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TEMPLATE_FMT\">Displays the list of the styles from the selected style category.</ahelp>"
-msgstr "<ahelp hid=\"HID_TEMPLATE_FMT\">Prikaže seznam slogov iz izbrane slogovne kategorije.</ahelp>"
+msgid "<ahelp hid=\"SFX2_HID_TEMPLATE_FMT\">Displays the list of the styles from the selected style category.</ahelp>"
+msgstr "<ahelp hid=\"SFX2_HID_TEMPLATE_FMT\">Prikaže seznam slogov iz izbrane slogovne kategorije.</ahelp>"
 
 #: 05100000.xhp
 msgctxt ""
@@ -52513,8 +52546,8 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3147299\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TEMPLATE_FILTER\">Lists the available style groups.</ahelp>"
-msgstr "<ahelp hid=\"HID_TEMPLATE_FILTER\">Navede razpoložljive skupine slogov.</ahelp>"
+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 ""
@@ -54196,8 +54229,8 @@ msgctxt ""
 "hd_id3150206\n"
 "4\n"
 "help.text"
-msgid "Password (optional)"
-msgstr "Geslo (neobvezno)"
+msgid "<link href=\"text/shared/01/password_dlg.xhp\" name=\"Password\">Password (optional)</link>"
+msgstr "<link href=\"text/shared/01/password_dlg.xhp\" name=\"Geslo\">Geslo (neobvezno)</link>"
 
 #: 06060100.xhp
 msgctxt ""
@@ -54205,8 +54238,8 @@ msgctxt ""
 "par_id3152990\n"
 "7\n"
 "help.text"
-msgid "<ahelp hid=\".uno:Protect\">Allows you to enter a password to protect the sheet from unauthorized changes.</ahelp>"
-msgstr "<ahelp hid=\".uno:Protect\">Omogoča vam, da vnesete geslo za zaščito lista pred nepooblaščenimi spremembami.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/protectsheetdlg/password1\">Allows you to enter a password to protect the sheet from unauthorized changes.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/protectsheetdlg/password1\">Omogoča vam, da vnesete geslo za zaščito delovnega lista pred nepooblaščenimi spremembami.</ahelp>"
 
 #: 06060100.xhp
 msgctxt ""
@@ -54271,10 +54304,17 @@ msgstr "Geslo (neobvezno)"
 msgctxt ""
 "06060200.xhp\n"
 "par_id3155412\n"
-"5\n"
 "help.text"
-msgid "You can create a password to protect your document against unauthorized or accidental modifications."
-msgstr "Za zaščito vašega dokumenta proti nepooblaščenim ali naključnim spremembam lahko izdelate geslo."
+msgid "<ahelp hid=\"SC_HID_PASSWD_DOC\">You can create a password to protect your document against unauthorized or accidental modifications.</ahelp>"
+msgstr "<ahelp hid=\"SC_HID_PASSWD_DOC\">Za zaščito vašega dokumenta proti nepooblaščenim ali naključnim spremembam lahko izdelate geslo.</ahelp>"
+
+#: 06060200.xhp
+msgctxt ""
+"06060200.xhp\n"
+"par_id3155413\n"
+"help.text"
+msgid "<ahelp hid=\"SC_HID_PASSWD_DOC_CONFIRM\" visibility=\"hidden\">Re-enter the password.</ahelp>"
+msgstr "<ahelp hid=\"SC_HID_PASSWD_DOC_CONFIRM\" visibility=\"hidden\">Ponovno vnesite geslo.</ahelp>"
 
 #: 06060200.xhp
 msgctxt ""
@@ -54479,32 +54519,6 @@ msgctxt ""
 msgid "AutoInput is case-sensitive. If, for example, you have written \"Total\" in a cell, you cannot enter \"total\" in another cell of the same column without first deactivating AutoInput."
 msgstr "Samodejni vnos je občutlijv na velike in male črke. Če ste npr. v celici napisali »Total«, ne morete v drugi celici istega stolpca vnesti »total«, ne da bi prej izključili Samodejnega vnosa."
 
-#: 06990000.xhp
-msgctxt ""
-"06990000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Cell Contents"
-msgstr "Vsebina celice"
-
-#: 06990000.xhp
-msgctxt ""
-"06990000.xhp\n"
-"hd_id3153087\n"
-"1\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/06990000.xhp\" name=\"Cell Contents\">Cell Contents</link>"
-msgstr "<link href=\"text/scalc/01/06990000.xhp\" name=\"Vsebina celice\">Vsebina celice</link>"
-
-#: 06990000.xhp
-msgctxt ""
-"06990000.xhp\n"
-"par_id3145674\n"
-"2\n"
-"help.text"
-msgid "Opens a submenu with commands to calculate tables and activate AutoInput."
-msgstr "Odpre podrejeni meni z ukazi za izračun tabel in vključitev Samodejnega vnosa."
-
 #: 07080000.xhp
 msgctxt ""
 "07080000.xhp\n"
@@ -54886,7 +54900,7 @@ msgctxt ""
 "4\n"
 "help.text"
 msgid "You cannot sort data if the <link href=\"text/shared/01/02230000.xhp\" name=\"Record changes\">Record changes</link> options is enabled."
-msgstr "Podatkov ne morete razvrščati, če je omogočena možnost <link href=\"text/shared/01/02230000.xhp\" name=\"Zapiši spremembe\">Zapiši spremembe</link>."
+msgstr "Podatkov ne morete razvrščati, če je omogočena možnost <link href=\"text/shared/01/02230000.xhp\" name=\"Beleži spremembe\">Beleži spremembe</link>."
 
 #: 12030100.xhp
 msgctxt ""
@@ -56645,8 +56659,8 @@ msgctxt ""
 "par_id3153821\n"
 "2\n"
 "help.text"
-msgid "<variable id=\"gruppierung\"><ahelp hid=\".uno:Group\" visibility=\"visible\">Defines the selected cell range as a group of rows or columns.</ahelp></variable>"
-msgstr "<variable id=\"gruppierung\"><ahelp hid=\".uno:Group\" visibility=\"visible\">Določi izbran obseg celice kot skupino vrstic ali stolpcev.</ahelp></variable>"
+msgid "<variable id=\"gruppierung\"><ahelp hid=\".\">Defines the selected cell range as a group of rows or columns.</ahelp></variable>"
+msgstr "<variable id=\"gruppierung\"><ahelp hid=\".\">Določi izbran obseg celice kot skupino vrstic ali stolpcev.</ahelp></variable>"
 
 #: 12080300.xhp
 msgctxt ""
@@ -56654,8 +56668,8 @@ msgctxt ""
 "par_id3145069\n"
 "3\n"
 "help.text"
-msgid "When you group a cell range, and outline icon appears in the margins next to the group. To hide or show the group, click the icon. To ungroup the selection, choose <emph>Data – Outline -</emph> <link href=\"text/scalc/01/12080400.xhp\" name=\"Ungroup\"><emph>Ungroup</emph></link>."
-msgstr "Ko združite obseg celic, se na obrobah skupine pojavij ikona orisa. S klikom na ikono prikažete ali skrijete skupino. Za razdružitev izbora izberite <emph>Podatki – Oris –</emph> <link href=\"text/scalc/01/12080400.xhp\" name=\"Razdruži\"><emph>Razdruži</emph></link>."
+msgid "When you group a cell range, and outline icon appears in the margins next to the group. To hide or show the group, click the icon. To ungroup the selection, choose <emph>Data – Group and Outline -</emph> <link href=\"text/scalc/01/12080400.xhp\" name=\"Ungroup\"><emph>Ungroup</emph></link>."
+msgstr "Ko združite obseg celic, se na obrobah skupine pojavi ikona orisa. S klikom na ikono prikažete ali skrijete skupino. Za razdružitev izbora izberite <emph>Podatki – Združi in oriši –</emph> <link href=\"text/scalc/01/12080400.xhp\" name=\"Razdruži\"><emph>Razdruži</emph></link>."
 
 #: 12080300.xhp
 msgctxt ""
@@ -56681,8 +56695,8 @@ msgctxt ""
 "par_id3153194\n"
 "7\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_GROUP_ROWS\" visibility=\"visible\">Groups the selected rows.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_GROUP_ROWS\" visibility=\"visible\">Razdruži izbrane vrstice.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/groupdialog/rows\">Groups the selected rows.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/groupdialog/rows\">Združi izbrane vrstice.</ahelp>"
 
 #: 12080300.xhp
 msgctxt ""
@@ -56699,8 +56713,8 @@ msgctxt ""
 "par_id3146984\n"
 "9\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SC_GROUP_COLS\" visibility=\"visible\">Groups the selected columns.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_GROUP_COLS\" visibility=\"visible\">Razdruži izbrane stolpce.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/groupdialog/cols\">Groups the selected columns.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/groupdialog/cols\">Združi izbrane stolpce.</ahelp>"
 
 #: 12080400.xhp
 msgctxt ""
@@ -58120,8 +58134,8 @@ msgctxt ""
 "par_id3154490\n"
 "11\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/functions\">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/functions\">Kliknite vrsto delnih vsot, ki jih želite izračunati. Ta možnost je na voljo samo, če je izbrana možnost <emph>Uporabniško določeno</emph>.</ahelp>"
+msgid "<ahelp hid=\".\">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp>"
+msgstr "<ahelp hid=\".\">Kliknite vrsto delnih vsot, ki jih želite izračunati. Ta možnost je na voljo samo, če je izbrana možnost <emph>Uporabniško določeno</emph>.</ahelp>"
 
 #: 12090105.xhp
 msgctxt ""
@@ -58129,7 +58143,7 @@ msgctxt ""
 "hd_id3154944\n"
 "14\n"
 "help.text"
-msgid "Show elements without data"
+msgid "Show items without data"
 msgstr "Pokaži elemente brez podatkov"
 
 #: 12090105.xhp
@@ -58138,8 +58152,8 @@ msgctxt ""
 "par_id3149403\n"
 "15\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/showall\">Includes empty columns and rows in the results table.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/showall\">V tabelo rezultatov vključi prazne stolpce in vrstice.</ahelp>"
+msgid "<ahelp hid=\".\">Includes empty columns and rows in the results table.</ahelp>"
+msgstr "<ahelp hid=\".\">V tabelo rezultatov vključi prazne stolpce in vrstice.</ahelp>"
 
 #: 12090105.xhp
 msgctxt ""
@@ -58228,8 +58242,8 @@ msgctxt ""
 "12090105.xhp\n"
 "par_idN10716\n"
 "help.text"
-msgid "<ahelp hid=\"1495371266\">Select the type of calculating of the displayed value for the data field.</ahelp>"
-msgstr "<ahelp hid=\"1495371266\">Izberite vrsto izračuna prikazane vrednosti za polje podatkov.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafielddialog/type\">Select the type of calculating of the displayed value for the data field.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafielddialog/type\">Izberite vrsto izračuna prikazane vrednosti za polje podatkov.</ahelp>"
 
 #: 12090105.xhp
 msgctxt ""
@@ -58452,8 +58466,8 @@ msgctxt ""
 "12090105.xhp\n"
 "par_idN107BE\n"
 "help.text"
-msgid "<ahelp hid=\"1495371267\">Select the field from which the respective value is taken as base for the calculation.</ahelp>"
-msgstr "<ahelp hid=\"1495371267\">Izberite polje, iz katerega je vzeta ustrezna vrednost kot osnova za izračun.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafielddialog/basefield\">Select the field from which the respective value is taken as base for the calculation.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafielddialog/basefield\">Izberite polje, iz katerega je vzeta ustrezna vrednost kot osnova za izračun.</ahelp>"
 
 #: 12090105.xhp
 msgctxt ""
@@ -58468,8 +58482,8 @@ msgctxt ""
 "12090105.xhp\n"
 "par_idN107C5\n"
 "help.text"
-msgid "<ahelp hid=\"1495371268\">Select the item of the base field from which the respective value is taken as base for the calculation.</ahelp>"
-msgstr "<ahelp hid=\"1495371268\">Izberite element temeljnega polja, iz katerega je vzeta ustrezna vrednost kot osnova za izračun.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafielddialog/baseitem\">Select the item of the base field from which the respective value is taken as base for the calculation.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafielddialog/baseitem\">Izberite element temeljnega polja, iz katerega je vzeta ustrezna vrednost kot osnova za izračun.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58516,8 +58530,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN1055B\n"
 "help.text"
-msgid "<ahelp hid=\"1495387653\">Select the data field that you want to sort columns or rows by.</ahelp>"
-msgstr "<ahelp hid=\"1495387653\">Izberite polje podatkov, po katerem želite razvrstiti stolpce ali vrstice.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/sortby\">Select the data field that you want to sort columns or rows by.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/sortby\">Izberite polje podatkov, po katerem želite razvrstiti stolpce ali vrstice.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58532,8 +58546,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN10562\n"
 "help.text"
-msgid "<ahelp hid=\"1495384580\">Sorts the values from the lowest value to the highest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.</ahelp>"
-msgstr "<ahelp hid=\"1495384580\">Razvrsti vrednosti od najnižje vrednosti do najvišje vrednosti. Če gre pri izbranem polju za polje, za katerega se je odprlo pogovorno okno, postavke razvrsti po imenu. Če gre za podatkovno polje, razvrsti postavke po vrednosti rezultata izbranega podatkovnega polja.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/ascending\">Sorts the values from the lowest value to the highest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/ascending\">Razvrsti vrednosti od najnižje vrednosti do najvišje vrednosti. Če gre pri izbranem polju za polje, za katerega se je odprlo pogovorno okno, postavke razvrsti po imenu. Če gre za podatkovno polje, razvrsti postavke po vrednosti rezultata izbranega podatkovnega polja.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58548,8 +58562,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN10569\n"
 "help.text"
-msgid "<ahelp hid=\"1495384581\">Sorts the values descending from the highest value to the lowest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.</ahelp>"
-msgstr "<ahelp hid=\"1495384581\">Razvrsti vrednosti padajoče od najvišje vrednosti do najnižje vrednosti. Če gre pri izbranem polju za polje, za katerega je bilo odprto pogovorno okno, razvrsti postavke po imenu. Če gre za podatkovno polje, razvrsti postavke po vrednosti rezultata izbranega podatkovnega polja.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/descending\">Sorts the values descending from the highest value to the lowest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/descending\">Razvrsti vrednosti padajoče od najvišje vrednosti do najnižje vrednosti. Če gre pri izbranem polju za polje, za katerega je bilo odprto pogovorno okno, razvrsti postavke po imenu. Če gre za podatkovno polje, razvrsti postavke po vrednosti rezultata izbranega podatkovnega polja.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58564,8 +58578,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN10570\n"
 "help.text"
-msgid "<ahelp hid=\"1495384582\">Sorts values alphabetically.</ahelp>"
-msgstr "<ahelp hid=\"1495384582\">Razvrsti vrednosti po abecednem redu.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/manual\">Sorts values alphabetically.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/manual\">Razvrsti vrednosti po abecednem redu.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58596,8 +58610,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN10590\n"
 "help.text"
-msgid "<ahelp hid=\"1495387654\">Select the layout mode for the field in the list box.</ahelp>"
-msgstr "<ahelp hid=\"1495387654\">Izberite način postavitve za polje v oknu s seznamom.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/layout\">Select the layout mode for the field in the list box.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/layout\">Izberite način postavitve za seznamsko polje.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58612,8 +58626,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN10597\n"
 "help.text"
-msgid "<ahelp hid=\"1495385090\">Adds an empty row after the data for each item in the pivot table.</ahelp>"
-msgstr "<ahelp hid=\"1495385090\">Doda prazno vrstico za podatki za vsak element v vrtilni tabeli.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/emptyline\">Adds an empty row after the data for each item in the pivot table.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/emptyline\">Doda prazno vrstico za podatki za vsak element v vrtilni tabeli.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58644,8 +58658,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN105A5\n"
 "help.text"
-msgid "<ahelp hid=\"1495385091\">Turns on the automatic show feature.</ahelp>"
-msgstr "<ahelp hid=\"1495385091\">Vključi funkcijo samodejnega prikaza.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/show\">Turns on the automatic show feature.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/show\">Vključi funkcijo samodejnega prikaza.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58660,8 +58674,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN105AC\n"
 "help.text"
-msgid "<ahelp hid=\"1495390209\">Enter the maximum number of items that you want to show automatically.</ahelp>"
-msgstr "<ahelp hid=\"1495390209\">Vnesite največje število elementov, ki jih želite samodejno prikazati.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/items\">Enter the maximum number of items that you want to show automatically.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/items\">Vnesite največje število elementov, ki jih želite samodejno prikazati.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58676,8 +58690,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN105B3\n"
 "help.text"
-msgid "<ahelp hid=\"1495387655\">Shows the top or bottom items in the specified sort order.</ahelp>"
-msgstr "<ahelp hid=\"1495387655\">Prikaže zgornje ali spodnje elemente v podanem vrstnem redu.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/from\">Shows the top or bottom items in the specified sort order.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/from\">Prikaže zgornje ali spodnje elemente v podanem vrstnem redu.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58692,8 +58706,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN105BA\n"
 "help.text"
-msgid "<ahelp hid=\"1495387656\">Select the data field that you want to sort the data by.</ahelp>"
-msgstr "<ahelp hid=\"1495387656\">Izberite polje podatkov, po katerem želite razvrstiti podatke.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/using\">Select the data field that you want to sort the data by.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/using\">Izberite polje podatkov, po katerem želite razvrstiti podatke.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58708,8 +58722,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN105C1\n"
 "help.text"
-msgid "<ahelp hid=\"59010\">Select the items that you want to hide from the calculations.</ahelp>"
-msgstr "<ahelp hid=\"59010\">Izberite elemente, ki jih želite skriti pred izračuni.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hideitems\">Select the items that you want to hide from the calculations.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hideitems\">Izberite elemente, ki jih želite skriti pred izračuni.</ahelp>"
 
 #: 12090106.xhp
 msgctxt ""
@@ -58724,8 +58738,8 @@ msgctxt ""
 "12090106.xhp\n"
 "par_idN105C8\n"
 "help.text"
-msgid "<ahelp hid=\"1495387657\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
-msgstr "<ahelp hid=\"1495387657\">Izberite hierarhijo, ki jo želite uporabiti. Vrtilna tabela mora temeljiti na zunanjem viru podatkov, ki vsebuje hierarhije podatkov.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Izberite hierarhijo, ki jo želite uporabiti. Vrtilna tabela mora temeljiti na zunanjem viru podatkov, ki vsebuje hierarhije podatkov.</ahelp>"
 
 #: 12090200.xhp
 msgctxt ""
@@ -59686,7 +59700,7 @@ msgctxt ""
 "par_id231020162249541102\n"
 "help.text"
 msgid "<emph>Weekend</emph> is an optional parameter – a number or a string used to specify the days of the week that are weekend days and are not considered working days. Weekend is a weekend number or string that specifies when weekends occur. Weekend number values indicate the following weekend days:"
-msgstr "<emph>Vikend</emph> je neobvezen parameter – število ali niz, s katerim se določi dni tedna, ki so dnevi vikenda in jih ne štejemo za delavnike. Vikend je številka ali niz vikenda, ki določa, kdaj nastopi vikend. Številske vrednosti vikenda nakazujejo naslednje dni kot vikend:"
+msgstr "<emph>Vikend</emph> je neobvezen parameter – število ali niz, s katerim so določeni dnevi tedna, ki so dnevi vikenda in jih ne štejemo za delavnike. Vikend je številka ali niz vikenda, ki določa, kdaj nastopi vikend. Številske vrednosti vikenda nakazujejo naslednje dni kot vikend:"
 
 #: common_func_workdaysintl.xhp
 msgctxt ""
@@ -60774,7 +60788,7 @@ msgctxt ""
 "par_id2309201514193338\n"
 "help.text"
 msgid "<emph>Ref2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value."
-msgstr "<emph>Sklic2,3 ...</emph> – neobvezno. Številski argument ali sklic na celico ali območje (do 253 argumentov), za katerega želite funkcijo agregacije."
+msgstr "<emph>Sklic2,3 ...</emph> – neobvezno. Številski argument ali sklic na celico ali območje (do 253 argumentov), za katerega želite funkcijo združevanja."
 
 #: func_aggregate.xhp
 msgctxt ""
@@ -60803,14 +60817,6 @@ msgstr "<emph>k</emph> – obvezni argument naslednjih funkcij: LARGE, SMALL, PE
 #: func_aggregate.xhp
 msgctxt ""
 "func_aggregate.xhp\n"
-"par_id2309201516525483\n"
-"help.text"
-msgid "If the <emph>k</emph> argument is necessary, but not specified, the function returns the error Err:511.<br/>If the <emph>Function</emph> and/or <emph>Option</emph> arguments specified not correctly, the function returns the error Err:502."
-msgstr "Če je argument <emph>k</emph> obvezen, ni pa naveden, funkcija vrne napako Nap:511.<br/>Če argument <emph>Funkcija</emph> in/ali <emph>Možnost</emph> ni pravilno naveden, funkcija vrne napako Nap:502."
-
-#: func_aggregate.xhp
-msgctxt ""
-"func_aggregate.xhp\n"
 "hd_id198071265128228\n"
 "help.text"
 msgid "Examples"
@@ -61517,8 +61523,8 @@ msgctxt ""
 "func_color.xhp\n"
 "par_id1102201617001848\n"
 "help.text"
-msgid "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp>The result depends on the color system used by your computer."
-msgstr "<ahelp hid=\".\">Vrne numerično vrednosti, izračunano iz kombinacije treh barv (rdeče, zelene in modre) ter kanala alfa, v barvnem sistemu RGBA.</ahelp>Rezultat je odvisen ob barvnega sistema, ki ga uporablja vaš računalnik."
+msgid "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer."
+msgstr "<ahelp hid=\".\">Vrne numerično vrednosti, izračunano iz kombinacije treh barv (rdeče, zelene in modre) ter kanala alfa, v barvnem sistemu RGBA.</ahelp> Rezultat je odvisen ob barvnega sistema, ki ga uporablja vaš računalnik."
 
 #: func_color.xhp
 msgctxt ""
@@ -63398,7 +63404,7 @@ msgctxt ""
 "hd_id040312316112394554\n"
 "help.text"
 msgid "Returns 23.4416821953741, the prediction interval for additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation."
-msgstr "Vrne 23,4416821953741, interval napovedi za aditivno napoved za januar 2014 glede na zgornja poimenovana obsega <emph>Vrednosti</emph> in <emph>Časovnica</emph>, z ravnjo zaupanja 0,8, dolžino periode 4, brez manjkajočih podatkov in s SUM za združevanje."
+msgstr "Vrne 23,4416821953741, interval napovedi za aditivno napoved za januar 2014 glede na zgornja poimenovana obsega <emph>Vrednosti</emph> in <emph>Časovnica</emph>, z ravnjo zaupanja 0,8, dolžino periode 4, brez manjkajočih podatkov in s funkcijo SUM za združevanje."
 
 #: func_forecastetspiadd.xhp
 msgctxt ""
@@ -63502,7 +63508,7 @@ msgctxt ""
 "hd_id04032016112394554\n"
 "help.text"
 msgid "Returns 20.1040952101013, the prediction interval for multiplicative forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, confidence level of 90% (=0.9) with one sample per period, no missing data, and AVERAGE as aggregation."
-msgstr "Vrne 20,1040952101013, interval napovedi za multiplikativno napoved za januar 2014 glede na zgornja poimenovana obsega <emph>Vrednosti</emph> in <emph>Časovnica</emph>, z enim vzorcem na periodo, brez manjkajočih podatkov in z AVERAGE za združevanje."
+msgstr "Vrne 20,1040952101013, interval napovedi za multiplikativno napoved za januar 2014 glede na zgornja poimenovana obsega <emph>Vrednosti</emph> in <emph>Časovnica</emph>, z enim vzorcem na periodo, brez manjkajočih podatkov in s funkcijo AVERAGE za združevanje."
 
 #: func_forecastetspimult.xhp
 msgctxt ""
@@ -63518,7 +63524,7 @@ msgctxt ""
 "hd_id040312316112394554\n"
 "help.text"
 msgid "Returns 27.5285874381574, the prediction interval for multiplicative forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation."
-msgstr "Vrne 27,5285874381574, interval napovedi za multiplikativno napoved za januar 2014 glede na zgornja poimenovana obsega <emph>Vrednosti</emph> in <emph>Časovnica</emph>, z ravnjo zaupanja 0,8, dolžino periode 4, brez manjkajočih podatkov in s SUM za združevanje."
+msgstr "Vrne 27,5285874381574, interval napovedi za multiplikativno napoved za januar 2014 glede na zgornja poimenovana obsega <emph>Vrednosti</emph> in <emph>Časovnica</emph>, z ravnjo zaupanja 0,8, dolžino periode 4, brez manjkajočih podatkov in s funkcijo SUM za združevanje."
 
 #: func_forecastetspimult.xhp
 msgctxt ""
@@ -64519,7 +64525,7 @@ msgctxt ""
 "par_id5063188419467\n"
 "help.text"
 msgid "<item type=\"input\">=IMSINH(\"4-3i\")</item><br/>returns -27.0168132580039-3.85373803791938i."
-msgstr "<item type=\"input\">=IMSINH(\"4-3i\")</item>vrne -27,0168132580039-3,85373803791938i."
+msgstr "<item type=\"input\">=IMSINH(\"4-3i\")</item><br/>vrne -27,0168132580039-3,85373803791938i."
 
 #: func_imsinh.xhp
 msgctxt ""
@@ -64527,7 +64533,7 @@ msgctxt ""
 "par_id1527387141125\n"
 "help.text"
 msgid "<item type=\"input\">=IMSINH(2)</item><br/>returns 3.62686040784702 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
-msgstr "<item type=\"input\">=IMSINH(2)</item>vrne 3,62686040784702 kot niz. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr "<item type=\"input\">=IMSINH(2)</item><br/>vrne 3,62686040784702 kot niz. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
 
 #: func_imsinh.xhp
 msgctxt ""
@@ -64968,7 +64974,7 @@ msgctxt ""
 "par_id231020162249554032\n"
 "help.text"
 msgid "How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017."
-msgstr "Koliko delovnih dni je med 15.12.2016 in 14.1.2017? Začetni datum se nahaja v C3, končni datum pa v D3. Celice od F3 do I3 vsebujejo naslednje dela proste dni v času božičnih in novoletnih praznikov: »25.12.2016«, »26.12.2016«, »31.12.2016« in »01.01.2017«."
+msgstr "Koliko delovnih dni je med 15. 12. 2016 in 14. 1. 2017? Začetni datum se nahaja v C3, končni datum pa v D3. Celice od F3 do I3 vsebujejo naslednje dela proste dni v času božičnih in novoletnih praznikov: »25.12.2016«, »26.12.2016«, »31.12.2016« in »01.01.2017«."
 
 #: func_networkdays.intl.xhp
 msgctxt ""
@@ -64976,7 +64982,7 @@ msgctxt ""
 "par_id231020162249551234\n"
 "help.text"
 msgid "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days."
-msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;F3:I3)</item> vrne 22 delovnih dni s privzeto nastavitvijo za vikend."
+msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;F3:J3)</item> vrne 21 delovnih dni s privzeto nastavitvijo za vikend."
 
 #: func_networkdays.intl.xhp
 msgctxt ""
@@ -64984,7 +64990,7 @@ msgctxt ""
 "par_id231020162249553109\n"
 "help.text"
 msgid "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> returns 24 workdays with Sunday only weekends."
-msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;11;F3:I3)</item> vrne 25 delovnih dni ob vikendih zgolj v nedeljo."
+msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> vrne 24 delovnih dni ob vikendih zgolj v nedeljo."
 
 #: func_networkdays.intl.xhp
 msgctxt ""
@@ -65000,7 +65006,7 @@ msgctxt ""
 "par_id231020162249553409\n"
 "help.text"
 msgid "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3)</item> returns 24 workdays with Sunday only weekend."
-msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:I3)</item> vrne 25 delovnih dni ob vikendih zgolj v nedeljo."
+msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3)</item> vrne 24 delovnih dni ob vikendih zgolj v nedeljo."
 
 #: func_networkdays.intl.xhp
 msgctxt ""
@@ -65016,7 +65022,7 @@ msgctxt ""
 "par_id23102016224955931\n"
 "help.text"
 msgid "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days."
-msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3)</item> vrne 23 delovnih dni."
+msgstr "<item type=\"literal\">=NETWORKDAYS.INTL(C3;D3)</item> vrne 22 delovnih dni."
 
 #: func_networkdays.intl.xhp
 msgctxt ""
@@ -65144,7 +65150,7 @@ msgctxt ""
 "par_id3154661\n"
 "help.text"
 msgid "How many workdays fall between 2001-12-15 and 2002-01-15? The start date is located in C3 and the end date in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: \"2001-12-24\", \"2001-12-25\", \"2001-12-26\", \"2001-12-31\", \"2002-01-01\"."
-msgstr "Koliko delovnih dni je med 15.12.2001 in 15.1.2002? Začetni datum se nahaja v C3, končni datum pa v D3. Celice od F3 do J3 vsebujejo naslednje dela proste dni v času božičnih in novoletnih praznikov: »24.12.2001«, »25.12.2001«, »26.12.2001«, »31.12.2001«, »01.01.2002«."
+msgstr "Koliko delovnih dni je med 15. 12. 2001 in 15. 1. 2002? Začetni datum se nahaja v C3, končni datum pa v D3. Celice od F3 do J3 vsebujejo naslednje dela proste dni v času božičnih in novoletnih praznikov: »24.12.2001«, »25.12.2001«, »26.12.2001«, »31.12.2001«, »01.01.2002«."
 
 #: func_networkdays.xhp
 msgctxt ""
@@ -65386,6 +65392,70 @@ msgctxt ""
 msgid "<item type=\"input\">=NUMBERVALUE(\"123.456\";\".\";\",\")</item> yields 123.456"
 msgstr "<item type=\"input\">=NUMBERVALUE(\"123,456\";\",\";\".\")</item> vrne 123,456."
 
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"tit\n"
+"help.text"
+msgid "RAWSUBTRACT function"
+msgstr "RAWSUBTRACT"
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"bm_2016112109230\n"
+"help.text"
+msgid "<bookmark_value>rawsubtract;subtraction</bookmark_value>            <bookmark_value>RAWSUBTRACT function</bookmark_value>"
+msgstr "<bookmark_value>odštevanje;z napakami zaokrožanja</bookmark_value><bookmark_value>funkcija RAWSUBSTRACT</bookmark_value>"
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"hd_2016112109231\n"
+"help.text"
+msgid "<variable id=\"rawsubtract_head\"><link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link></variable>"
+msgstr "<variable id=\"rawsubtract_head\"><link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link></variable>"
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"par_2016112109232\n"
+"help.text"
+msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors. </ahelp>"
+msgstr "<ahelp hid=\".\">Odšteje množico števil in vrne rezultat brez izključevanja manjših napak zaokrožanja.</ahelp>"
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"par_2016112109233\n"
+"help.text"
+msgid "RAWSUBTRACT(Minuend, Subtrahend1, Subtrahend2, ...)"
+msgstr "RAWSUBTRACT(zmanjševanec, odštevanec1, odštevanec2, ...)"
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"par_2016112109234\n"
+"help.text"
+msgid "Subtracts the subtrahend(s) from the minuend without eliminating roundoff errors. The function should be called with at least two parameters."
+msgstr "Odšteje odštevanca oz. odštevance od zmanjševanca brez izključevanja napak zaokrožanja. Funkcija zahteva najmanj dva parametra."
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"par_2016112109235\n"
+"help.text"
+msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765, 0.9876543210987)</item> returns 6.53921361504217E-14"
+msgstr "<item type=\"literal\">RAWSUBTRACT(0,987654321098765, 0,9876543210987)</item> vrne 6,53921361504217E-14"
+
+#: func_rawsubtract.xhp
+msgctxt ""
+"func_rawsubtract.xhp\n"
+"par_2016112109237\n"
+"help.text"
+msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765)</item> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
+msgstr "<item type=\"literal\">RAWSUBTRACT(0,987654321098765)</item> vrne Nap:511 (manjkajoča spremenljivka), saj RAWSUBTRACT potrebuje vsaj dve števili."
+
 #: func_second.xhp
 msgctxt ""
 "func_second.xhp\n"
@@ -66676,8 +66746,8 @@ msgctxt ""
 "func_weeknum_ooo.xhp\n"
 "par_idN105E4\n"
 "help.text"
-msgid "This function exists for interoperability with LibreOffice releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the <link href=\"text/scalc/01/func_weeknum.xhp\">WEEKNUM</link> or <link href=\"text/scalc/01/func_isoweeknum.xhp\">ISOWEEKNUM</link> function instead."
-msgstr "Ta funkcija je namenjena medopravilnosti z izdajami LibreOffice pred 5.1.0 ter z OpenOffice.org. Izračuna številko tedna za sistem štetja tednov, v katerem ima številko 1 teden, ki vsebuje 4. januar. Ta funkcija ne ponuja medopravilnosti z drugimi programi za preglednice. V novih dokumentih uporabite funkciji <link href=\"text/scalc/01/func_weeknum.xhp\">WEEKNUM</link> ali <link href=\"text/scalc/01/func_isoweeknum.xhp\">ISOWEEKNUM</link>."
+msgid "This function exists for interoperability with %PRODUCTNAME releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the <link href=\"text/scalc/01/func_weeknum.xhp\">WEEKNUM</link> or <link href=\"text/scalc/01/func_isoweeknum.xhp\">ISOWEEKNUM</link> function instead."
+msgstr "Ta funkcija je namenjena združljivosti z izdajami %PRODUCTNAME pred 5.1.0 ter z OpenOffice.org. Izračuna številko tedna za sistem štetja tednov, v katerem ima številko 1 teden, ki vsebuje 4. januar. Ta funkcija ne ponuja medopravilnosti z drugimi programi za preglednice. V novih dokumentih uporabite funkciji <link href=\"text/scalc/01/func_weeknum.xhp\">WEEKNUM</link> ali <link href=\"text/scalc/01/func_isoweeknum.xhp\">ISOWEEKNUM</link>."
 
 #: func_weeknum_ooo.xhp
 msgctxt ""
@@ -66969,7 +67039,7 @@ msgctxt ""
 "194\n"
 "help.text"
 msgid "What date came 17 workdays after 1 December 2001? Enter the start date \"2001-12-01\" in C3 and the number of workdays in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: \"2001-12-24\", \"2001-12-25\", \"2001-12-26\", \"2001-12-31\", \"2002-01-01\"."
-msgstr "Kateri datum je 17 delovnih dni po 1. decembru 2001? Vnesite začetni datum »01.12.2001« v C3 in število delovnih dni v D3. Celice od F3 do J3 vsebujejo naslednje božične in novoletne praznike: »24.12.2001«, »25.12.2001«, »26.12.2001«, »31.12.2001«, »01.01.2002«."
+msgstr "Kateri datum je 17 delovnih dni po 1. decembru 2001? Vnesite začetni datum »01.12.2001« v C3 in število delovnih dni v D3. Celice od F3 do J3 vsebujejo naslednje božične in novoletne praznike: »24.12.2001«, »25.12.2001«, »26.12.2001«, »31.12.2001«, »01.01.2002«, »02.01.2002«."
 
 #: func_workday.xhp
 msgctxt ""
@@ -67017,24 +67087,24 @@ msgctxt ""
 "func_workdays.intl.xhp\n"
 "tit\n"
 "help.text"
-msgid "WORKDAYS.INTL"
-msgstr "WORKDAYS.INTL"
+msgid "WORKDAY.INTL"
+msgstr "WORKDAY.INTL"
 
 #: func_workdays.intl.xhp
 msgctxt ""
 "func_workdays.intl.xhp\n"
 "bm_id231020162341219565\n"
 "help.text"
-msgid "<bookmark_value>WORKDAYS.INTL function</bookmark_value>"
-msgstr "<bookmark_value>funkcija WORKDAYS.INTL</bookmark_value>"
+msgid "<bookmark_value>WORKDAY.INTL function</bookmark_value>"
+msgstr "<bookmark_value>funkcija WORKDAY.INTL</bookmark_value>"
 
 #: func_workdays.intl.xhp
 msgctxt ""
 "func_workdays.intl.xhp\n"
 "hd_id231020162348002143\n"
 "help.text"
-msgid "<variable id=\"workdaysintl\"><link href=\"text/scalc/01/func_workdays.intl.xhp\">WORKDAYS.INTL</link></variable>"
-msgstr "<variable id=\"workdaysintl\"><link href=\"text/scalc/01/func_workdays.intl.xhp\">WORKDAYS.INTL</link></variable>"
+msgid "<variable id=\"workdaysintl\"><link href=\"text/scalc/01/func_workdays.intl.xhp\">WORKDAY.INTL</link></variable>"
+msgstr "<variable id=\"workdaysintl\"><link href=\"text/scalc/01/func_workdays.intl.xhp\">WORKDAY.INTL</link></variable>"
 
 #: func_workdays.intl.xhp
 msgctxt ""
@@ -67106,7 +67176,7 @@ msgctxt ""
 "par_id241020160012172125\n"
 "help.text"
 msgid "Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017."
-msgstr "Celice od F3 do I3 vsebujejo štiri (4) praznične dni za Božič in novo leto v obliki datuma: 25. december 2016, 26. december 2016, 31. december 2016 in 1. januar 2017."
+msgstr "Celice od F3 do I3 vsebujejo pet (5) prazničnih dni za Božič in novo leto v obliki datuma: 25. december 2016, 26. december 2016, 31. december 2016, 1. januar 2017 in 2. januar 2017."
 
 #: func_workdays.intl.xhp
 msgctxt ""
@@ -67114,7 +67184,7 @@ msgctxt ""
 "par_id241020160012177923\n"
 "help.text"
 msgid "<item type=\"literal\">=WORKDAY.INTL(C3;D3;;F3:J3)</item> returns January 11, 2017 in the result cell, say D6 (use date format for the cell)."
-msgstr "<item type=\"literal\">=WORKDAY.INTL(C3;D3;;F3:J3)</item> vrne 11. januar 2017 v celici rezultata, npr. D6 (za celico uporabite obliko datuma)."
+msgstr "<item type=\"literal\">=WORKDAY.INTL(C3;D3;;F3:J3)</item> vrne 12. januar 2017 v celici rezultata, npr. D6 (za celico uporabite obliko datuma)."
 
 #: func_workdays.intl.xhp
 msgctxt ""
@@ -67201,8 +67271,8 @@ msgctxt ""
 "func_workdays.intl.xhp\n"
 "par_id241030160012187036\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/func_workday.xhp\">WORKDAYS</link>"
-msgstr "<link href=\"text/scalc/01/func_workday.xhp\">WORKDAYS</link>"
+msgid "<link href=\"text/scalc/01/func_workday.xhp\">WORKDAY</link>"
+msgstr "<link href=\"text/scalc/01/func_workday.xhp\">WORKDAY</link>"
 
 #: func_workdays.intl.xhp
 msgctxt ""