summaryrefslogtreecommitdiff
path: root/source/sl/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/sl/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/sl/helpcontent2/source/text/scalc/01.po412
1 files changed, 321 insertions, 91 deletions
diff --git a/source/sl/helpcontent2/source/text/scalc/01.po b/source/sl/helpcontent2/source/text/scalc/01.po
index 0f1e80f625f..b796b689a2e 100644
--- a/source/sl/helpcontent2/source/text/scalc/01.po
+++ b/source/sl/helpcontent2/source/text/scalc/01.po
@@ -1,16 +1,16 @@
#. extracted from helpcontent2/source/text/scalc/01
msgid ""
msgstr ""
-"Project-Id-Version: LibreOffice 6.2\n"
+"Project-Id-Version: LibreOffice 6.3\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-11-14 12:49+0100\n"
-"PO-Revision-Date: 2018-11-10 11:45+0200\n"
+"POT-Creation-Date: 2019-04-22 10:57+0200\n"
+"PO-Revision-Date: 2019-04-22 22:06+0200\n"
"Last-Translator: Martin Srebotnjak <miles@filmsi.net>\n"
"Language-Team: sl.libreoffice.org\n"
+"Language: sl\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
-"Language: sl\n"
"Plural-Forms: nplurals=4; plural=(n%100==1 ? 0 : n%100==2 ? 1 : n%100==3 || n%100==4 ? 2 : 3);\n"
"X-Generator: Virtaal 0.7.1\n"
"X-Accelerator-Marker: ~\n"
@@ -3118,32 +3118,32 @@ msgctxt ""
"04040000.xhp\n"
"hd_id160220162139258865\n"
"help.text"
-msgid "Columns Left"
-msgstr "Stolpci levo"
+msgid "Columns Before"
+msgstr "Stolpci pred"
#: 04040000.xhp
msgctxt ""
"04040000.xhp\n"
"par_id3150791\n"
"help.text"
-msgid "<ahelp hid=\".uno:InsertColumnsBefore\">Inserts a new column to the left of the active cell.</ahelp>"
-msgstr "<ahelp hid=\".uno:InsertColumnsBefore\">Levo od aktivne celice vstavi nov stolpec.</ahelp>"
+msgid "<ahelp hid=\".uno:InsertColumnsBefore\">Inserts a new column before the active cell.</ahelp>"
+msgstr "<ahelp hid=\".uno:InsertColumnsBefore\">Pred aktivno celice vstavi nov stolpec.</ahelp>"
#: 04040000.xhp
msgctxt ""
"04040000.xhp\n"
"hd_id160220162139252941\n"
"help.text"
-msgid "Columns Right"
-msgstr "Stolpci desno"
+msgid "Columns After"
+msgstr "Stolpci za"
#: 04040000.xhp
msgctxt ""
"04040000.xhp\n"
"par_id160220162138041164\n"
"help.text"
-msgid "<ahelp hid=\".uno:InsertColumnsAfter\">Inserts a new column to the right of the active cell.</ahelp>"
-msgstr "<ahelp hid=\".uno:InsertColumnsAfter\">Desno od aktivne celice vstavi nov stolpec.</ahelp>"
+msgid "<ahelp hid=\".uno:InsertColumnsAfter\">Inserts a new column after the active cell.</ahelp>"
+msgstr "<ahelp hid=\".uno:InsertColumnsAfter\">Za aktivno celico vstavi nov stolpec.</ahelp>"
#: 04050000.xhp
msgctxt ""
@@ -3430,8 +3430,8 @@ msgctxt ""
"04060000.xhp\n"
"par_id8007446\n"
"help.text"
-msgid "You can download the complete ODFF (OpenDocument Format Formula) specification from the <link href=\"http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula\">OASIS</link> web site."
-msgstr "Celotno specifikacijo ODFF (OpenDocument Format Formula) lahko prenesete s spletnega mesta <link href=\"http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula\">OASIS</link>."
+msgid "You can download the complete ODFF (OpenDocument Format Formula) specification from the <link href=\"https://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt\"><emph>OASIS</emph></link> web site."
+msgstr "Celotno specifikacijo ODFF (OpenDocument Format Formula) lahko prenesete s spletnega mesta <link href=\"https://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt\"><emph>OASIS</emph></link>."
#: 04060000.xhp
msgctxt ""
@@ -3486,8 +3486,8 @@ 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>."
+msgid "You can browse the full <link href=\"text/scalc/01/04060100.xhp\" name=\"List of Categories and Functions\"><emph>List of Categories and Functions</emph></link>."
+msgstr "Ogledate si lahko tudi celoten <link href=\"text/scalc/01/04060100.xhp\" name=\"Seznam kategorij in funkcij\"><emph>seznam kategorij in funkcij</emph></link>."
#: 04060000.xhp
msgctxt ""
@@ -3518,16 +3518,16 @@ msgctxt ""
"04060000.xhp\n"
"par_id3149566\n"
"help.text"
-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."
+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 ""
"04060000.xhp\n"
"par_id3155959\n"
"help.text"
-msgid "The <emph>Array</emph> option is identical to the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter command, which is used to enter and confirm formulas in the sheet. The formula is inserted as a matrix formula indicated by two braces { }."
-msgstr "Možnost <emph>Matrika</emph> je popolnoma enaka ukazu <switchinline select=\"sys\"><caseinline select=\"MAC\">tipka Cmd</caseinline><defaultinline>krmilka</defaultinline></switchinline>+dvigalka+vnašalka, ki ga uporabljamo za vnos in potrditev formul na delovnem listu. Formula je vstavljena kot matrična formula v zavitih oklepajih { }."
+msgid "The <emph>Array</emph> option is identical to the <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph> command, which is used to enter and confirm formulas in the sheet. The formula is inserted as a matrix formula indicated by two braces: <emph>{ }</emph>."
+msgstr "Možnost <emph>Matrika</emph> je popolnoma enaka ukazu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>tipka Cmd</emph></caseinline><defaultinline><emph>krmilka</emph></defaultinline></switchinline><emph>+dvigalka+vnašalka</emph>, ki ga uporabljamo za vnos in potrditev formul na delovnem listu. Formula je vstavljena kot matrična formula v zavitih oklepajih <emph>{ }</emph>."
#: 04060000.xhp
msgctxt ""
@@ -3550,8 +3550,8 @@ msgctxt ""
"04060000.xhp\n"
"par_id3145587\n"
"help.text"
-msgid "When you double-click a function, the argument input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell, or drag across the required range on the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using <link href=\"text/scalc/01/04060102.xhp\" name=\"date entries\">date entries</link>, make sure you use the correct format. Click OK to insert the result into the spreadsheet."
-msgstr "Ko dvokliknete funkcijo, se na desni strani pogovornega okna pojavijo polja za vnos argumentov. Če želite za argument izbrati sklic celice, kliknite neposredno v celico ali pa držite levi gumb miške in izberite želeni obseg na delovnem listu. V ustrezna polja v pogovornem oknu lahko tudi vnesete številčne in druge vrednosti ali sklice. Kadar uporabljate <link href=\"text/scalc/01/04060102.xhp\" name=\"vnosi datumov\">datumske vnose</link>, preverite, da jih vnašate v pravilni obliki. Kliknite V redu in rezultat bo vstavljen v preglednico."
+msgid "When you double-click a function, the argument input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell, or drag across the required range on the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using <link href=\"text/scalc/01/04060102.xhp\" name=\"date entries\"><emph>date entries</emph></link>, make sure you use the correct format. Click <emph>OK</emph> to insert the result into the spreadsheet."
+msgstr "Ko dvokliknete funkcijo, se na desni strani pogovornega okna pojavijo polja za vnos argumentov. Če želite za argument izbrati sklic celice, kliknite neposredno v celico ali pa držite levi gumb miške in izberite želeni obseg na delovnem listu. V ustrezna polja v pogovornem oknu lahko tudi vnesete številčne in druge vrednosti ali sklice. Kadar uporabljate <link href=\"text/scalc/01/04060102.xhp\" name=\"vnosi datumov\"><emph>datumske vnose</emph></link>, preverite, da jih vnašate v pravilni obliki. Kliknite <emph>V redu</emph> in rezultat bo vstavljen v preglednico."
#: 04060000.xhp
msgctxt ""
@@ -3566,8 +3566,8 @@ msgctxt ""
"04060000.xhp\n"
"par_id3155809\n"
"help.text"
-msgid "As soon you enter arguments in the function, the result is calculated. This preview informs you if the calculation can be carried out with the arguments given. If the arguments result in an error, the corresponding <link href=\"text/scalc/05/02140000.xhp\" name=\"error code\">error code</link> is displayed."
-msgstr "Takoj ko v funkcijo vnesete argumente, je izračunan rezultat. Predogled vam pove, če je izračun z danimi argumenti mogoč. Če zaradi argumentov pride do napake, je prikazana ustrezna <link href=\"text/scalc/05/02140000.xhp\" name=\"koda napake\">koda napake</link>."
+msgid "As soon you enter arguments in the function, the result is calculated. This preview informs you if the calculation can be carried out with the arguments given. If the arguments result in an error, the corresponding <link href=\"text/scalc/05/02140000.xhp\" name=\"error code\"><emph>error code</emph></link> is displayed."
+msgstr "Takoj ko v funkcijo vnesete argumente, je izračunan rezultat. Predogled vam pove, če je izračun z danimi argumenti mogoč. Če zaradi argumentov pride do napake, je prikazana ustrezna <link href=\"text/scalc/05/02140000.xhp\" name=\"koda napake\"><emph>koda napake</emph></link>."
#: 04060000.xhp
msgctxt ""
@@ -3678,8 +3678,8 @@ msgctxt ""
"04060000.xhp\n"
"par_id3149316\n"
"help.text"
-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."
+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 formule 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 ""
@@ -5092,6 +5092,14 @@ msgstr "Nedvoumna pretvorba je možna za datume in čase po standardu ISO 8601 v
#: 04060102.xhp
msgctxt ""
"04060102.xhp\n"
+"par_id651547654187646\n"
+"help.text"
+msgid "Time zone information is not used in Date and Time functions and cells."
+msgstr "Podatki o časovnem pasu niso uporabljeni v datumskih in časovnih funkcijah in celicah."
+
+#: 04060102.xhp
+msgctxt ""
+"04060102.xhp\n"
"par_idN1067A\n"
"help.text"
msgid "Functions"
@@ -9886,8 +9894,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id3154297\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_ARCTAN2\">Returns the inverse trigonometric tangent of the specified x and y coordinates.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_ARCTAN2\">Vrne obratni trigonometrični tangens določenih koordinat x in y.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_ARCTAN2\">Returns the angle (in radians) between the x-axis and a line from the origin to the point (NumberX|NumberY).</ahelp>"
+msgstr "<ahelp hid=\"HID_FUNC_ARCTAN2\">Vrne kot (v radianih) med osjo X in črto od izhodišča do točke (ŠteviloX|ŠteviloY).</ahelp>"
#: 04060106.xhp
msgctxt ""
@@ -9900,7 +9908,7 @@ msgstr "ATAN2(številoX; številoY)"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3151168\n"
+"par_id3001800\n"
"help.text"
msgid "<emph>NumberX</emph> is the value of the x coordinate."
msgstr "<emph>ŠteviloX</emph> je vrednost koordinate X."
@@ -9916,34 +9924,74 @@ msgstr "<emph>ŠteviloY</emph> je vrednost koordinate Y."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id5036164\n"
+"par_id5036168\n"
"help.text"
-msgid "ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI."
-msgstr "ATAN2 vrne inverzni trigonometrični tangens, to je kot (v radianih) med osjo X in črto od točke številoX, številoY do izhodišča. Vrnjeni kot ima vrednost med -PI in PI."
+msgid "Programming languages have usually the opposite order of arguments for their atan2() function."
+msgstr "Programski jeziki imajo običajno obratno zaporedje argumentov pri svojih funkcijah atan2()."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3001800\n"
+"par_id5036165\n"
"help.text"
-msgid "To return the angle in degrees, use the DEGREES function."
-msgstr "Če želite vrnjeno vrednost kota v stopinjah, uporabite funkcijo DEGREES."
+msgid "ATAN2 returns the angle (in radians) between the x-axis and a line from the origin to the point (NumberX|NumberY)"
+msgstr "ATAN2 vrne kot (v radianih) med osjo X in črto od izhodišča do točke (ŠteviloX, ŠteviloY)."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3154692\n"
"help.text"
-msgid "<item type=\"input\">=ATAN2(20;20)</item> returns 0.785398163397448 (PI/4 radians)."
-msgstr "<item type=\"input\">=ATAN2(20;20)</item> vrne 0,785398163397448 (PI/4 radianov)."
+msgid "<item type=\"input\">=ATAN2(-5;9)</item> returns 2.07789 radians."
+msgstr "<item type=\"input\">=ATANH(-5;9)</item> vrne 2,07789 radianov."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036166\n"
+"help.text"
+msgid "To get the angle in degrees apply the DEGREES function to the result."
+msgstr "Če želite vrnjeno vrednost kota v stopinjah, uporabite funkcijo DEGREES."
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id1477095\n"
"help.text"
-msgid "<item type=\"input\">=DEGREES(ATAN2(12.3;12.3))</item> returns 45. The tangent of 45 degrees is 1."
-msgstr "<item type=\"input\">=DEGREES(ATAN2(12,3;12,3))</item> vrne 45. Tangens 45 stopinj je 1."
+msgid "<input>=DEGREES(ATAN2(12.3;12.3))</input> returns 45. The tangent of 45 degrees is 1."
+msgstr "<input>=DEGREES(ATAN2(12,3;12,3))</input> vrne 45. Tangens 45 stopinj je 1."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036167\n"
+"help.text"
+msgid "%PRODUCTNAME results 0 for ATAN2(0;0)."
+msgstr "%PRODUCTNAME vrne 0 za ATAN2(0;0)."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036169\n"
+"help.text"
+msgid "The function can be used in converting cartesian coordinates to polar coordinates."
+msgstr "Funkcijo lahko uporabite za pretvorbo kartezijskih koordinat v polarne."
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036170\n"
+"help.text"
+msgid "=DEGREES(ATAN2(-8;5)) returns φ = 147.9 degrees"
+msgstr "=DEGREES(ATAN2(-8;5)) vrne φ = 147,9 stopinj"
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036171\n"
+"help.text"
+msgid "<image id=\"img_id3150758\" src=\"media/helpimg/scalc/coordinates-to-polar-01.svg\" width=\"2.5inch\" height=\"1.5inch\"><alt id=\"alt_id3150758\">Cartesian coordinates to polar coordinates example</alt></image>"
+msgstr "<image id=\"img_id3150758\" src=\"media/helpimg/scalc/coordinates-to-polar-01.svg\" width=\"2.5inch\" height=\"1.5inch\"><alt id=\"alt_id3150758\">Primer kartezijskih koordinat v polarnih koordinatah</alt></image>"
#: 04060106.xhp
msgctxt ""
@@ -17918,8 +17966,8 @@ msgctxt ""
"04060109.xhp\n"
"par_id3153884\n"
"help.text"
-msgid "<emph>Array</emph> is the reference, which is to comprise at least two columns."
-msgstr "<emph>Matrika</emph> je sklic, ki mora obsegati vsaj dva stolpca."
+msgid "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument."
+msgstr "<emph>Matrika</emph> je sklic, ki mora obsegati vsaj toliko stolpcev, kolikor jih je številsko podanih v argumentu Kazalo."
#: 04060109.xhp
msgctxt ""
@@ -27198,8 +27246,8 @@ msgctxt ""
"04060118.xhp\n"
"par_id3150525\n"
"help.text"
-msgid "Calculation of the net present value for the above-mentioned five payments for a notional internal rate of return of 6%."
-msgstr "Izračun neto vrednosti za zgoraj omenjenih pet plačil za umišljeno notranjo stopnjo donosa 6 %."
+msgid "Calculation of the net present value for the above-mentioned five payments for a national internal rate of return of 6%."
+msgstr "Izračun neto vrednosti za zgoraj omenjenih pet plačil za umišljeno nacionalno notranjo stopnjo donosa 6 %."
#: 04060118.xhp
msgctxt ""
@@ -41286,8 +41334,8 @@ msgctxt ""
"05030300.xhp\n"
"par_id3148645\n"
"help.text"
-msgid "Select the rows or columns that you want to hide, and then choose <emph>Format - Row - Hide </emph>or<emph> Format - Column - Hide</emph>."
-msgstr "Izberite vrstice ali stolpce, ki jih želite skriti, in nato <emph>Oblika – Vrstica – Skrij </emph>ali<emph> Oblika – Stolpec – Skrij</emph>."
+msgid "Select the rows or columns that you want to hide, and then choose <emph>Format - Rows - Hide </emph>or<emph> Format - Columns - Hide</emph>."
+msgstr "Izberite vrstice ali stolpce, ki jih želite skriti, in nato <emph>Oblika – Vrstice – Skrij </emph>ali<emph> Oblika – Stolpci – Skrij</emph>."
#: 05030300.xhp
msgctxt ""
@@ -41326,8 +41374,8 @@ msgctxt ""
"05030300.xhp\n"
"par_id5532090\n"
"help.text"
-msgid "Choose <link href=\"text/scalc/01/05030400.xhp\" name=\"Format - Row/Column - Show\">Format - Row/Column - Show</link> or <link href=\"text/scalc/01/05050300.xhp\" name=\"Format - Sheet - Show\">Format - Sheet - Show</link>."
-msgstr "Izberite <link href=\"text/scalc/01/05030400.xhp\" name=\"Oblika – Vrstica/Stolpec – Pokaži\">Oblika – Vrstica/Stolpec – Pokaži</link> ali <link href=\"text/scalc/01/05050300.xhp\" name=\"Oblika – Delovni list – Pokaži\">Oblika – Delovni list – Pokaži</link>."
+msgid "Choose <link href=\"text/scalc/01/05030400.xhp\" name=\"Format - Rows/Columns - Show\">Format - Rows/Columns - Show</link> or <link href=\"text/scalc/01/05050300.xhp\" name=\"Format - Sheet - Show\">Format - Sheet - Show</link>."
+msgstr "Izberite <link href=\"text/scalc/01/05030400.xhp\" name=\"Oblika – Vrstice/Stolpci – Pokaži\">Oblika – Vrstice/Stolpci – Pokaži</link> ali <link href=\"text/scalc/01/05050300.xhp\" name=\"Oblika – Delovni list – Pokaži\">Oblika – Delovni list – Pokaži</link>."
#: 05030400.xhp
msgctxt ""
@@ -41366,16 +41414,16 @@ msgctxt ""
"05030400.xhp\n"
"par_id3155131\n"
"help.text"
-msgid "To show a column or row, select the range of rows or columns containing the hidden elements, then choose <emph>Format - Row - Show</emph> or <emph>Format - Column - Show</emph>."
-msgstr "Če želite prikazati stolpec ali vrstico, izberite obseg vrstic ali stolpcev, ki vsebujejo skrite elemente, nato pa izberite <emph>Oblika – Vrstica – Pokaži</emph> ali <emph>Oblika – Stolpec – Pokaži</emph>."
+msgid "To show a column or row, select the range of rows or columns containing the hidden elements, then choose <emph>Format - Rows - Show</emph> or <emph>Format - Columns - Show</emph>."
+msgstr "Če želite prikazati stolpec ali vrstico, izberite obseg vrstic ali stolpcev, ki vsebujejo skrite elemente, nato pa izberite <emph>Oblika – Vrstice – Pokaži</emph> ali <emph>Oblika – Stolpci – Pokaži</emph>."
#: 05030400.xhp
msgctxt ""
"05030400.xhp\n"
"par_id3155132\n"
"help.text"
-msgid "For example, to show the column B, click on the header of the column A, expand the selection to the column C, then chose <emph>Format - Column - Show</emph>. To show the column A previously hidden, click on the header of the column B, keep the mouse button pressed and drag on the left. The selected range displayed in the name area changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Column - Show</emph>. Proceed the same way with rows."
-msgstr "Za prikaz stolpca B npr. kliknite glavo stolpca A, razširite izbor na stolpec C, nato izberite <emph>Oblika – Stolpec – Pokaži</emph>. Za prikaz poprej skritega stolpca A kliknite glavo stolpca B, obdržite pritisnjen gumb miške in povlecite na levo. Izbrani obseg, prikazan v območju imena, se spremeni iz B1:B1048576 v A1:B1048576. Izberite <emph>Oblika – Stolpec – Pokaži</emph>. Na enak način ravnajte z vrsticami."
+msgid "For example, to show the column B, click on the header of the column A, expand the selection to the column C, then chose <emph>Format - Columns - Show</emph>. To show the column A previously hidden, click on the header of the column B, keep the mouse button pressed and drag on the left. The selected range displayed in the name area changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Columns - Show</emph>. Proceed the same way with rows."
+msgstr "Za prikaz stolpca B npr. kliknite glavo stolpca A, razširite izbor na stolpec C, nato izberite <emph>Oblika – Stolpci – Pokaži</emph>. Za prikaz poprej skritega stolpca A kliknite glavo stolpca B, obdržite pritisnjen gumb miške in povlecite na levo. Izbrani obseg, prikazan v območju imena, se spremeni iz B1:B1048576 v A1:B1048576. Izberite <emph>Oblika – Stolpci – Pokaži</emph>. Na enak način ravnajte z vrsticami."
#: 05030400.xhp
msgctxt ""
@@ -41486,8 +41534,8 @@ msgctxt ""
"05040200.xhp\n"
"par_id3146120\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 0.1 in."
-msgstr "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Določi optimalno širino stolpca za prikaz celotne vsebine stolpca.</ahelp> Dodatni presledek za optimalno širino stolpca je prednastavljen na 0,1 palca."
+msgid "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 2 mm."
+msgstr "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Določi optimalno širino stolpca za prikaz celotne vsebine stolpca.</ahelp> Dodatni presledek za optimalno širino stolpca je prednastavljen na 2 mm."
#: 05050000.xhp
msgctxt ""
@@ -43086,7 +43134,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id31494133\n"
"help.text"
-msgid "If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented."
+msgid "If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented."
msgstr "Če izberete <emph>Vse celice</emph>, si spodaj oglejte razlage barvne lestvice, podatkovnega stolpca ali nabora ikon za izbrani način pogojnega oblikovanja."
#: 05120000.xhp
@@ -43134,7 +43182,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id31494139\n"
"help.text"
-msgid "If you select <emph>Formula is</emph> as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches."
+msgid "If you select <emph>Formula is</emph> as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches."
msgstr "Če za sklic izberete <emph>Formula je</emph>, vnesite sklic na celico. Če je sklic na celico vrednost, različna od nič, je pogoj izpolnjen."
#: 05120000.xhp
@@ -43342,7 +43390,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id31546818\n"
"help.text"
-msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>"
+msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>."
msgstr "Izberite <emph>Oblika – Pogojno oblikovanje – Upravljaj</emph>."
#: 05120000.xhp
@@ -44182,8 +44230,8 @@ msgctxt ""
"06060000.xhp\n"
"par_id3153362\n"
"help.text"
-msgid "The <emph>Protect Sheet</emph> or <emph>Protect Spreadsheet</emph> commands prevent changes from being made to cells in the sheets or to sheets in a document. As an option, you can define a password. If a password is defined, removal of the protection is only possible if the user enters the correct password."
-msgstr "Ukaz <emph>Zaščiti delovni list</emph> oz. <emph>Zaščiti preglednico</emph> preprečuje spremembe na celicah na delovnih listih ali na delovnih listih v dokumentu. Kot možnost lahko določite geslo. Če je geslo določeno, je odstranitev zaščite mogoča samo, če uporabnik vnese pravilno geslo."
+msgid "The <emph>Protect Sheet</emph> or <emph>Protect Spreadsheet Structure</emph> commands prevent changes from being made to cells in the sheets or to sheets in a document. As an option, you can define a password. If a password is defined, removal of the protection is only possible if the user enters the correct password."
+msgstr "Ukaz <emph>Zaščiti delovni list</emph> oz. <emph>Zaščiti strukturo preglednice</emph> preprečuje spremembe na celicah na delovnih listih ali na delovnih listih v dokumentu. Kot možnost lahko določite geslo. Če je geslo določeno, je odstranitev zaščite mogoča samo, če uporabnik vnese pravilno geslo."
#: 06060000.xhp
msgctxt ""
@@ -44326,8 +44374,8 @@ msgctxt ""
"06060100.xhp\n"
"par_id3148700\n"
"help.text"
-msgid "Complete protection of your work can be achieved by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet</emph>, including password protection. To prohibit opening the document altogether, in the <emph>Save</emph> dialog mark the <emph>Save with password</emph> box before you click the <emph>Save</emph> button."
-msgstr "Svoje delo lahko popolnoma zaščitite z obema možnostma v meniju <emph>Orodja – Zaščiti delovni list</emph> in <emph>Orodja – Zaščiti preglednico</emph>, skupaj z geselsko zaščito. Če želite popolnoma onemogočiti odpiranje dokumenta, v pogovornem oknu <emph>Shrani</emph> označite polje <emph>Shrani z geslom</emph>, preden kliknete gumb <emph>Shrani</emph>."
+msgid "Complete protection of your work can be achieved by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password protection. To prohibit opening the document altogether, in the <emph>Save</emph> dialog mark the <emph>Save with password</emph> box before you click the <emph>Save</emph> button."
+msgstr "Svoje delo lahko popolnoma zaščitite z obema možnostma v meniju <emph>Orodja – Zaščiti delovni list</emph> in <emph>Orodja – Zaščiti strukturo preglednice</emph>, skupaj z geselsko zaščito. Če želite popolnoma onemogočiti odpiranje dokumenta, v pogovornem oknu <emph>Shrani</emph> označite polje <emph>Shrani z geslom</emph>, preden kliknete gumb <emph>Shrani</emph>."
#: 06060200.xhp
msgctxt ""
@@ -44350,16 +44398,16 @@ msgctxt ""
"06060200.xhp\n"
"par_id3145172\n"
"help.text"
-msgid "<variable id=\"dokumenttext\"><ahelp hid=\".uno:ToolProtectionDocument\">Protects the sheet structure of your document from modifications. It is impossible to insert, delete, rename, move or copy sheets.</ahelp></variable> Open the <emph>Protect document</emph> dialog with <emph>Tools - Protect Spreadsheet</emph>. Optionally enter a password and click OK."
-msgstr "<variable id=\"dokumenttext\"><ahelp hid=\".uno:ToolProtectionDocument\">Zaščiti strukturo delovnega lista v vašem dokumentu pred spremembami. Nemogoče je vstavljati, brisati, preimenovati, premikati ali kopirati delovne liste.</ahelp></variable> Odprite pogovorno okno <emph>Zaščiti dokument</emph> z <emph>Orodja – Zaščiti preglednico</emph>. Po želji vnesite geslo in kliknite V redu."
+msgid "<variable id=\"dokumenttext\"><ahelp hid=\".uno:ToolProtectionDocument\">Protects the sheet structure of your document from modifications. It is impossible to insert, delete, rename, move or copy sheets.</ahelp></variable> Open the <emph>Protect spreadsheet structure</emph> dialog with <emph>Tools - Protect Spreadsheet Structure</emph>. Optionally enter a password and click OK."
+msgstr "<variable id=\"dokumenttext\"><ahelp hid=\".uno:ToolProtectionDocument\">Zaščiti strukturo delovnega lista v vašem dokumentu pred spremembami. Nemogoče je vstavljati, brisati, preimenovati, premikati ali kopirati delovne liste.</ahelp></variable> Odprite pogovorno okno <emph>Zaščiti dokument</emph> z <emph>Orodja – Zaščiti strukturo preglednice</emph>. Po želji vnesite geslo in kliknite V redu."
#: 06060200.xhp
msgctxt ""
"06060200.xhp\n"
"par_id3153188\n"
"help.text"
-msgid "The structure of protected spreadsheet documents can be changed only if the <emph>Protect</emph> option is disabled. On the context menus for the spreadsheet tabs at the lower graphic border, only the menu item <emph>Select All Sheets</emph> can be activated. All other menu items are deactivated. To remove the protection, call up the command <emph>Tools - Protect Spreadsheet</emph> again. If no password is assigned, protection is immediately removed. If you were assigned a password, the <emph>Remove Spreadsheet Protection</emph> dialog appears, in which you must enter the password. Only then can you remove the check mark specifying that protection is active."
-msgstr "Zgradbo zaščitenih preglednic lahko spremenite samo, če je možnost <emph>Zaščiti</emph> onemogočena. V kontekstnem meniju za zavihke preglednice na spodnjem robu slike lahko aktivirate le menijsko izbiro <emph>Izberi vse delovne liste</emph>. Vse ostale menijske izbire so deaktivirane. Če želite odstraniti zaščito, ponovno prikličite ukaz <emph>Orodja – Zaščiti preglednico</emph>. Če geslo ni dodeljeno, se zaščita takoj odstrani. Če vam je bilo geslo dodeljeno, se pojavi pogovorno okno <emph>Odstrani zaščito preglednice</emph>, v katerega morate vnesti geslo. Šele tedaj lahko odstranite kljukico, ki nakazuje vključeno zaščito."
+msgid "The structure of protected spreadsheet documents can be changed only if the <emph>Protect</emph> option is disabled. On the context menus for the spreadsheet tabs at the lower graphic border, only the menu item <emph>Select All Sheets</emph> can be activated. All other menu items are deactivated. To remove the protection, call up the command <emph>Tools - Protect Spreadsheet Structure</emph> again. If no password is assigned, protection is immediately removed. If you were assigned a password, the <emph>Remove Spreadsheet Protection</emph> dialog appears, in which you must enter the password. Only then can you remove the check mark specifying that protection is active."
+msgstr "Zgradbo zaščitenih preglednic lahko spremenite samo, če je možnost <emph>Zaščiti</emph> onemogočena. V kontekstnem meniju za zavihke preglednice na spodnjem robu slike lahko aktivirate le menijsko izbiro <emph>Izberi vse delovne liste</emph>. Vse ostale menijske izbire so deaktivirane. Če želite odstraniti zaščito, ponovno prikličite ukaz <emph>Orodja – Zaščiti strukturo preglednice</emph>. Če geslo ni dodeljeno, se zaščita takoj odstrani. Če vam je bilo geslo dodeljeno, se pojavi pogovorno okno <emph>Odstrani zaščito preglednice</emph>, v katerega morate vnesti geslo. Šele tedaj lahko odstranite kljukico, ki nakazuje vključeno zaščito."
#: 06060200.xhp
msgctxt ""
@@ -44398,8 +44446,8 @@ msgctxt ""
"06060200.xhp\n"
"par_id3150717\n"
"help.text"
-msgid "You can completely protect your work by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet</emph>, including password entry. If you want to prevent the document from being opened by other users, select <emph>Save With Password </emph>and click the <emph>Save</emph> button. The <emph>Enter Password</emph> dialog appears. Consider carefully when choosing a password; if you forget it after you close a document you will be unable to access the document."
-msgstr "Vaše delo lahko popolnoma zaščitite z uporabo obeh možnosti <emph>Orodja – Zaščiti delovni list</emph> in <emph>Orodja – Zaščiti preglednico</emph>, skupaj z geselsko zaščito. Če ne želite, da drugi uporabniki odpirajo dokument, izberite <emph>Shrani z geslom</emph> in kliknite gumb <emph>Shrani</emph>. Pojavi se pogovorno okno <emph>Vnesite geslo</emph>. Geslo izberite premišljeno – če ga pozabite, ko zaprete dokument, ne boste mogli dostopati do dokumenta."
+msgid "You can completely protect your work by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password entry. If you want to prevent the document from being opened by other users, select <emph>Save With Password </emph>and click the <emph>Save</emph> button. The <emph>Enter Password</emph> dialog appears. Consider carefully when choosing a password; if you forget it after you close a document you will be unable to access the document."
+msgstr "Vaše delo lahko popolnoma zaščitite z uporabo obeh možnosti <emph>Orodja – Zaščiti delovni list</emph> in <emph>Orodja – Zaščiti strukturo preglednice</emph>, skupaj z geselsko zaščito. Če ne želite, da drugi uporabniki odpirajo dokument, izberite <emph>Shrani z geslom</emph> in kliknite gumb <emph>Shrani</emph>. Pojavi se pogovorno okno <emph>Vnesite geslo</emph>. Geslo izberite premišljeno – če ga pozabite, ko zaprete dokument, ne boste mogli dostopati do dokumenta."
#: 06070000.xhp
msgctxt ""
@@ -44414,8 +44462,8 @@ msgctxt ""
"06070000.xhp\n"
"bm_id3145673\n"
"help.text"
-msgid "<bookmark_value>calculating; auto calculating sheets</bookmark_value><bookmark_value>recalculating;auto calculating sheets</bookmark_value><bookmark_value>AutoCalculate function in sheets</bookmark_value><bookmark_value>correcting sheets automatically</bookmark_value><bookmark_value>formulas;AutoCalculate function</bookmark_value><bookmark_value>cell contents;AutoCalculate function</bookmark_value>"
-msgstr "<bookmark_value>računanje; samodejni izračuni delovnih listov</bookmark_value><bookmark_value>preračunavanje;samodejni izračuni delovnih listov</bookmark_value><bookmark_value>funkcija AutoCalculate v delovnih listih</bookmark_value><bookmark_value>samodejno popravljanje delovnih listov</bookmark_value><bookmark_value>formule;funkcija AutoCalculate</bookmark_value><bookmark_value>vsebina celic;funkcija AutoCalculate</bookmark_value>"
+msgid "<bookmark_value>calculating; auto calculating sheets</bookmark_value><bookmark_value>recalculate;auto calculating sheets</bookmark_value><bookmark_value>recalculating;auto calculating sheets</bookmark_value><bookmark_value>AutoCalculate function in sheets</bookmark_value><bookmark_value>correcting sheets automatically</bookmark_value><bookmark_value>formulas;AutoCalculate function</bookmark_value><bookmark_value>cell contents;AutoCalculate function</bookmark_value>"
+msgstr "<bookmark_value>računanje; samodejni izračuni delovnih listov</bookmark_value><bookmark_value>ponovno računanje; samodejni izračuni delovnih listov</bookmark_value><bookmark_value>preračunavanje;samodejni izračuni delovnih listov</bookmark_value><bookmark_value>funkcija AutoCalculate v delovnih listih</bookmark_value><bookmark_value>samodejno popravljanje delovnih listov</bookmark_value><bookmark_value>formule;funkcija AutoCalculate</bookmark_value><bookmark_value>vsebina celic;funkcija AutoCalculate</bookmark_value>"
#: 06070000.xhp
msgctxt ""
@@ -44454,8 +44502,8 @@ msgctxt ""
"06080000.xhp\n"
"bm_id3157909\n"
"help.text"
-msgid "<bookmark_value>recalculating;all formulas in sheets</bookmark_value><bookmark_value>formulas; recalculating manually</bookmark_value><bookmark_value>cell contents; recalculating</bookmark_value>"
-msgstr "<bookmark_value>ponovno računanje;vse formule v delovnih listih</bookmark_value><bookmark_value>formule; ročni ponovni izračun</bookmark_value><bookmark_value>vsebina celic; ponovno računanje</bookmark_value>"
+msgid "<bookmark_value>recalculating;all formulas in sheets</bookmark_value><bookmark_value>recalculate;all formulas in sheets</bookmark_value><bookmark_value>formulas; recalculating manually</bookmark_value><bookmark_value>cell contents; recalculating</bookmark_value>"
+msgstr "<bookmark_value>ponovno računanje;vse formule v delovnih listih</bookmark_value><bookmark_value>preračunavanje;vse formule v delovnih listih</bookmark_value><bookmark_value>formule; ročni ponovni izračun</bookmark_value><bookmark_value>vsebina celic; ponovno računanje</bookmark_value>"
#: 06080000.xhp
msgctxt ""
@@ -44470,8 +44518,24 @@ msgctxt ""
"06080000.xhp\n"
"par_id3154758\n"
"help.text"
-msgid "<ahelp hid=\".uno:Calculate\">Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.</ahelp>"
-msgstr "<ahelp hid=\".uno:Calculate\">Ponovno izračuna vse spremenjene formule. Če je funkcija Samodejno izračunaj omogočena, se ukaz Ponovno izračunaj nanaša le na formule, kot sta RAND ali NOW.</ahelp>"
+msgid "<ahelp hid=\".uno:Calculate\">If AutoCalculate is disabled, the Recalculate command recalculates all (so-called dirty) formula cells that depend on changed cell content and their dependents, and formula cells containing volatile functions such as RAND() or NOW() and formula cells that depend on them.</ahelp>"
+msgstr "<ahelp hid=\".uno:Calculate\">Če je funkcija Samodejno izračunaj onemogočena, ukaz Ponovno izračunaj ponovno preračuna vse (t.i. umazane) celice s formulami, ki so odvisne od spremenjene vsebine celic in njihovih odvisnikov, celice s formulami, ki vsebujejo volatilne funkcije, kot sta RAND() in NOW() in celice s formulami, ki so od njih odvisne.</ahelp>"
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3154759\n"
+"help.text"
+msgid "<ahelp hid=\".uno:Calculate\">If AutoCalculate is enabled, the Recalculate command applies only to formula cells containing volatile functions like RAND() or NOW() and formula cells that depend on them.</ahelp>"
+msgstr "<ahelp hid=\".uno:Calculate\">Če je funkcija Samodejno izračunaj omogočena, se ukaz Ponovno izračunaj nanaša le na celice s formulami, ki vsebujejo spremenljive funkcije, kot sta RAND() ali NOW(), ter celice s formulami, ki so od njih odvisne.</ahelp>"
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3154753\n"
+"help.text"
+msgid "<ahelp hid=\".uno:Calculate\">In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation.</ahelp>"
+msgstr "<ahelp hid=\".uno:Calculate\">V obeh načinih z izbranimi celicami s formulami s pritiskom tipke F9 ponovno izračunate trenutno izbrane celice in celice s formulami, ki so od njih odvisne. To je lahko uporabno po ponovnem branju dokumentov z onemogočenim ponovnim računanjem, ko posamezne celice potrebujejo preračunavanje.</ahelp>"
#: 06080000.xhp
msgctxt ""
@@ -44486,17 +44550,32 @@ msgctxt ""
"06080000.xhp\n"
"par_id3150793\n"
"help.text"
-msgid "After the document has been recalculated, the display is refreshed. All charts are also refreshed."
-msgstr "Po ponovnem izračunu dokumenta se prikaz osveži. Prav tako se osvežijo vsi grafikoni."
+msgid "Recalculation options are, Recalculation on File Load, with values:"
+msgstr "Možnosti ponovnega izračuna za Ponovno izračunaj ob nalaganju datoteke so vrednosti:"
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3150795\n"
+"help.text"
+msgid "Always recalculate, Never recalculate (default option), Prompt user."
+msgstr "Vedno preračunaj, Nikoli ne preračunaj (privzeta možnost), Vprašaj uporabnika."
#: 06080000.xhp
-#, fuzzy
msgctxt ""
"06080000.xhp\n"
"par_id315475855\n"
"help.text"
-msgid "Volatile (delivering different results on each call) Add-In functions currently cannot respond to the Recalculate command or F9. Press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas, including the Add-In functions."
-msgstr "Volatilne funkcije (ki z vsakim klicem vrnejo različen rezultat), se trenutno še ne morejo odzvati na ukaz Ponovno izračunaj ali F9. Pritisnite kombinacijo tipk dvigalka+<switchinline select=\"sys\"><caseinline select=\"MAC\">Cmd</caseinline><defaultinline>krmilka</defaultinline></switchinline>+F9, če želite preračunati vse formule, vključno s funkcijami dodatkov."
+msgid "Press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells."
+msgstr "Pritisnite kombinacijo tipk dvigalka+<switchinline select=\"sys\"><caseinline select=\"MAC\">Cmd</caseinline><defaultinline>krmilka</defaultinline></switchinline>+F9, če želite preračun vseh formul v dokumentu, vključno s funkcijami dodatkov. Strogi preračun pravilno preračuna vse celice s formulami."
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3150799\n"
+"help.text"
+msgid "After the document has been recalculated, the display is refreshed. All charts are also refreshed."
+msgstr "Po ponovnem izračunu dokumenta se prikaz osveži. Prav tako se osvežijo vsi grafikoni."
#: 06130000.xhp
msgctxt ""
@@ -44791,8 +44870,8 @@ msgctxt ""
"12010100.xhp\n"
"par_id3154684\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh</emph> <emph>Range</emph>."
-msgstr "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Samodejno vstavi nove vrstice in stolpce v obseg podatkovne zbirke vašega dokumenta, ko dodate v podatkovno zbirko nove zapise.</ahelp> Če želite ročno posodobiti obseg podatkovne zbirke, izberite <emph>Podatki – Osveži</emph> <emph>Obseg</emph>."
+msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh Range</emph>."
+msgstr "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Samodejno vstavi nove vrstice in stolpce v obseg podatkovne zbirke vašega dokumenta, ko dodate v podatkovno zbirko nove zapise.</ahelp> Če želite ročno posodobiti obseg podatkovne zbirke, izberite <emph>Podatki – Osveži obseg</emph>."
#: 12010100.xhp
msgctxt ""
@@ -49333,10 +49412,10 @@ msgstr "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/errorMsg\">Vnesite sporo
#: 12120300.xhp
msgctxt ""
"12120300.xhp\n"
-"par_id3150752\n"
+"hd_id881545240342781\n"
"help.text"
-msgid "<emph>Sample macro:</emph>"
-msgstr "<emph>Vzorčni makro:</emph>"
+msgid "Sample macro:"
+msgstr "Vzorčni makro:"
#: ODFF.xhp
msgctxt ""
@@ -49355,7 +49434,6 @@ msgid "This function is part of the Open Document Format for Office Applications
msgstr "Ta funkcija je del standarda Open Document Format for Office Applications (OpenDocument) različice 1.2 (ISO/IEC 26300:2-2015)."
#: common_func.xhp
-#, fuzzy
msgctxt ""
"common_func.xhp\n"
"tit\n"
@@ -52136,8 +52214,8 @@ msgctxt ""
"func_days.xhp\n"
"par_id3159101\n"
"help.text"
-msgid "<item type=\"input\">=DAYS(\"2010-01-01\"; NOW())</item> returns the number of days from today until January 1, 2010."
-msgstr "<item type=\"input\">=DAYS(\"2010-01-01\"; NOW())</item> vrne število dni od danes do 1. januarja 2010."
+msgid "<item type=\"input\">=DAYS(NOW();\"2010-01-01\"))</item> returns the number of days from January 1, 2010 until today."
+msgstr "<item type=\"input\">=DAYS(NOW();\"2000-01-01\")</item> vrne število dni od 1. januarja 2000 do danes."
#: func_days.xhp
msgctxt ""
@@ -55123,6 +55201,142 @@ msgctxt ""
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_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"tit\n"
+"help.text"
+msgid "REGEX Function"
+msgstr "Funkcija REGEX"
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"bm_id831542233029549\n"
+"help.text"
+msgid "<bookmark_value>REGEX function</bookmark_value> <bookmark_value>regular expressions;extracting in spreadsheets</bookmark_value> <bookmark_value>regular expressions;REGEX function</bookmark_value>"
+msgstr "<bookmark_value>funkcija REGEX</bookmark_value><bookmark_value>regularni izrazi;izluščenje v preglednicah</bookmark_value><bookmark_value>regularni izrazi;funkcija REGEX</bookmark_value>"
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"hd_id961542230672100\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/func_regex.xhp\" name=\"function REGEX\">REGEX</link>"
+msgstr "<link href=\"text/scalc/01/func_regex.xhp\" name=\"Funkcija REGEX\">REGEX</link>"
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id541542230672101\n"
+"help.text"
+msgid "<variable id=\"func_regex_desc\"><ahelp hid=\".\">Matches and extracts or optionally replaces text using regular expressions.</ahelp></variable>"
+msgstr "<variable id=\"func_regex_desc\"><ahelp hid=\".\">Najde zadetke s pomočjo regularnih izrazov in po potrebi zamenja besedilo.</ahelp></variable>"
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id701542231253817\n"
+"help.text"
+msgid "REGEX( Text ; Expression [ ; [ Replacement ] [ ; Flags|Occurrence ] ] )"
+msgstr "REGEX( besedilo ; izraz [ ; [ zamenjava ] [ ; zastavice|pojavitev ] ] )"
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id621542232197446\n"
+"help.text"
+msgid "<emph>Text</emph>: A text or reference to a cell where the regular expression is to be applied."
+msgstr "<emph>Besedilo</emph>: besedilo ali sklic na celico, v kateri naj se uveljavi regularni izraz."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id211542232209275\n"
+"help.text"
+msgid "<emph>Expression</emph>: A text representing the regular expression, using <link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>. If there is no match and <emph>Replacement</emph> is not given, #N/A is returned."
+msgstr "<emph>Izraz</emph>: besedilo, ki predstavlja regularni izraz z uporabo <link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">regularnih izrazov ICU</link>. Če ni zadetkov in <emph>zamenjava</emph> ni podana, vrne #N/A."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id581542232755604\n"
+"help.text"
+msgid "<emph>Replacement</emph>: Optional. The replacement text and references to capture groups. If there is no match, <emph>Text</emph> is returned unmodified."
+msgstr "<emph>Zamenjava</emph>: neobvezno. Besedilo za zamenjavo in sklici na skupine zajema. Če ni zadetkov, vrne <emph>besedilo</emph> nespremenjeno."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id421542232246840\n"
+"help.text"
+msgid "<emph>Flags</emph>: Optional. \"g\" replaces all matches of <emph>Expression</emph> in <emph>Text</emph>, not extracted. If there is no match, <emph>Text</emph> is returned unmodified."
+msgstr "<emph>Zastavice</emph>: neobvezno. »g« zamenja vse zadetke <emph>izraza</emph> v <emph>besedilu</emph> brez izluščenja. Če zadetka ni, vrne <emph>besedilo</emph> nespremenjeno."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id421542232246841\n"
+"help.text"
+msgid "<emph>Occurrence</emph>: Optional. Number to indicate which match of <emph>Expression</emph> in <emph>Text</emph> is to be extracted or replaced. If there is no match and <emph>Replacement</emph> is not given, #N/A is returned. If there is no match and <emph>Replacement</emph> is given, <emph>Text</emph> is returned unmodified. If <emph>Occurrence</emph> is 0, <emph>Text</emph> is returned unmodified."
+msgstr "<emph>Pojavitev</emph>: neobvezno. Številka zadetka <emph>izraza</emph> v <emph>besedilu</emph>, ki bo izluščen oz. zamenjan. Če ni zadetkov in <emph>zamenjava</emph> ni podana, vrne vrednost #N/A. Če ni zadetkov in je podana <emph>zamenjava</emph>, se <emph>besedilo</emph> vrne nespremenjeno. Če je <emph>pojavitev</emph> enaka 0, se <emph>besedilo</emph> vrne nespremenjeno."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id371542291684176\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\")</item> returns \"Z23456ABCDEF\", where the first match of a digit is replaced by \"Z\"."
+msgstr "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\")</item> vrne »Z23456ABCDEF«, kjer prvi zadetek števke zamenja »Z«."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id891542291697194\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\";\"g\")</item> returns \"ZZZZZZABCDEF\", where all digits were replaced by \"Z\"."
+msgstr "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\";\"g\")</item> vrne »ZZZZZZABCDEF«, kjer vse števke zamenja »Z«."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id21542291705695\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[126]\";\"\";\"g\")</item> returns \"345ABCDEF\", where any occurrence of \"1\", \"2\" or \"6\" is replaced by the empty string, thus deleted."
+msgstr "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[126]\";\"\";\"g\")</item> vrne »345ABCDEF«. Vsako pojavitev »1«, »2« in »6« zamenja prazen niz, torej so izbrisane."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id371542291684177\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"axbxcxd\";\".x\";;2)</item> returns \"bx\", the second match of \".x\"."
+msgstr "<item type=\"input\">=REGEX(\"axbxcxd\";\".x\";;2)</item> vrne »bx«, torej drugi zadetek za ».x«."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id371542291684178\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"axbxcxd\";\"(.)x\";\"$1y\";2)</item> returns \"axbycxd\", the second match of \"(.)x\" (i.e. \"bx\") replaced with the captured group of one character (i.e. \"b\") followed by \"y\"."
+msgstr "<item type=\"input\">=REGEX(\"axbxcxd\";\"(.)x\";\"$1y\";2)</item> vrne \"axbycxd\", drugi zadetek \"(.)x\" (t.j. »bx«), zamenjan z zajeto skupino enega znaka (t.j. »b«), čemur sledi »y«."
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id711542233602553\n"
+"help.text"
+msgid "<link href=\"text/shared/01/02100001.xhp\" name=\"regex lists\">List of regular expressions</link>"
+msgstr "<link href=\"text/shared/01/02100001.xhp\" name=\"Seznam regularnih izrazov\">Seznam regularnih izrazov</link>"
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id431542233650614\n"
+"help.text"
+msgid "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>"
+msgstr "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"Dokumentacija regularnih izrazov ICU\">Dokumentacija regularnih izrazov ICU</link> (v angl.)"
+
#: func_roundsig.xhp
msgctxt ""
"func_roundsig.xhp\n"
@@ -55784,8 +55998,8 @@ msgctxt ""
"func_webservice.xhp\n"
"hd_id3149012\n"
"help.text"
-msgid "WEBSERVICE"
-msgstr "WEBSERVICE"
+msgid "<variable id=\"webservicefuncname\"><link href=\"text/scalc/01/func_webservice.xhp#webservice\" name=\"webservice\">WEBSERVICE</link></variable>"
+msgstr "<variable id=\"webservicefuncname\"><link href=\"text/scalc/01/func_webservice.xhp#webservice\" name=\"webservice\">WEBSERVICE</link></variable>"
#: func_webservice.xhp
msgctxt ""
@@ -55840,8 +56054,8 @@ msgctxt ""
"func_webservice.xhp\n"
"hd_id2949012\n"
"help.text"
-msgid "FILTERXML"
-msgstr "FILTERXML"
+msgid "<variable id=\"filterxmlfuncname\"><link href=\"text/scalc/01/func_webservice.xhp#filterxml\" name=\"filterxml\">FILTERXML</link></variable>"
+msgstr "<variable id=\"filterxmlfuncname\"><link href=\"text/scalc/01/func_webservice.xhp#filterxml\" name=\"filterxml\">FILTERXML</link></variable>"
#: func_webservice.xhp
msgctxt ""
@@ -55904,8 +56118,8 @@ msgctxt ""
"func_webservice.xhp\n"
"hd_id671517132649769\n"
"help.text"
-msgid "ENCODEURL function"
-msgstr "ENCODEURL"
+msgid "<variable id=\"encodeurlname\"><link href=\"text/scalc/01/func_webservice.xhp#encodeurl\" name=\"linkname\">ENCODEURL</link></variable>"
+msgstr "<variable id=\"encodeurlname\"><link href=\"text/scalc/01/func_webservice.xhp#encodeurl\" name=\"linkname\">ENCODEURL</link></variable>"
#: func_webservice.xhp
msgctxt ""
@@ -58086,6 +58300,14 @@ msgstr "Vrednost P"
#: statistics.xhp
msgctxt ""
"statistics.xhp\n"
+"par_id841554943563747\n"
+"help.text"
+msgid "F-critical"
+msgstr "Kritični F"
+
+#: statistics.xhp
+msgctxt ""
+"statistics.xhp\n"
"par_id1001610\n"
"help.text"
msgid "Between Groups"
@@ -58094,6 +58316,14 @@ msgstr "Med skupinami"
#: statistics.xhp
msgctxt ""
"statistics.xhp\n"
+"par_id411554944014360\n"
+"help.text"
+msgid "3.340385558"
+msgstr "3,340385558"
+
+#: statistics.xhp
+msgctxt ""
+"statistics.xhp\n"
"par_id1001670\n"
"help.text"
msgid "Within Groups"