update translations for master

and force-fix errors using pocheck

Change-Id: Ib744c61a45769eee462d6014d37f75a863c265a9

1 files changed, 288 insertions, 313 deletions

diff --git a/source/eu/helpcontent2/source/text/scalc/01.po b/source/eu/helpcontent2/source/text/scalc/01.po
index d64ab40c221..76d27faa5ad 100644
--- a/source/eu/helpcontent2/source/text/scalc/01.po
+++ b/source/eu/helpcontent2/source/text/scalc/01.po
@@ -3,8 +3,8 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-30 15:37+0100\n"
-"PO-Revision-Date: 2021-01-23 17:36+0000\n"
+"POT-Creation-Date: 2021-02-05 18:59+0100\n"
+"PO-Revision-Date: 2021-02-04 20:36+0000\n"
 "Last-Translator: Asier Sarasua Garmendia <asiersar@yahoo.com>\n"
 "Language-Team: Basque <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/eu/>\n"
 "Language: eu\n"
@@ -5893,6 +5893,24 @@ msgctxt ""
 msgid "<emph>Rate</emph> is the rate of depreciation."
 msgstr "<emph>Tasa</emph>: amortizazio-tasa da"
 
+#. TzEBm
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id421612299085248\n"
+"help.text"
+msgid "An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming degressive depreciation, what is the amount of depreciation in the fourth depreciation period?"
+msgstr ""
+
+#. qyD4t
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id901612299089478\n"
+"help.text"
+msgid "<input>=AMORDEGRC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units."
+msgstr ""
+
 #. UCPgp
 #: 04060103.xhp
 msgctxt ""
@@ -5983,6 +6001,24 @@ msgctxt ""
 msgid "<emph>Rate</emph> is the rate of depreciation."
 msgstr "<emph>Tasa</emph>: amortizazio-tasa da"
 
+#. vJKVs
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id641612299092454\n"
+"help.text"
+msgid "An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming linear depreciation, what is the amount of depreciation in the fourth depreciation period?"
+msgstr ""
+
+#. zcGNo
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id391612299096511\n"
+"help.text"
+msgid "<input>=AMORLINC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 200 currency units."
+msgstr ""
+
 #. DHKDL
 #: 04060103.xhp
 msgctxt ""
@@ -6172,14 +6208,23 @@ msgctxt ""
 msgid "<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)."
 msgstr "<emph>Tasa</emph> (ezinbestekoa) urteko interes-tasa nominala (interes nominala)."
 
-#. qAZtL
+#. GPEHn
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3159204\n"
 "help.text"
-msgid "<emph>Par</emph> (optional) is the par value of the security."
-msgstr "<emph>Balio nominala</emph> (aukerakoa) balorearen balio nominalaren da."
+msgid "<emph>Par</emph> (optional) is the par value of the security. If omitted, a default value of 1000 is used."
+msgstr ""
+
+#. EJaKm
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id481612296978513\n"
+"help.text"
+msgid "We recommend that you always specify the value that you require for ACCRINTM’s <emph>Par</emph> argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain."
+msgstr ""
 
 #. nB5zK
 #: 04060103.xhp
@@ -7531,32 +7576,23 @@ msgctxt ""
 msgid "<emph>Month</emph> (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default."
 msgstr "<emph>Hilabetea</emph> aukerak (aukerakoa) amortizazioaren lehen urteko hilabete kopurua definitzen du. Sarrerarik definitzen ez bada, 12 erabiliko ba balio lehenetsi gisa."
 
-#. YDw8X
+#. D2krK
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3156147\n"
 "help.text"
-msgid "A computer system with an initial cost of 25,000 currency units is to be depreciated over a three year period. The salvage value is to be 1,000 currency units. One period is 30 days."
-msgstr "25.000 moneta-unitateko hasierako kostua duen ordenagailu-sistema bat 3 urtean amortizatu nahi duzu. Hondar-balioa 1.000 moneta-unitatekoa izango da. Epealdi bat 30 egunekoa da."
+msgid "A computer system with an initial cost of 25,000 currency units is to be depreciated over a three-year period. The salvage value is to be 1,000 currency units. The first period of depreciation comprises 6 months. What is the fixed-declining balance depreciation of the computer system in the second period, which is a full year starting from the end of the first six-month period?"
+msgstr ""
 
-#. DpiBb
+#. 4CQGc
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3149513\n"
 "help.text"
-msgid "<item type=\"input\">=DB(25000;1000;36;1;6)</item> = 1,075.00 currency units"
-msgstr "<item type=\"input\">=DB(25000;1000;36;1;6)</item> = 1,075.00 moneta-unitateak"
-
-#. 9hDAg
-#: 04060103.xhp
-msgctxt ""
-"04060103.xhp\n"
-"par_id3159242\n"
-"help.text"
-msgid "The fixed-declining depreciation of the computer system is 1,075.00 currency units."
-msgstr "Ordenagailu-sistemaren amortizazio beherakor finkoa 1.075,00 moneta-unitatekoa da."
+msgid "<input>=DB(25000; 1000; 3; 2; 6)</input> returns 11,037.95 currency units."
+msgstr ""
 
 #. fWK6h
 #: 04060103.xhp
@@ -10211,7 +10247,7 @@ msgctxt ""
 "par_id3154558\n"
 "help.text"
 msgid "IF(Test [; [ThenValue] [; [OtherwiseValue]]])"
-msgstr ""
+msgstr "IF(Proba [; [OrduanBalioa] [; [BestelaBalioa]]])"
 
 #. JnjcT
 #: 04060105.xhp
@@ -10247,7 +10283,7 @@ msgctxt ""
 "par_id3150867\n"
 "help.text"
 msgid "<input>=IF(A1>5;100;\"too small\")</input> If the value in <literal>A1</literal> is greater than <literal>5</literal>, the value <literal>100</literal> is returned; otherwise, the text <literal>too small</literal> is returned."
-msgstr ""
+msgstr "<input>=IF(A1>5;100;\"txikiegia\")</input> <literal>A1</literal> gelaxkako balioa <literal>5</literal> baino handiagoa bada, <literal>100</literal> balioa itzuliko da; bestela, <literal>txikiegia</literal> testua itzuliko da."
 
 #. jvk3H
 #: 04060105.xhp
@@ -10256,7 +10292,7 @@ msgctxt ""
 "par_id71607569817532\n"
 "help.text"
 msgid "<input>=IF(A1>5;;\"too small\")</input> If the value in <literal>A1</literal> is greater than <literal>5</literal>, the value <literal>0</literal> is returned because empty parameters are considered to be <literal>0</literal>; otherwise, the text <literal>too small</literal> is returned."
-msgstr ""
+msgstr "<input>=IF(A1>5;;\"txikiegia\")</input> <literal>A1</literal> gelaxkako balioa <literal>5</literal> baino handiagoa bada, <literal>0</literal> balioa itzuliko da, parametro hutsak <literal>0</literal> direla kontsideratzen baita; bestela, <literal>txikiegia</literal> testua itzuliko da."
 
 #. Q6yTs
 #: 04060105.xhp
@@ -10265,7 +10301,7 @@ msgctxt ""
 "par_id11607570458867\n"
 "help.text"
 msgid "<input>=IF(A1>5;100;)</input> If the value in <literal>A1</literal> is less than <literal>5</literal>, the value <literal>0</literal> is returned because the empty <emph>OtherwiseValue</emph> is interpreted as <literal>0</literal>; otherwise <literal>100</literal> is returned."
-msgstr ""
+msgstr "<input>=IF(A1>5;100;)</input> <literal>A1</literal> gelaxkako balioa <literal>5</literal> baino txikiagoa bada, <literal>0</literal> balioa itzuliko da, <emph>BestelaBalioa</emph> balio hutsa <literal>0</literal> dela kontsideratzen baita; bestela, <literal>100</literal> itzuliko da."
 
 #. BKYkX
 #: 04060105.xhp
@@ -15512,7 +15548,7 @@ msgctxt ""
 "par_id6757103\n"
 "help.text"
 msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
-msgstr "Matrize-konstante hau sartzeko, hautatu errenkada bateko hiru gelaxka, sartu <item type=\"input\">={1;2;3}</item> formula giltzak eta puntu eta komak erabiliz, eta ondoren sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + ⇧ + ↵</emph>."
+msgstr "Matrize-konstante hau sartzeko, hautatu errenkada bateko hiru gelaxka, sartu <item type=\"input\">={1;2;3}</item> formula giltzak eta puntu eta komak erabiliz, eta ondoren sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+⇧+⏎</emph>."
 
 #. uTzcj
 #: 04060107.xhp
@@ -15602,7 +15638,7 @@ msgctxt ""
 "par_id3154798\n"
 "help.text"
 msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
-msgstr "Aldaketak egin ondoren, sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+ ⇧ + ↵</emph>."
+msgstr "Aldaketak egin ondoren, sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+⇧+⏎</emph>."
 
 #. AKFjm
 #: 04060107.xhp
@@ -15665,7 +15701,7 @@ msgctxt ""
 "par_id3154419\n"
 "help.text"
 msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The selected range now contains the array formula."
-msgstr "Formula itsasteko, sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> hautatutako gunean eta baieztatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + ⇧ + ↵</emph> sakatuta. Horrela, hautatutako barrutiak matrize-formula izango du."
+msgstr "Formula itsasteko, sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> hautatutako gunean eta baieztatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+⇧+⏎</emph> sakatuta. Horrela, hautatutako barrutiak matrize-formula izango du."
 
 #. HehUu
 #: 04060107.xhp
@@ -15980,7 +16016,7 @@ msgctxt ""
 "par_id3150403\n"
 "help.text"
 msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift + Command + Enter</item></caseinline><defaultinline><item type=\"keycode\">Shift + Ctrl + Enter</item></defaultinline></switchinline>."
-msgstr "<item type=\"input\">=MUNIT(5)</item> formula hautatutako barrutiaren azken gelaxkan (E5) ere sar daiteke, eta ondoren <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">⇧ + ⌘ + ↵</item></caseinline><defaultinline><item type=\"keycode\">⇧ + Ctrl + ↵</item></defaultinline></switchinline> sakatu."
+msgstr "<item type=\"input\">=MUNIT(5)</item> formula hautatutako barrutiaren azken gelaxkan (E5) ere sar daiteke, eta ondoren <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">⇧+⌘+⏎</item></caseinline><defaultinline><item type=\"keycode\">⇧+Ctrl+⏎</item></defaultinline></switchinline> sakatu."
 
 #. gB9Be
 #: 04060107.xhp
@@ -16304,7 +16340,7 @@ msgctxt ""
 "par_id3159366\n"
 "help.text"
 msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes."
-msgstr "Kalkulu-orrian, hautatu trukatu beharreko matrizea izango duen barrutia. Jatorrizko matrizeak n errenkada eta m zutabe baditu, zuk hautatutako barrutiak gutxienez m errenkada eta n zutabe izan behar ditu. Orduan sartu formula zuzenean, hautatu jatorrizko matrizea eta sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⇧⌘↵</emph></caseinline><defaultinline><emph>⇧+Ctrl+↵</emph></defaultinline></switchinline>. Edo, <emph>Funtzioen morroia</emph> erabiltzen ari bazara, hautatu <emph>Matrizea</emph> kontrol-laukia. Trukatutako matrizea hautatutako helburuko barrutian agertuko da, eta automatikoki babestuta egongo da aldaketen aurka."
+msgstr "Kalkulu-orrian, hautatu trukatu beharreko matrizea izango duen barrutia. Jatorrizko matrizeak n errenkada eta m zutabe baditu, zuk hautatutako barrutiak gutxienez m errenkada eta n zutabe izan behar ditu. Orduan sartu formula zuzenean, hautatu jatorrizko matrizea eta sakatu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⇧+⌘+⏎</emph></caseinline><defaultinline><emph>⇧+Ctrl+⏎</emph></defaultinline></switchinline>. Edo, <emph>Funtzioen morroia</emph> erabiltzen ari bazara, hautatu <emph>Matrizea</emph> kontrol-laukia. Trukatutako matrizea hautatutako helburuko barrutian agertuko da, eta automatikoki babestuta egongo da aldaketen aurka."
 
 #. 3oHh6
 #: 04060107.xhp
@@ -16331,7 +16367,7 @@ msgctxt ""
 "par_id3178518\n"
 "help.text"
 msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:"
-msgstr "Ondoren, <emph>ziurtatu matrize-formula gisa sartzen dela </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⇧ + ⌘ + ↵</emph></caseinline><defaultinline><emph>⇧ + Ctrl + ↵</emph></defaultinline></switchinline> erabilita. Emaitza honakoa izango da:"
+msgstr "Ondoren, <emph>ziurtatu matrize-formula gisa sartzen dela </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⇧+⌘+⏎</emph></caseinline><defaultinline><emph>⇧+Ctrl+⏎</emph></defaultinline></switchinline> erabilita. Emaitza honakoa izango da:"
 
 #. CGWog
 #: 04060107.xhp
@@ -16421,7 +16457,7 @@ msgctxt ""
 "par_id0811200804502261\n"
 "help.text"
 msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Return</emph> rather than just <emph>Return</emph>)."
-msgstr "LINEST funtzioak estatistikako taula (matrize) bat ematen du, eta matrize-formula gisa sartu behar da (adibidez <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + ⇧ + ↵</emph> erabiliz, <emph>↵</emph> soilik erabili beharrean)."
+msgstr "LINEST funtzioak estatistikako taula (matrize) bat ematen du, eta matrize-formula gisa sartu behar da (adibidez <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>⌘</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+⇧+⏎</emph> erabiliz, <emph>⏎</emph> soilik erabili beharrean)."
 
 #. 7ckGM
 #: 04060107.xhp
@@ -18457,14 +18493,14 @@ msgctxt ""
 msgid "SHEET"
 msgstr "SHEET"
 
-#. GkhfA
+#. BRXnw
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3150309\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula."
-msgstr "<ahelp hid=\"HID_FUNC_TABELLE\">Erreferentzia baten edo orri-izen bat adierazten duen kate baten orri-zenbakia ematen du.</ahelp> Ez baduzu parametrorik sartzen, formula duen kalkulu-orriaren orri-zenbakia izango da emaitza."
+msgid "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of either a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula."
+msgstr ""
 
 #. KRzAZ
 #: 04060109.xhp
@@ -18484,14 +18520,23 @@ msgctxt ""
 msgid "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string."
 msgstr "<emph>Erreferentzia</emph>: gelaxka baten, barruti baten edo orri-izen baten karaktere-katearen erreferentzia. Aukerakoa da."
 
-#. SEDm6
+#. wbjCM
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3146988\n"
 "help.text"
-msgid "<item type=\"input\">=SHEET(Sheet2.A1)</item> returns 2 if Sheet2 is the second sheet in the spreadsheet document."
-msgstr "<item type=\"input\">=SHEET(Orria2.A1)</item>: 2 ematen du, Orria2 kalkulu-orriko bigarren orria bada."
+msgid "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document."
+msgstr ""
+
+#. fEQws
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id491612531793751\n"
+"help.text"
+msgid "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document."
+msgstr ""
 
 #. 7ZBfD
 #: 04060109.xhp
@@ -19087,6 +19132,78 @@ msgctxt ""
 msgid "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\" name=\"VLOOKUP\">VLOOKUP</link> (columns and rows are exchanged)"
 msgstr "Parametroen azalpena ezagutzeko, ikus: <link href=\"text/scalc/01/04060109.xhp#Section9\" name=\"VLOOKUP\">VLOOKUP</link> (zutabeak eta errenkadak trukatuta daude)"
 
+#. vwqHz
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id141612447324913\n"
+"help.text"
+msgid "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”."
+msgstr ""
+
+#. BcKD5
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id711612450364379\n"
+"help.text"
+msgid "Hydrogen"
+msgstr ""
+
+#. ACHPj
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id681612450364379\n"
+"help.text"
+msgid "Helium"
+msgstr ""
+
+#. 7YEmL
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id531612453345232\n"
+"help.text"
+msgid "Lithium"
+msgstr ""
+
+#. Y3c6z
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id571612453039430\n"
+"help.text"
+msgid "Oganesson"
+msgstr ""
+
+#. Cb3HA
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id51612447346319\n"
+"help.text"
+msgid "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead."
+msgstr ""
+
+#. Fa8kD
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id291612447349416\n"
+"help.text"
+msgid "<input>=HLOOKUP(\"Gold\"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold."
+msgstr ""
+
+#. LbWuo
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id971612447352912\n"
+"help.text"
+msgid "<input>=HLOOKUP(\"Carbon\"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon."
+msgstr ""
+
 #. B4DL3
 #: 04060109.xhp
 msgctxt ""
@@ -19535,7 +19652,7 @@ msgctxt ""
 "par_id7928708\n"
 "help.text"
 msgid "If no constraint for a filter is given, the field's selected value is implicitly used. If a constraint for a filter is given, it must match the field's selected value, or an error is returned. Filters are the fields at the top left of a pivot table, populated using the \"Filters\" area of the pivot table layout dialog. From each filter, an item (value) can be selected, which means only that item is included in the calculation."
-msgstr ""
+msgstr "Iragazki baterako murriztapenik ematen ez bada, eremuan hautatutako balioa erabiliko da. Iragazki baterako murriztapen bat ematen bada, eremuan hautatutako balioarekin bat etorri behar du, bestela errorea itzuliko da. Iragazkiak taula dinamikoaren goian ezkerrean dauden eremuak dira, taula dinamikoaren diseinu-koadroko \"Iragazkiak\" area erabilita betetzen direnak. Iragazki bakoitzerako, elementu (balio) bat hautatu daiteke, alegia, elementu hori besterik ez da sartuko kalkuluan."
 
 #. nARMD
 #: 04060109.xhp
@@ -28141,203 +28258,41 @@ msgctxt ""
 msgid "<emph>Guess</emph> (optional) is a guess that can be input for the internal rate of return. The default is 10%."
 msgstr "<emph>Estimazioa</emph> (aukerakoa): balio zenbatetsi bat sar daiteke barne-errendimenduaren tasarentzat. Lehenetsia % 10 da."
 
-#. NSjGJ
+#. dZESY
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3149273\n"
 "help.text"
-msgid "Calculation of the internal rate of return for the following five payments:"
-msgstr "Barne-errendimenduaren tasa kalkulatzea ondorengo bost ordainketa hauentzat:"
-
-#. eke7W
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3155838\n"
-"help.text"
-msgid "A"
-msgstr "A"
-
-#. LSV7U
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3152934\n"
-"help.text"
-msgid "B"
-msgstr "B"
-
-#. BGtK9
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3154638\n"
-"help.text"
-msgid "C"
-msgstr "C"
-
-#. WYW4F
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3147083\n"
-"help.text"
-msgid "1"
-msgstr "1"
-
-#. SwaVn
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3151187\n"
-"help.text"
-msgid "2001-01-01"
-msgstr "2001-01-01"
-
-#. ChsyU
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3145212\n"
-"help.text"
-msgid "-<item type=\"input\">10000</item>"
-msgstr "-<item type=\"input\">10000</item>"
+msgid "Calculation of the internal rate of return for the following five payments (dates are in ISO 8601 format):"
+msgstr ""
 
-#. rmGTa
+#. 6JTLA
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3146856\n"
 "help.text"
-msgid "<item type=\"input\">Received</item>"
-msgstr "<item type=\"input\">Jasota</item>"
-
-#. gxjFB
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3153277\n"
-"help.text"
-msgid "2"
-msgstr "2"
-
-#. e3a6n
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3154052\n"
-"help.text"
-msgid "2001-01-02"
-msgstr "2001-01-02"
-
-#. BLL9e
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3151297\n"
-"help.text"
-msgid "<item type=\"input\">2000</item>"
-msgstr "<item type=\"input\">2000</item>"
+msgid "Received"
+msgstr ""
 
-#. unr5K
+#. N2RNr
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3149985\n"
 "help.text"
-msgid "<item type=\"input\">Deposited</item>"
-msgstr "<item type=\"input\">Gordailu-sarrerak</item>"
-
-#. YCCCY
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3154744\n"
-"help.text"
-msgid "3"
-msgstr "3"
-
-#. uxnXF
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3153151\n"
-"help.text"
-msgid "2001-03-15"
-msgstr "2001-03-15"
-
-#. qzvoJ
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3145657\n"
-"help.text"
-msgid "2500"
-msgstr "2500"
-
-#. T6jHE
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3155101\n"
-"help.text"
-msgid "4"
-msgstr "4"
-
-#. 6qrWD
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3146894\n"
-"help.text"
-msgid "2001-05-12"
-msgstr "2001-05-12"
-
-#. cqxc3
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3143231\n"
-"help.text"
-msgid "5000"
-msgstr "5000"
-
-#. GkY8h
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3156012\n"
-"help.text"
-msgid "5"
-msgstr "5"
-
-#. X7PHP
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3149758\n"
-"help.text"
-msgid "2001-08-10"
-msgstr "2001-08-10"
-
-#. 5AWfe
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3147495\n"
-"help.text"
-msgid "1000"
-msgstr "1000"
+msgid "Deposited"
+msgstr ""
 
-#. 6ArE8
+#. FLNWb
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3152793\n"
 "help.text"
-msgid "=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828."
-msgstr "=XIRR(B1:B5; A1:A5; 0,1) funtzioak 0,1828 ematen du."
+msgid "<input>=XIRR(B1:B5; A1:A5; 0.1)</input> returns 0.1828 or 18.28%."
+msgstr ""
 
 #. HRiCT
 #: 04060118.xhp
@@ -35809,23 +35764,23 @@ msgctxt ""
 msgid "The inverse function is GAMMAINV or GAMMA.INV."
 msgstr "Alderantzizko funtzioa GAMMAINV edo GAMMA.INV da."
 
-#. F2Nsp
+#. P8Kc2
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id2406201422405814\n"
 "help.text"
-msgid "This function is identical to GAMMADIST and was introduced for interoperability with other office suites."
-msgstr "Funtzio hau GAMMADIST funtzioaren berdina da eta beste bulegotika-pakete batzuekin elkarrerabilgarritasuna bermatzeko sartu zen."
+msgid "This function is similar to GAMMADIST and was introduced for interoperability with other office suites."
+msgstr ""
 
-#. WGnD7
+#. Gk9Ch
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id240620142238475\n"
 "help.text"
-msgid "GAMMA.DIST(Number; Alpha; Beta; C)"
-msgstr "GAMMADIST(Zenbakia; Alfa; Beta; C)"
+msgid "GAMMA.DIST(Number; Alpha; Beta; Cumulative)"
+msgstr ""
 
 #. kLcmS
 #: 04060182.xhp
@@ -35854,14 +35809,14 @@ msgctxt ""
 msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution."
 msgstr "<emph>Beta</emph>: Gamma banaketaren Beta parametroa."
 
-#. 4nR86
+#. a6oxX
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id2406201422391058\n"
 "help.text"
-msgid "<emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution."
-msgstr "<emph>C</emph> (aukerakoa) = 0 edo Faltsua: dentsitate-funtzioa kalkulatzen du; <emph>C</emph> = 1 edo Egiazkoa: banaketa kalkulatzen du."
+msgid "<emph>Cumulative</emph> = 0 or False calculates the probability density function; <emph>Cumulative</emph> = 1, True, or any other value calculates the cumulative distribution function."
+msgstr ""
 
 #. Z7AS8
 #: 04060182.xhp
@@ -36313,14 +36268,14 @@ msgctxt ""
 msgid "<emph>NPopulation </emph>is the size of the total population."
 msgstr "<emph>NPopulazioa</emph>: populazio osoaren tamaina."
 
-#. oDuYV
+#. MDMvu
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id231585952506847\n"
 "help.text"
-msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter."
-msgstr "<emph>Metatua</emph> (aukerakoa) probabilitate-dentsitatearen funtzioa kalkulatuko den (FALSE edo 0) edo banaketa metatuaren funtzioa kalkulatuko den (beste edozein balio) zehazten du. Banaketa metatuaren funtzioa da lehenetsitakoa, parametro honetarako baliorik zehazten ez bada."
+msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability mass function (FALSE or 0) or the cumulative distribution function (any other value). The probability mass function is the default if no value is specified for this parameter."
+msgstr ""
 
 #. WUiB6
 #: 04060182.xhp
@@ -37222,32 +37177,32 @@ msgctxt ""
 msgid "LOGINV(Number [; Mean [; StDev]])"
 msgstr "LOGINV(Zenbakia [; BatezBestekoa [; StDev]])"
 
-#. uqfDA
+#. vDVWm
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id3148390\n"
 "help.text"
-msgid "<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated."
-msgstr "<emph>Zenbakia</emph>: alderantzizko banaketa estandar logaritmikoa kalkulatu behar zaion probabilitate-balioa."
+msgid "<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated."
+msgstr ""
 
-#. ZAEjF
+#. aJATB
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id3149538\n"
 "help.text"
-msgid "<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution."
-msgstr "<emph>BatezBestekoa</emph>: banaketa estandar logaritmikoaren batez besteko aritmetikoa."
+msgid "<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted)."
+msgstr ""
 
-#. RTG5n
+#. PDJWU
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id3145355\n"
 "help.text"
-msgid "<emph>StDev</emph> is the standard deviation of the standard logarithmic distribution."
-msgstr "<emph>StDev</emph>: banaketa estandar logaritmikoaren desbideratze estandarra."
+msgid "<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted)."
+msgstr ""
 
 #. Uh6oi
 #: 04060183.xhp
@@ -37294,14 +37249,14 @@ msgctxt ""
 msgid "This function is identical to LOGINV and was introduced for interoperability with other office suites."
 msgstr "Funtzio hau LOGINV funtzioaren berdina da eta beste bulegotika-pakete batzuekin elkarrerabilgarritasuna bermatzeko sartu zen."
 
-#. tLigG
+#. AivtF
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id2901049\n"
 "help.text"
-msgid "LOGNORM.INV(Number; Mean; StDev)"
-msgstr "LOGNORM.INV(Zenbakia; BatezBestekoa; StDev)"
+msgid "LOGNORM.INV(Number [; Mean [; StDev]])"
+msgstr ""
 
 #. p2y5k
 #: 04060183.xhp
@@ -37312,23 +37267,23 @@ msgctxt ""
 msgid "<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated."
 msgstr "<emph>Zenbakia</emph>: alderantzizko banaketa estandar logaritmikoa kalkulatu behar zaion probabilitate-balioa."
 
-#. sFACF
+#. ip7rm
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id2901538\n"
 "help.text"
-msgid "<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution."
-msgstr "<emph>BatezBestekoa</emph>: banaketa estandar logaritmikoaren batez besteko aritmetikoa."
+msgid "<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted)."
+msgstr ""
 
-#. PZ4w5
+#. pPM9C
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id2901355\n"
 "help.text"
-msgid "<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution."
-msgstr "<emph>StDev</emph> (aukerakoa): banaketa estandar logaritmikoaren desbideratze estandarra."
+msgid "<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted)."
+msgstr ""
 
 #. UYg6S
 #: 04060183.xhp
@@ -38842,14 +38797,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Poisson-en banaketa ematen du.</ahelp>"
 
-#. JHGHg
+#. nVnxU
 #: 04060184.xhp
 msgctxt ""
 "04060184.xhp\n"
 "par_id2946093\n"
 "help.text"
-msgid "POISSON.DIST(Number; Mean [; C])"
-msgstr "POISSON.DIST(Zenbakia; BatezBestekoa [; C])"
+msgid "POISSON.DIST(Number; Mean ; Cumulative)"
+msgstr ""
 
 #. jnjk7
 #: 04060184.xhp
@@ -38869,14 +38824,14 @@ msgctxt ""
 msgid "<emph>Mean</emph> represents the middle value of the Poisson distribution."
 msgstr "<emph>BatezBestekoa</emph>: Poisson-en banaketaren batez besteko balioa."
 
-#. fXReC
+#. MiQ2K
 #: 04060184.xhp
 msgctxt ""
 "04060184.xhp\n"
 "par_id2949200\n"
 "help.text"
-msgid "<emph>C</emph> (optional) = 0 or False calculates the density function; <emph>C</emph> = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME."
-msgstr "<emph>C</emph> (aukerakoa) = 0 edo Faltsua: dentsitate-funtzioa kalkulatzen du; <emph>C</emph> = 1 edo Egiazkoa: banaketa kalkulatzen du. Zehazten ez denean, Egiazkoa balio lehenetsia sartzen da dokumentua gordetzen duzunean, bateragarritasun hobea izateko beste programa batzuekin eta %PRODUCTNAME suitearen bertsio zaharragoekin."
+msgid "<emph>Cumulative</emph> = 0 or False to calculate the probability mass function; <emph>Cumulative</emph> = 1, True, or any other non-zero value to calculate the cumulative distribution function."
+msgstr ""
 
 #. gXFJQ
 #: 04060184.xhp
@@ -45439,14 +45394,14 @@ msgctxt ""
 msgid "<bookmark_value>Stylist, see Styles window</bookmark_value><bookmark_value>Styles window</bookmark_value><bookmark_value>formats; Styles window</bookmark_value><bookmark_value>formatting; Styles window</bookmark_value><bookmark_value>paint can for applying styles</bookmark_value><bookmark_value>styles in spreadsheets</bookmark_value><bookmark_value>styles; in Calc</bookmark_value>"
 msgstr ""
 
-#. WerNG
+#. eA3vo
 #: 05100000.xhp
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3150447\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles in Calc</link>"
-msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Estiloak Calc aplikazioan</link>"
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
+msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Estiloak</link>"
 
 #. bBG57
 #: 05100000.xhp
@@ -46283,7 +46238,7 @@ msgctxt ""
 "par_id991609782427459\n"
 "help.text"
 msgid "Data Bar"
-msgstr ""
+msgstr "Datu-barra"
 
 #. xapwr
 #: 05120000.xhp
@@ -46301,16 +46256,17 @@ msgctxt ""
 "par_id931609781970981\n"
 "help.text"
 msgid "The calculation of the area of fill is based on Min - Max - Percentile - Value - Percent - Formula."
-msgstr ""
+msgstr "Betegarriaren arearen kalkulua honetan oinarritzen da: 'Min' - 'Max' - 'Pertzentila' - 'Balioa' - 'Ehunekoa' - 'Formula'."
 
 #. smxFL
 #: 05120000.xhp
+#, fuzzy
 msgctxt ""
 "05120000.xhp\n"
 "par_id981609782003841\n"
 "help.text"
 msgid "The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula)."
-msgstr ""
+msgstr "'Min' eta 'Max' aukerak aski dira barrutian balioa aurkitzeko. Beste aukerak balio baten bidez ('Pertzentila', 'Balioa', 'Ehunekoa') edo gelaxka-erreferentzia edo formula baten bidez ('Formula') zehaztu behar dira."
 
 #. qBVjM
 #: 05120000.xhp
@@ -46319,7 +46275,7 @@ msgctxt ""
 "par_id281609781729359\n"
 "help.text"
 msgid "<emph>More Options...</emph> opens a dialog to:"
-msgstr ""
+msgstr "<emph>Aukera gehiago...</emph> aukerak elkarrizketa-koadro bat irekitzen du:"
 
 #. saDJA
 #: 05120000.xhp
@@ -46328,7 +46284,7 @@ msgctxt ""
 "par_id271609781812913\n"
 "help.text"
 msgid "change colors"
-msgstr ""
+msgstr "koloreak aldatzeko"
 
 #. uncF8
 #: 05120000.xhp
@@ -46337,7 +46293,7 @@ msgctxt ""
 "par_id921609781838551\n"
 "help.text"
 msgid "change position of vertical axis within the cell"
-msgstr ""
+msgstr "gelaxkaren barruko ardatz bertikalaren kokagunea aldatzeko"
 
 #. wJNxE
 #: 05120000.xhp
@@ -46346,7 +46302,7 @@ msgctxt ""
 "par_id631609781859971\n"
 "help.text"
 msgid "the bar's minimum and maximum length in percentage"
-msgstr ""
+msgstr "barraren gutxieneko eta gehieneko luzera ehunekoetan"
 
 #. de4nk
 #: 05120000.xhp
@@ -48022,14 +47978,14 @@ msgctxt ""
 msgid "Freeze Rows and Columns"
 msgstr "Finkatu errenkadak eta zutabeak"
 
-#. rBUcX
+#. nwRKF
 #: 07090000.xhp
 msgctxt ""
 "07090000.xhp\n"
 "hd_id3150517\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/07090000.xhp\" name=\"Freeze\">Freeze Rows and Columns</link>"
-msgstr "<link href=\"text/scalc/01/07090000.xhp\" name=\"Finkatu\">Finkatu</link>"
+msgid "<variable id=\"freezerowcolum\"><link href=\"text/scalc/01/07090000.xhp\" name=\"Freeze\">Freeze Rows and Columns</link></variable>"
+msgstr ""
 
 #. XjvVY
 #: 07090000.xhp
@@ -48040,6 +47996,42 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.</ahelp>"
 msgstr "<ahelp hid=\".\">Gelaxka aktiboaren goi-ezkerraldeko ertzean zatituko du orria, eta hortik aurrera goi-ezkerraldeko arean ezingo da korritu.</ahelp>"
 
+#. mBdCG
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Freeze Cells"
+msgstr ""
+
+#. U6FYG
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"bm_id821612315529410\n"
+"help.text"
+msgid "<bookmark_value>freezing;first row</bookmark_value>    <bookmark_value>freezing;first column</bookmark_value>    <bookmark_value>freezing;cells</bookmark_value>"
+msgstr ""
+
+#. tTzNC
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"hd_id961612313262512\n"
+"help.text"
+msgid "<variable id=\"freezecellsh1\"><link href=\"text/scalc/01/07090100.xhp\" name=\"Freeze Cells\">Freeze Cells</link></variable>"
+msgstr ""
+
+#. sWGWB
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"par_id481612313262514\n"
+"help.text"
+msgid "Freezes the first column or the first row of the current spreadsheet."
+msgstr ""
+
 #. ozNTG
 #: 12010000.xhp
 msgctxt ""
@@ -48587,16 +48579,17 @@ msgctxt ""
 "hd_id3146976\n"
 "help.text"
 msgid "Case sensitive"
-msgstr ""
+msgstr "Maiuskula/minuskula"
 
 #. CF7yB
 #: 12030200.xhp
+#, fuzzy
 msgctxt ""
 "12030200.xhp\n"
 "par_id3153091\n"
 "help.text"
 msgid "<ahelp hid=\"modules/scalc/ui/sortoptionspage/case\">Sorts first by uppercase letters and then by lowercase letters. For Asian languages, special handling applies.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"modules/scalc/ui/sortoptionspage/case\"> Lehendabizi maiuskulen arabera ordenatzen du eta ondoren minuskulen arabera. Hizkuntza asiarrentzat erabilera berezia aplikatzen da.</ahelp>"
 
 #. QbcU3
 #: 12030200.xhp
@@ -48605,7 +48598,7 @@ msgctxt ""
 "par_idN10637\n"
 "help.text"
 msgid "For Asian languages: Check <emph>Case Sensitive</emph> to apply multi-level collation. With multi-level collation, entries are first compared in their primitive forms with their cases and diacritics ignored. If they evaluate as the same, their diacritics are taken into account for the second-level comparison. If they still evaluate as the same, their cases, character widths, and Japanese Kana difference are considered for the third-level comparison."
-msgstr ""
+msgstr "Asiako hizkuntzetan, egiaztatu <emph>Maiuskula/minuskula</emph> maila anitzeko konparazioa erabiltzeko. Maila anitzeko konparazioan, sarreren maiuskula/minuskulei eta diakritikoei ez zaie jaramonik egiten, eta sarreren jatorrizko formak bakarrik konparatzen dira.  Ebaluazioaren arabera berdinak badira, diakritikoak kontuan hartuko zaizkie bigarren mailako konparazioan. Formak oraindik ere berdinak badira, formen maiuskulak eta minuskulak, karaktere-zabalera eta japonierako kana hartuko dira kontuan hirugarren mailako konparazioan."
 
 #. Z5MKw
 #: 12030200.xhp
@@ -48614,7 +48607,7 @@ msgctxt ""
 "hd_id3155856\n"
 "help.text"
 msgid "Range contains row/column labels"
-msgstr ""
+msgstr "Barrutiak errenkaden/zutabeen etiketak ditu"
 
 #. dHpeV
 #: 12030200.xhp
@@ -48668,7 +48661,7 @@ msgctxt ""
 "hd_id71610757096466\n"
 "help.text"
 msgid "Include boundary column(s)/row(s) containing only comments"
-msgstr ""
+msgstr "Sartu iruzkinak soilik ditu(zt)en muga-zutabea(k)/-errenkada(k)"
 
 #. AKcgf
 #: 12030200.xhp
@@ -48686,7 +48679,7 @@ msgctxt ""
 "hd_id161610757296697\n"
 "help.text"
 msgid "Include boundary column(s)/row(s) containing only images"
-msgstr ""
+msgstr "Sartu irudiak soilik ditu(zt)en muga-zutabea(k)/-errenkada(k)"
 
 #. QCvRo
 #: 12030200.xhp
@@ -48722,7 +48715,7 @@ msgctxt ""
 "hd_id3153418\n"
 "help.text"
 msgid "Sort results (named ranges list)"
-msgstr ""
+msgstr "Ordenatzearen emaitzak (izendun barrutien zerrenda)"
 
 #. JGhWC
 #: 12030200.xhp
@@ -48740,7 +48733,7 @@ msgctxt ""
 "hd_id3153707\n"
 "help.text"
 msgid "Sort results (input box)"
-msgstr ""
+msgstr "Ordenatzearen emaitzak (sarrera-koadroa)"
 
 #. BDJEH
 #: 12030200.xhp
@@ -48776,7 +48769,7 @@ msgctxt ""
 "hd_id3154704\n"
 "help.text"
 msgid "Custom sort order list"
-msgstr ""
+msgstr "Ordenatze-hurrenkeraren zerrenda pertsonalizatua"
 
 #. hQE6m
 #: 12030200.xhp
@@ -51701,7 +51694,7 @@ msgctxt ""
 "par_idN106F7\n"
 "help.text"
 msgid "<ahelp hid=\".\">Opens the <link href=\"text/scalc/01/12090106.xhp\">Data Field Options</link> dialog. The <emph>Options</emph> button is visible for filters and column or row fields only.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\"> <link href=\"text/scalc/01/12090106.xhp\">Datu-eremuen aukerak</link> elkarrizketa-koadroa irekitzen du. <emph>Aukerak</emph> botoia iragazkien eta zutabeen edo errenkaden eremuentzat soilik egongo da ikusgai.</ahelp>"
 
 #. pTDtv
 #: 12090105.xhp
@@ -52754,7 +52747,7 @@ msgctxt ""
 "par_id3147434\n"
 "help.text"
 msgid "Whole numbers"
-msgstr ""
+msgstr "Zenbaki osoak"
 
 #. dT2EE
 #: 12120100.xhp
@@ -52889,7 +52882,7 @@ msgctxt ""
 "par_id551607384650484\n"
 "help.text"
 msgid "Custom"
-msgstr ""
+msgstr "Pertsonalizatua"
 
 #. Eejrc
 #: 12120100.xhp
@@ -60947,32 +60940,32 @@ msgctxt ""
 msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
 msgstr "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
 
-#. nUeRH
+#. Dp4Sx
 #: func_minifs.xhp
 msgctxt ""
 "func_minifs.xhp\n"
 "par_id27619246864839\n"
 "help.text"
-msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65."
-msgstr "C2:C6 barrutian B2:B6 barrutiko balio guztiei dagozkien balioen minimoa kalkulatzen du, minimoa eta maximoa salbu. 65 ematen du."
+msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65."
+msgstr ""
 
-#. CnZcV
+#. 7S443
 #: func_minifs.xhp
 msgctxt ""
 "func_minifs.xhp\n"
 "par_id220502883332563\n"
 "help.text"
-msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>"
-msgstr "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*liburu\";B2:B6;\"<=\"&MAX(B2:B6))</item>"
+msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>"
+msgstr ""
 
-#. sGnvo
+#. gNhzJ
 #: func_minifs.xhp
 msgctxt ""
 "func_minifs.xhp\n"
 "par_id15342189586295\n"
 "help.text"
-msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180."
-msgstr "C2:C6 barrutiko balioen batuketa kalkulatzen du, \"pen\" katearekin hasten diren A2:A6 barrutiko gelaxkekin eta B2:B6 barrutiko gelaxka guztiekin (minimoa salbu) bat datozen balioak soilik hartuta. 180 ematen du."
+msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190."
+msgstr ""
 
 #. uz4wr
 #: func_minifs.xhp
@@ -62801,41 +62794,23 @@ msgctxt ""
 msgid "The parameters should specify at least three values."
 msgstr "Parametroek gutxienez hiru balio zehaztu behar dituzte."
 
-#. W8hYu
+#. Q2i35
 #: func_skewp.xhp
 msgctxt ""
 "func_skewp.xhp\n"
 "par_id1102201617001888\n"
 "help.text"
-msgid "<item type=\"literal\">SKEWP(2;3;1;6;8;5)</item> returns 0.2828158928"
-msgstr "<item type=\"literal\">SKEWP(2;3;1;6;8;5)</item> funtzioak ematen du 0.2828158928"
+msgid "<input>SKEWP(2;3;1;6;8;5)</input> returns 0.2329985562"
+msgstr ""
 
-#. 63DiS
+#. TAGzC
 #: func_skewp.xhp
 msgctxt ""
 "func_skewp.xhp\n"
 "par_id1102201618185378\n"
 "help.text"
-msgid "<item type=\"literal\">SKEWP(A1:A6)</item> returns 0.2828158928, when the range A1:A6 contains {2;3;1;6;8;5}"
-msgstr "<item type=\"literal\">SKEWP(A1:A6)</item> 0,2828158928 ematen du, A1:A6 barrutiak {2;3;1;6;8;5} duenean"
-
-#. Tdd33
-#: func_skewp.xhp
-msgctxt ""
-"func_skewp.xhp\n"
-"par_id1102201618185326\n"
-"help.text"
-msgid "<item type=\"literal\">SKEWP(Number1; Number2)</item> always returns zero, if Number1 and Number2 results in two numbers."
-msgstr "<item type=\"literal\">SKEWP(Zenbakia1; Zenbakia2)</item>: Beti zero ematen du, Zenbakia1 eta Zenbakia2 parametroek bi zenbaki ematen badituzte."
-
-#. X6nGR
-#: func_skewp.xhp
-msgctxt ""
-"func_skewp.xhp\n"
-"par_id1102201618188326\n"
-"help.text"
-msgid "<item type=\"literal\">SKEWP(Number1)</item> returns Err:502 (Invalid argument) if Number1 results in one number, because SKEWP cannot be calculated with one value."
-msgstr "<item type=\"literal\">SKEWP(Zenbakia1)</item>: Err:502 (baliogabeko argumentua) ematen du Zenbakia1 parametroak zenbaki bat ematen badu, SKEWP ezin baita balio batekin kalkulatu."
+msgid "<input>SKEWP(A1:A6)</input> returns 0.2329985562, when the range A1:A6 contains {2;3;1;6;8;5}"
+msgstr ""
 
 #. 5iYyJ
 #: func_skewp.xhp
@@ -68524,7 +68499,7 @@ msgctxt ""
 "par_id1003100\n"
 "help.text"
 msgid "Variance of the Differences"
-msgstr ""
+msgstr "Diferentzien bariantza"
 
 #. CFBrp
 #: statistics_test_t.xhp
@@ -68533,7 +68508,7 @@ msgctxt ""
 "par_id1003120\n"
 "help.text"
 msgid "df"
-msgstr ""
+msgstr "df"
 
 #. mAixM
 #: statistics_test_t.xhp
@@ -68542,7 +68517,7 @@ msgctxt ""
 "par_id1003140\n"
 "help.text"
 msgid "t Stat"
-msgstr ""
+msgstr "t estatistika"
 
 #. utcA9
 #: statistics_test_t.xhp
@@ -68551,7 +68526,7 @@ msgctxt ""
 "par_id1003160\n"
 "help.text"
 msgid "P (T<=t) one-tail"
-msgstr ""
+msgstr "P (T<=t) ilara bakarra"
 
 #. 7mezL
 #: statistics_test_t.xhp
@@ -68569,7 +68544,7 @@ msgctxt ""
 "par_id1003200\n"
 "help.text"
 msgid "P (T<=t) two-tail"
-msgstr ""
+msgstr "P (T<=t) bi ilarakoa"
 
 #. kh5E7
 #: statistics_test_t.xhp
@@ -68578,7 +68553,7 @@ msgctxt ""
 "par_id1003220\n"
 "help.text"
 msgid "t Critical two-tail"
-msgstr ""
+msgstr "t bi ilara kritiko"
 
 #. QA9fL
 #: statistics_test_z.xhp
@@ -68641,7 +68616,7 @@ msgctxt ""
 "hd_id1000220\n"
 "help.text"
 msgid "Data"
-msgstr ""
+msgstr "Datuak"
 
 #. G5qUC
 #: statistics_test_z.xhp