diff options
Diffstat (limited to 'source/eu/helpcontent2/source/text/scalc')
| -rw-r--r-- | source/eu/helpcontent2/source/text/scalc/00.po | 10 | ||||
| -rw-r--r-- | source/eu/helpcontent2/source/text/scalc/01.po | 1116 | ||||
| -rw-r--r-- | source/eu/helpcontent2/source/text/scalc/04.po | 161 | ||||
| -rw-r--r-- | source/eu/helpcontent2/source/text/scalc/06.po | 5 | ||||
| -rw-r--r-- | source/eu/helpcontent2/source/text/scalc/guide.po | 581 |
5 files changed, 1324 insertions, 549 deletions
diff --git a/source/eu/helpcontent2/source/text/scalc/00.po b/source/eu/helpcontent2/source/text/scalc/00.po index bda7f246593..cc814852bc1 100644 --- a/source/eu/helpcontent2/source/text/scalc/00.po +++ b/source/eu/helpcontent2/source/text/scalc/00.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2021-06-24 12:51+0200\n" +"POT-Creation-Date: 2021-09-10 23:11+0200\n" "PO-Revision-Date: 2021-06-26 11:04+0000\n" "Last-Translator: Asier Sarasua Garmendia <asiersar@yahoo.com>\n" "Language-Team: Basque <https://translations.documentfoundation.org/projects/libo_help-master/textscalc00/eu/>\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=n != 1;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Weblate 4.6.2\n" +"X-Generator: LibreOffice\n" "X-POOTLE-MTIME: 1556007652.000000\n" #. E9tti @@ -961,14 +961,14 @@ msgctxt "" msgid "Choose <emph>Tools - Detective - Trace Precedents</emph>." msgstr "Aukeratu <emph>Tresnak - Detektibea - Aurrekoen aztarnari jarraitu</emph>." -#. iGnP6 +#. q3pmU #: 00000406.xhp msgctxt "" "00000406.xhp\n" "par_id3150447\n" "help.text" -msgid "Shift+F7" -msgstr "⇧+F7" +msgid "Shift+F9" +msgstr "" #. Mn26m #: 00000406.xhp diff --git a/source/eu/helpcontent2/source/text/scalc/01.po b/source/eu/helpcontent2/source/text/scalc/01.po index 31d883f95f7..e0d17c4f8bb 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-06-24 12:51+0200\n" -"PO-Revision-Date: 2021-08-08 17:10+0000\n" +"POT-Creation-Date: 2021-09-14 12:00+0200\n" +"PO-Revision-Date: 2021-09-12 07: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" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=n != 1;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Weblate 4.6.2\n" +"X-Generator: LibreOffice\n" "X-POOTLE-MTIME: 1563601210.000000\n" #. sZfWF @@ -115,14 +115,14 @@ msgctxt "" msgid "<link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link>" msgstr "<link href=\"text/scalc/01/02110000.xhp\" name=\"Nabigatzailea\">Nabigatzailea</link>" -#. CJKL2 +#. RJGLF #: 02110000.xhp msgctxt "" "02110000.xhp\n" "par_id3156422\n" "help.text" -msgid "<ahelp hid=\".uno:Navigator\">Activates and deactivates the Navigator.</ahelp> The Navigator is a <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link>." -msgstr "<ahelp hid=\".uno:Navigator\">'Nabigatzailea' aktibatzen eta desaktibatzen du.</ahelp> 'Nabigatzailea' <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"leiho atrakagarria\">leiho atrakagarria</link> da." +msgid "<ahelp hid=\".uno:Navigator\">Activates and deactivates the Navigator.</ahelp> The Navigator is a <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">dockable window</link>." +msgstr "<ahelp hid=\".uno:Navigator\">Nabigatzailea aktibatzen eta desaktibatzen du.</ahelp> Nabigatzailea <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">leiho atrakagarria</link> da." #. tDkHa #: 02110000.xhp @@ -20140,6 +20140,78 @@ msgctxt "" msgid "<variable id=\"texttext\">This section contains descriptions of the <emph>Text</emph> functions. </variable>" msgstr "<variable id=\"texttext\">Atal honek <emph>Testua</emph> funtzioen deskribapenak ditu.</variable>" +#. bF46G +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"bm_id331624453577057\n" +"help.text" +msgid "<bookmark_value>using double quotation marks in formulas</bookmark_value> <bookmark_value>formulas; using double quotation marks</bookmark_value>" +msgstr "" + +#. XXyWj +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id291624454173529\n" +"help.text" +msgid "Using double quotation marks in formulas" +msgstr "" + +#. aGDFQ +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id891624454058773\n" +"help.text" +msgid "To include a text string in a formula, place the text string between two double quotation marks (\") and Calc takes the characters in the string without attempting to interpret them. For example, the formula <input>=\"Hello world!\"</input> displays the text string <literal>Hello world!</literal> in the cell, with no surrounding double quotation marks." +msgstr "" + +#. HCwEU +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id461624454425320\n" +"help.text" +msgid "The more complex formula <input>=CONCATENATE(\"Life is really simple, \"; \"but we insist on making it complicated \"; \"(Confucius).\")</input> concatenates three individual strings in double quotation marks, outputting <literal>Life is really simple, but we insist on making it complicated (Confucius).</literal>" +msgstr "" + +#. XBDt9 +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id711624454477483\n" +"help.text" +msgid "To place a literal double quotation mark within a string inside a formula, two methods can be used:" +msgstr "" + +#. 8qFEv +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id541624454496424\n" +"help.text" +msgid "You can \"escape\" the double quotation mark with an additional double quotation mark, and Calc treats the escaped double quotation mark as a literal value. For example, the formula <input>=\"My name is \"\"John Doe\"\".\"</input> outputs the string <literal>My name is \"John Doe\".</literal> Another simple example is the formula <input>=UNICODE(\"\"\"\")</input> which returns <literal>34</literal>, the decimal value of the Unicode quotation mark character (U+0022) — here the first and fourth double quotation marks indicate the beginning and end of the string, while the second double quotation mark escapes the third." +msgstr "" + +#. MfLZn +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id21624454513641\n" +"help.text" +msgid "You can use the CHAR function or the UNICHAR function to insert a double quotation mark. For example, the formula <input>=UNICHAR(34) & \"The Catcher in the Rye\" & UNICHAR(34) & \" is a famous book by J. D. Salinger.\"</input> displays the string <literal>\"The Catcher in the Rye\" is a famous book by J. D. Salinger.</literal>" +msgstr "" + +#. cpK3Z +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id401624454547945\n" +"help.text" +msgid "Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature." +msgstr "" + #. Gmvo8 #: 04060110.xhp msgctxt "" @@ -20338,14 +20410,14 @@ msgctxt "" msgid "BASE" msgstr "BASE" -#. QtLKF +#. znNLx #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3153289\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"numbering system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used." -msgstr "<ahelp hid=\"HID_FUNC_BASIS\">Osoko zenbaki positibo bat beste<link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"zenbaki-sistema\">zenbaki-sistema</link> bateko testu bihurtzen du, adierazitako oinarriaren arabera.</ahelp> 0-9 zenbakiak eta A-Z letrak erabiliko dira." +msgid "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#number_system\" name=\"numbering system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used." +msgstr "" #. 2cDvi #: 04060110.xhp @@ -20689,14 +20761,14 @@ msgctxt "" msgid "DECIMAL" msgstr "DECIMAL" -#. CeS5L +#. BcCUk #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3156361\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_DEZIMAL\">Converts text with characters from a <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"number system\">number system</link> to a positive integer in the base radix given.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs are ignored. The <emph>Text</emph> field is not case-sensitive." -msgstr "<ahelp hid=\"HID_FUNC_DEZIMAL\"><link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"zenbaki-sistema\">Zenbaki-sistema</link> bateko testua osoko zenbaki positibo bihurtzen du, oinarri gisa ezarritako erroaren arabera.</ahelp> Erroak 2 eta 36 bitartekoa izan behar du. Zuriuneei eta tabulazioei ez ikusi egingo zaie. <emph>Testua</emph> eremuak ez ditu maiuskulak eta minuskulak bereizten." +msgid "<ahelp hid=\"HID_FUNC_DEZIMAL\">Converts text with characters from a <link href=\"text/shared/00/00000005.xhp#number_system\" name=\"number system\">number system</link> to a positive integer in the base radix given.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs are ignored. The <emph>Text</emph> field is not case-sensitive." +msgstr "" #. 5yN72 #: 04060110.xhp @@ -21274,50 +21346,50 @@ msgctxt "" msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned." msgstr "<emph>Byte_kopurua</emph> (aukerakoa): LEFTB funtzioak aterako dituen karaktere kopurua zehazten du. Parametro hau definitzen ez bada, karaktere bat emango du funtzioak." -#. TFXGD +#. FFvts #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949141\n" "help.text" -msgid "<item type=\"input\">LEFTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)." -msgstr "<item type=\"input\">LEFTB(\"中国\";1)</item>: \" \" ematen du (byte 1 DBCS karaktere baten erdia da eta, hori dela eta, zuriune-karaktere bat itzultzen da)." +msgid "<item type=\"input\">=LEFTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)." +msgstr "" -#. QwisG +#. mQvUN #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949151\n" "help.text" -msgid "<item type=\"input\">LEFTB(\"中国\";2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)." -msgstr "<item type=\"input\">LEFTB(\"中国\";2)</item>: \"中\" ematen du (2 bytek DBCS karaktere oso bat osatzen dute)." +msgid "<item type=\"input\">=LEFTB(\"中国\";2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)." +msgstr "" -#. SDFHG +#. qAEZ3 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949161\n" "help.text" -msgid "<item type=\"input\">LEFTB(\"中国\";3)</item> returns \"中 \" (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character)." -msgstr "<item type=\"input\">LEFTB(\"中国\";3)</item>: \"中 \" ematen du (3 bytek DBCS karaktere bat eta erdi osatzen dute; itzulitako azken karakterea zuriune bat izango da)." +msgid "<item type=\"input\">=LEFTB(\"中国\";3)</item> returns \"中 \" (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character)." +msgstr "" -#. 26C2F +#. s3UVQ #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949171\n" "help.text" -msgid "<item type=\"input\">LEFTB(\"中国\";4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." -msgstr "<item type=\"input\">LEFTB(\"中国\";4)</item>: \"中国\" ematen du (4 bytek bi DBCS karaktere oso egiten dute)." +msgid "<item type=\"input\">=LEFTB(\"中国\";4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." +msgstr "" -#. 8AtC5 +#. FM3FS #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949181\n" "help.text" -msgid "<item type=\"input\">LEFTB(\"office\";3)</item> returns \"off\" (3 non-DBCS characters each consisting of 1 byte)." -msgstr "<item type=\"input\">LEFTB(\"office\";3)</item>: \"off\" ematen du (DBCS ez diren 3 karaktere, bakoitza 1 bytekoa)." +msgid "<item type=\"input\">=LEFTB(\"office\";3)</item> returns \"off\" (3 non-DBCS characters each consisting of 1 byte)." +msgstr "" #. eEgeD #: 04060110.xhp @@ -21661,104 +21733,104 @@ msgctxt "" msgid "<emph>Number_bytes</emph> specifies the number of characters MIDB will return from text, in bytes." msgstr "<emph>Byte_kopurua</emph>: MIDBk testutik emango duen karaktere kopurua, bytetan, zehazten du." -#. YrAwV +#. 5Nn2i #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958417\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";1;0)</item> returns \"\" (0 bytes is always an empty string)." -msgstr "<item type=\"input\">MIDB(\"中国\";1;0)</item>: \"\" ematen du (0 byte kate huts bat da beti)." +msgid "<item type=\"input\">=MIDB(\"中国\";1;0)</item> returns \"\" (0 bytes is always an empty string)." +msgstr "" -#. vSWbG +#. q6dWL #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958427\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";1;1)</item> returns \" \" (1 byte is only half a DBCS character and therefore the result is a space character)." -msgstr "<item type=\"input\">MIDB(\"中国\";1;1)</item>: \" \" ematen du (byte 1 DBCS karaktere baten erdia da eta, hori dela eta, zuriune-karaktere bat itzultzen da)." +msgid "<item type=\"input\">=MIDB(\"中国\";1;1)</item> returns \" \" (1 byte is only half a DBCS character and therefore the result is a space character)." +msgstr "" -#. TLFgD +#. CfNES #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958437\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";1;2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)." -msgstr "<item type=\"input\">MIDB(\"中国\";1;2)</item>: \"中\" ematen du (2 bytek DBCS karaktere oso bat osatzen dute)." +msgid "<item type=\"input\">=MIDB(\"中国\";1;2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)." +msgstr "" -#. BPauw +#. wBLqC #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958447\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";1;3)</item> returns \"中 \" (3 bytes constitute one and a half DBCS character; the last byte results in a space character)." -msgstr "<item type=\"input\">MIDB(\"中国\";1;3)</item>: \"中 \" ematen du (3 byte DBCS karaktere bat eta erdi dira; azken byteak zuriune bat itzultzen du)." +msgid "<item type=\"input\">=MIDB(\"中国\";1;3)</item> returns \"中 \" (3 bytes constitute one and a half DBCS character; the last byte results in a space character)." +msgstr "" -#. PwTEe +#. GedmG #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958457\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";1;4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." -msgstr "<item type=\"input\">MIDB(\"中国\";1;4)</item>: \"中国\" ematen du (4 bytek bi DBCS karaktere oso egiten dute)." +msgid "<item type=\"input\">=MIDB(\"中国\";1;4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." +msgstr "" -#. Yb4iF +#. dAMAA #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958467\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";2;1)</item> returns \" \" (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned)." -msgstr "<item type=\"input\">MIDB(\"中国\";2;1)</item>: \" \" ematen du (2 byte-kokagunea ez dago karaktere baten hasieran DBCS kate batean; zuriune bat itzultzen da)." +msgid "<item type=\"input\">=MIDB(\"中国\";2;1)</item> returns \" \" (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned)." +msgstr "" -#. DyXxB +#. SXLij #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958477\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";2;2)</item> returns \" \" (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned)." -msgstr "<item type=\"input\">MIDB(\"中国\";2;2)</item>: \" \" ematen du (2 byte-kokaguneak DBCS kateko lehen karakterearen azken erdira apuntatzen du; eskatutako 2 byte-ak, beraz, lehen karakterearen azken erdia eta bigarren karakterearen lehen erdia dira; beraz, 2 zuriune-karaktere itzultzen dira)." +msgid "<item type=\"input\">=MIDB(\"中国\";2;2)</item> returns \" \" (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned)." +msgstr "" -#. WA6xA +#. cFw7V #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958487\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";2;3)</item> returns \" 国\" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2)." -msgstr "<item type=\"input\">MIDB(\"中国\";2;3)</item>: \" 国\" ematen du (2 byte-kokagunea ez dago karaktere baten hasieran DBCS kate batean; zuriune bat itzultzen da 2 byte-kokagunerako)." +msgid "<item type=\"input\">=MIDB(\"中国\";2;3)</item> returns \" 国\" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2)." +msgstr "" -#. riZ7z +#. drtpL #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958497\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";3;1)</item> returns \" \" (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead)." -msgstr "<item type=\"input\">MIDB(\"中国\";3;1)</item>: \" \" ematen du (3 byte-kokagunea DBCS kate bateko karaktere baten hasieran dago, baina byte 1 DBCS karaktere baten erdia besterik ez da, eta beraz, zuriune-karaktere bat itzultzen da)." +msgid "<item type=\"input\">=MIDB(\"中国\";3;1)</item> returns \" \" (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead)." +msgstr "" -#. KeBuT +#. koipq #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958507\n" "help.text" -msgid "<item type=\"input\">MIDB(\"中国\";3;2)</item> returns \"国\" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character)." -msgstr "<item type=\"input\">MIDB(\"中国\";3;2)</item>: \"国\" ematen du (3 byte-kokagunea DBCS kate bateko karaktere baten hasieran dago, eta 2 byte-k DBCS karaktere bat osatzen dute)." +msgid "<item type=\"input\">=MIDB(\"中国\";3;2)</item> returns \"国\" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character)." +msgstr "" -#. CmwD5 +#. aQmsH #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2958517\n" "help.text" -msgid "<item type=\"input\">MIDB(\"office\";2;3)</item> returns \"ffi\" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters)." -msgstr "<item type=\"input\">MIDB(\"office\";2;3)</item>: \"ffi\" ematen du (2 byte-kokagunea DBCS ez den kate bateko karaktere baten hasieran dago, eta 3 byte, DBCS ez den kate batean, 3 karaktere dira)." +msgid "<item type=\"input\">=MIDB(\"office\";2;3)</item> returns \"ffi\" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters)." +msgstr "" #. k4kCo #: 04060110.xhp @@ -21958,23 +22030,23 @@ msgctxt "" msgid "<emph>Number</emph> is the number of repetitions." msgstr "<emph>Kopurua</emph>: errepikapenen kopurua." -#. x3LR5 +#. brnbx #: 04060110.xhp msgctxt "" "04060110.xhp\n" -"par_id3149922\n" +"par_id3148626\n" "help.text" -msgid "The result can be a maximum of 255 characters." -msgstr "Emaitza 255 karakterekoa izango da gehienez." +msgid "<item type=\"input\">=REPT(\"Good morning\";2)</item> returns Good morningGood morning." +msgstr "<item type=\"input\">=REPT(\"Egun on\";2)</item>: Egun onEgun on ematen du." -#. brnbx +#. 9Dbjv #: 04060110.xhp msgctxt "" "04060110.xhp\n" -"par_id3148626\n" +"par_id381626381556310\n" "help.text" -msgid "<item type=\"input\">=REPT(\"Good morning\";2)</item> returns Good morningGood morning." -msgstr "<item type=\"input\">=REPT(\"Egun on\";2)</item>: Egun onEgun on ematen du." +msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT\" name=\"REPT_Wiki\">REPT</link> wiki page for more details about this function." +msgstr "" #. mtFNA #: 04060110.xhp @@ -22021,14 +22093,14 @@ msgctxt "" msgid "<emph>Text</emph> is the text of which the right part is to be determined." msgstr "<emph>Testua</emph>: eskuineko zatia zehaztu behar zaion testua." -#. KRpFB +#. tkbjJ #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3153350\n" "help.text" -msgid "<emph>Number</emph> (optional) is the number of characters from the right part of the text." -msgstr "<emph>Kopurua</emph> (aukerakoa): testuaren eskuineko zatiko karaktere kopurua." +msgid "<emph>Number</emph> (optional) is the number of characters from the right part of the text. If this parameter is not defined, one character is returned." +msgstr "" #. xNFMc #: 04060110.xhp @@ -22084,14 +22156,14 @@ msgctxt "" msgid "<emph>Text</emph> is the text of which the right part is to be determined." msgstr "<emph>Testua</emph>: eskuineko zatia zehaztu behar zaion testua." -#. Vciv6 +#. yUHYp #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2953350\n" "help.text" -msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes." -msgstr "<emph>Byte_kopurua</emph> (aukerakoa): RIGHTB funtzioak erauziko duen karaktere kopurua zehazten du, bytetan oinarrituta." +msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes. If this parameter is not defined, one byte is returned." +msgstr "" #. KnAgN #: 04060110.xhp @@ -22777,60 +22849,6 @@ msgctxt "" msgid "<item type=\"input\">=UPPER(\"Good Morning\")</item> returns GOOD MORNING." msgstr "<item type=\"input\">=UPPER(\"Egun on\")</item>: EGUN ON ematen du." -#. KWdkk -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"bm_id3150802\n" -"help.text" -msgid "<bookmark_value>VALUE function</bookmark_value>" -msgstr "<bookmark_value>VALUE funtzioa</bookmark_value>" - -#. QPiD6 -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"hd_id3150802\n" -"help.text" -msgid "VALUE" -msgstr "VALUE" - -#. yFFSn -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3152551\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_WERT\">Converts a text string into a number.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_WERT\">Testu-kate bat zenbaki bihurtzen du.</ahelp>" - -#. fGm5h -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3153638\n" -"help.text" -msgid "VALUE(\"Text\")" -msgstr "DATEVALUE(\"Testua\")" - -#. iYHvi -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3153651\n" -"help.text" -msgid "<emph>Text</emph> is the text to be converted to a number." -msgstr "<emph>Testua</emph>: zenbaki bihurtu beharreko testua." - -#. mDpCa -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3144733\n" -"help.text" -msgid "<item type=\"input\">=VALUE(\"4321\")</item> returns 4321." -msgstr "<item type=\"input\">=VALUE(\"4321\")</item>: 4321 ematen du." - #. E5UtK #: 04060111.xhp msgctxt "" @@ -23164,6 +23182,24 @@ msgctxt "" msgid "<emph>Text</emph> is the character string to be encrypted. ROT13(ROT13(Text)) decrypts the code." msgstr "<emph>Testua</emph>: Sartu zifratu nahi duzun karaktere-katea. ROT13(ROT13(testua)) funtzioak kodea deszifratzen du." +#. tN74B +#: 04060111.xhp +msgctxt "" +"04060111.xhp\n" +"par_id151626469224135\n" +"help.text" +msgid "<input>=ROT13(\"Gur Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.\")</input> returns the string \"The Document Foundation was founded in September 2010.\". Notice how spaces, digits, and full stops are unaffected by ROT13." +msgstr "" + +#. 4TMAT +#: 04060111.xhp +msgctxt "" +"04060111.xhp\n" +"par_id221626469509161\n" +"help.text" +msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13\" name=\"ROT13_Wiki\">ROT13</link> wiki page for more details about this function." +msgstr "" + #. CFJsA #: 04060111.xhp msgctxt "" @@ -38320,59 +38356,68 @@ msgctxt "" msgid "PHI" msgstr "PHI" -#. BiQu7 +#. YyypL #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3150254\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_PHI\">Returns the values of the distribution function for a standard normal distribution.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_PHI\">Banaketa normal estandarraren banaketa-funtzioaren balioak ematen ditu.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_PHI\">Returns the value of the probability density function for a given value considering the standard normal distribution.</ahelp>" +msgstr "" -#. HEuJD +#. oEGwC #: 04060184.xhp msgctxt "" "04060184.xhp\n" -"par_id3149976\n" +"par_id151629986285891\n" "help.text" -msgid "PHI(Number)" -msgstr "PHI(zenbakia)" +msgid "<input>PHI(Number)</input>" +msgstr "" -#. vZds8 +#. 4JwEu #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3156108\n" "help.text" -msgid "<emph>Number</emph> represents the value based on which the standard normal distribution is calculated." -msgstr "<emph>Zenbakia</emph>: banaketa normal estandarra kalkulatzeko erabiliko den balioa." +msgid "<emph>Number</emph> is the value for which the probability density function is calculated." +msgstr "" -#. jVwEp +#. 92hiK #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3155849\n" "help.text" -msgid "<item type=\"input\">=PHI(2.25) </item>= 0.03" -msgstr "<item type=\"input\">=PHI(2,25) </item>= 0,03" +msgid "<input>=PHI(2.25)</input> returns 0.0317." +msgstr "" -#. SsB5N +#. NsLhE #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3143236\n" "help.text" -msgid "<item type=\"input\">=PHI(-2.25)</item> = 0.03" -msgstr "<item type=\"input\">=PHI(-2,25)</item> = 0,03" +msgid "<input>=PHI(-2.25)</input> also returns 0.0317 because the normal distribution is symmetrical." +msgstr "" -#. UnjEG +#. NXho4 #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3149286\n" "help.text" -msgid "<item type=\"input\">=PHI(0)</item> = 0.4" -msgstr "<item type=\"input\">=PHI(0)</item> = 0,4" +msgid "<input>=PHI(0)</input> returns 0.3989." +msgstr "" + +#. GMDrd +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id611629985664328\n" +"help.text" +msgid "Calling <input>PHI(Number)</input> is equivalent to calling <input>NORMDIST(Number,0,1,FALSE())</input> or <input>NORM.S.DIST(Number;FALSE())</input>, hence using the standard normal distribution with mean equal to 0 and standard deviation equal to 1 with the <emph>Cumulative</emph> argument set to <emph>False.</emph>" +msgstr "" #. vqBTN #: 04060184.xhp @@ -41947,15 +41992,6 @@ msgctxt "" msgid "Addition" msgstr "Batuketa" -#. vVWxJ -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3153247\n" -"help.text" -msgid "1+1" -msgstr "1+1" - #. r74qM #: 04060199.xhp msgctxt "" @@ -41974,15 +42010,6 @@ msgctxt "" msgid "Subtraction" msgstr "Kenketa" -#. tZXmq -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3153554\n" -"help.text" -msgid "2-1" -msgstr "2-1" - #. zqeEq #: 04060199.xhp msgctxt "" @@ -42001,15 +42028,6 @@ msgctxt "" msgid "Negation" msgstr "Ukapena" -#. xRAoR -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3154712\n" -"help.text" -msgid "-5" -msgstr "-5" - #. uTzKJ #: 04060199.xhp msgctxt "" @@ -42028,15 +42046,6 @@ msgctxt "" msgid "Multiplication" msgstr "Biderketa" -#. p7EVk -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3149055\n" -"help.text" -msgid "2*2" -msgstr "2*2" - #. LyrLq #: 04060199.xhp msgctxt "" @@ -42055,15 +42064,6 @@ msgctxt "" msgid "Division" msgstr "Zatiketa" -#. Mm2KC -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3153027\n" -"help.text" -msgid "9/3" -msgstr "9/3" - #. St2pE #: 04060199.xhp msgctxt "" @@ -42082,15 +42082,6 @@ msgctxt "" msgid "Percent" msgstr "Ehunekoa" -#. 6tQYS -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3145632\n" -"help.text" -msgid "15%" -msgstr "15%" - #. KTLME #: 04060199.xhp msgctxt "" @@ -42109,14 +42100,14 @@ msgctxt "" msgid "Exponentiation" msgstr "Berretura" -#. G8KSc +#. QZRSe #: 04060199.xhp msgctxt "" "04060199.xhp\n" -"par_id3157873\n" +"par_id881623862728559\n" "help.text" -msgid "3^2" -msgstr "3^2" +msgid "Prefix \"-\" (negation) has a higher precedence than \"^\" (exponentiation). For example -3^2 equals 9, which is the square of a negative number." +msgstr "" #. 77TDi #: 04060199.xhp @@ -42181,15 +42172,6 @@ msgctxt "" msgid "Equal" msgstr "Berdin" -#. uSFf9 -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3154546\n" -"help.text" -msgid "A1=B1" -msgstr "A1=B1" - #. Vg88D #: 04060199.xhp msgctxt "" @@ -42208,15 +42190,6 @@ msgctxt "" msgid "Greater than" msgstr "Hau baino handiagoa da" -#. Q4HZQ -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3145138\n" -"help.text" -msgid "A1>B1" -msgstr "A1>B1" - #. jCt4x #: 04060199.xhp msgctxt "" @@ -42235,15 +42208,6 @@ msgctxt "" msgid "Less than" msgstr "Hau baino txikiagoa da" -#. zHDAx -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3150901\n" -"help.text" -msgid "A1<B1" -msgstr "A1<B1" - #. EBajC #: 04060199.xhp msgctxt "" @@ -42262,15 +42226,6 @@ msgctxt "" msgid "Greater than or equal to" msgstr "Hau baino handiagoa edo berdina da" -#. iopG3 -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3153111\n" -"help.text" -msgid "A1>=B1" -msgstr "A1>=B1" - #. wXVvo #: 04060199.xhp msgctxt "" @@ -42289,15 +42244,6 @@ msgctxt "" msgid "Less than or equal to" msgstr "Hau baino txikiagoa edo berdina da" -#. DjB2C -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3148760\n" -"help.text" -msgid "A1<=B1" -msgstr "A1<=B1" - #. 4XUDV #: 04060199.xhp msgctxt "" @@ -42316,15 +42262,6 @@ msgctxt "" msgid "Inequality" msgstr "Desberdintza" -#. NEJpk -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3149878\n" -"help.text" -msgid "A1<>B1" -msgstr "A1<>B1" - #. aAdxC #: 04060199.xhp msgctxt "" @@ -42478,15 +42415,6 @@ msgctxt "" msgid "Range" msgstr "Barrutia" -#. DCYDo -#: 04060199.xhp -msgctxt "" -"04060199.xhp\n" -"par_id3148432\n" -"help.text" -msgid "A1:C108" -msgstr "A1:C108." - #. fWnpm #: 04060199.xhp msgctxt "" @@ -43279,14 +43207,14 @@ msgctxt "" msgid "<variable id=\"function_list_text\"><ahelp hid=\"HID_SC_FUNCTIONLIST\">Opens the Function List deck of the Sidebar, which displays all functions that can be inserted into your document.</ahelp></variable> The <emph>Function List</emph> deck is similar to the <emph>Functions</emph> tab page of the <link href=\"text/scalc/01/04060000.xhp\" name=\"Function Wizard\">Function Wizard</link>. The functions are inserted with placeholders to be replaced with your own values." msgstr "<variable id=\"function_list_text\"><ahelp hid=\"HID_SC_FUNCTIONLIST\">Komando honek alboko barrako 'Funtzio-zerrenda' panela irekitzen du, dokumentuetan txerta ditzakezun funtzio guztiak erakusteko.</ahelp></variable> <emph>Funtzio-zerrenda</emph> panela <emph>Funtzioak</emph> fitxaren antzekoa da, <link href=\"text/scalc/01/04060000.xhp\" name=\"Funtzioen morroia\">Funtzioen morroi</link>koa. Funtzioak leku-markekin txertatzen dira, gero zure balioekin ordezteko." -#. UGvDB +#. kJGdD #: 04080000.xhp msgctxt "" "04080000.xhp\n" "par_id3152576\n" "help.text" -msgid "The <emph>Function List</emph> window is a resizable <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link>. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters." -msgstr "<emph>Funtzio-zerrenda</emph> leihoa tamainaz alda daitekeen <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">leiho atrakagarria</link> da. Kalkulu-orrietan funtzioak azkar sartzeko erabiltzen da. Funtzio-zerrendako sarrera batean klik bikoitza egitean, funtzio hori zuzenean txertatuko da parametro guztiekin." +msgid "The <emph>Function List</emph> window is a resizable <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">dockable window</link>. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters." +msgstr "" #. tu2NZ #: 04080000.xhp @@ -45088,14 +45016,14 @@ msgctxt "" msgid "Use the Styles deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles." msgstr "Erabili alboko barrako 'Estiloak' panela gelaxkei eta orriei estiloak esleitzeko. Aurretik dauden estiloak aplikatu, eguneratu eta aldatu ditzakezu, edo estilo berriak sortu." -#. HL32W +#. nTiyj #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3149665\n" "help.text" -msgid "The Styles <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link> can remain open while editing the document." -msgstr "'Estiloak' <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">leiho atrakagarria</link> irekita egon daiteke dokumentua editatzen ari zaren bitartean." +msgid "The Styles <link href=\"text/shared/00/00000005.xhp#docking\" name=\"dockable window\">dockable window</link> can remain open while editing the document." +msgstr "" #. cawKF #: 05100000.xhp @@ -45484,6 +45412,15 @@ msgctxt "" msgid "<variable id=\"autoformattext\"><ahelp hid=\".\">Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.</ahelp></variable>" msgstr "<variable id=\"autoformattext\"><ahelp hid=\".\">Hautatutako orri-barrutiari Autoformatua aplikatzeko edo zuk zeuk sortutako Autoformatuak definitzeko, erabili komando hau.</ahelp></variable>" +#. 7SZiE +#: 05110000.xhp +msgctxt "" +"05110000.xhp\n" +"par_id181630332690300\n" +"help.text" +msgid "The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu." +msgstr "" + #. Gid6Q #: 05110000.xhp msgctxt "" @@ -45736,50 +45673,68 @@ msgctxt "" msgid "<bookmark_value>conditional formatting; conditions</bookmark_value>" msgstr "<bookmark_value>baldintzapeko formatua; baldintzak</bookmark_value>" -#. FMGh8 +#. tYBMm +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"hd_id71624649758112\n" +"help.text" +msgid "Condition list" +msgstr "" + +#. aX6Li #: 05120000.xhp msgctxt "" "05120000.xhp\n" "par_id3149413\n" "help.text" -msgid "<ahelp hid=\".\" visibility=\"hidden\">List of the conditions defined for the cell range in order of evaluation.</ahelp>" -msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gelaxka-barrutirako definitu diren baldintzen zerrenda, ebaluazio-ordenan.</ahelp>" +msgid "List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want." +msgstr "" + +#. YHZ6v +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"hd_id41624649786605\n" +"help.text" +msgid "Up" +msgstr "" -#. u9xFc +#. xSGWr #: 05120000.xhp msgctxt "" "05120000.xhp\n" "par_id3149414\n" "help.text" -msgid "<ahelp hid=\".\" visibility=\"hidden\">Increase priority of the selected condition.</ahelp>" -msgstr "<ahelp hid=\".\" visibility=\"hidden\">Handitu hautatutako baldintzaren lehentasuna.</ahelp>" +msgid "<ahelp hid=\".\">Increase priority of the selected condition.</ahelp>" +msgstr "" -#. jtCfF +#. YWF6k #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3149415\n" +"hd_id861624649792266\n" "help.text" -msgid "<ahelp hid=\".\" visibility=\"hidden\">Decrease priority of the selected condition.</ahelp>" -msgstr "<ahelp hid=\".\" visibility=\"hidden\">Txikitu hautatutako baldintzaren lehentasuna.</ahelp>" +msgid "Down" +msgstr "" -#. kbqQx +#. BAEJK #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"hd_id31531891\n" +"par_id3149415\n" "help.text" -msgid "Condition" -msgstr "Baldintza" +msgid "<ahelp hid=\".\">Decrease priority of the selected condition.</ahelp>" +msgstr "" -#. XUCvV +#. FZJa2 #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494131\n" +"hd_id31531891\n" "help.text" -msgid "You can define as many conditions as you want." -msgstr "Nahi beste baldintza definitu ditzakezu." +msgid "Condition list entry" +msgstr "" #. YLwyA #: 05120000.xhp @@ -49228,14 +49183,14 @@ msgctxt "" msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/edfilterarea\">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</ahelp>" msgstr "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/edfilterarea\">Hautatu barruti izenduna, edo sartu erabili nahi dituzun iragazki-irizpideak dituen gelaxka-barrutia.</ahelp>" -#. DAGu3 +#. qhEo5 #: 12040300.xhp msgctxt "" "12040300.xhp\n" -"hd_id3153188\n" +"hd_id331625165680452\n" "help.text" -msgid "<link href=\"text/scalc/01/12040201.xhp\" name=\"More\">More</link>" -msgstr "<link href=\"text/scalc/01/12040201.xhp\" name=\"Gehiago\">Gehiago</link>" +msgid "Options" +msgstr "" #. oYCwG #: 12040400.xhp @@ -53359,6 +53314,78 @@ msgctxt "" msgid "Sample macro:" msgstr "Makro adibidea:" +#. vkaMd +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"par_id521625929022780\n" +"help.text" +msgid "Below is a sample function that can be called when an error occurs. Note that the macro takes in two parameters that are passed on by %PRODUCTNAME when the function is called:" +msgstr "" + +#. F9upo +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"par_id981625929097216\n" +"help.text" +msgid "<emph>CellValue</emph>: The value entered by the user, as a String." +msgstr "" + +#. oSFqW +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"par_id421625929100152\n" +"help.text" +msgid "<emph>CellAddress</emph>: The address of the cell where the value was entered, as a String prefixed with the sheet name (e.g: \"Sheet1.A1\")." +msgstr "" + +#. A52Nm +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"par_id101625929384030\n" +"help.text" +msgid "The function must return a Boolean value. If it returns <literal>True</literal>, the entered value is kept. If the function returns <literal>False</literal>, the entered value is erased and the previous value is restored." +msgstr "" + +#. 4tzCz +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"par_id531545240216611\n" +"help.text" +msgid "msg = \"Invalid value: \" & \"'\" & CellValue & \"'\"" +msgstr "" + +#. Zfic8 +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"bas_id971625928577365\n" +"help.text" +msgid "msg = msg & \" in cell: \" & \"'\" & CellAddress & \"'\"" +msgstr "" + +#. hiNR9 +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"bas_id181625928577640\n" +"help.text" +msgid "msg = msg & Chr(10) & \"Accept anyway?\"" +msgstr "" + +#. EhFBn +#: 12120300.xhp +msgctxt "" +"12120300.xhp\n" +"bas_id941625928578118\n" +"help.text" +msgid "iAnswer = MsgBox (msg , MB_FLAGS, \"Error message\")" +msgstr "" + #. 4C6T2 #: ODFF.xhp msgctxt "" @@ -53458,6 +53485,15 @@ msgctxt "" msgid "Example" msgstr "Adibidea" +#. 54Ga6 +#: common_func.xhp +msgctxt "" +"common_func.xhp\n" +"hd_id281996\n" +"help.text" +msgid "Examples" +msgstr "" + #. STMGF #: common_func.xhp msgctxt "" @@ -60190,14 +60226,14 @@ msgctxt "" msgid "<emph>Position</emph>: The position in the text where the search starts." msgstr "<emph>Kokagunea</emph>: Bilaketaren hasiera-puntua izango den kokagunea testuaren barruan." -#. VLM4H +#. okEBS #: func_findb.xhp msgctxt "" "func_findb.xhp\n" "par_id481573517830373\n" "help.text" -msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19." -msgstr "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> funtzioak 19 itzultzen du." +msgid "<input>=FINDB(\"ａ\"; \"LibreOffice Ｃａｌｃ\")</input> returns 15. The <emph>Find Text</emph> argument is a text string that comprises a full-width, double-byte \"a\" character, while the <emph>Text</emph> argument comprises 12 single-byte characters followed by four full-width, double-byte characters." +msgstr "" #. aACGP #: func_floor.xhp @@ -63394,77 +63430,131 @@ msgctxt "" msgid "<bookmark_value>NUMBERVALUE function</bookmark_value>" msgstr "<bookmark_value>TIMEVALUE funtzioa</bookmark_value>" -#. 6XDJp +#. GomzJ #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "hd_id3145621\n" "help.text" -msgid "<variable id=\"datevalue\"> <link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link> </variable>" -msgstr "<variable id=\"datevalue\"> <link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link> </variable>" +msgid "<variable id=\"numbervalue_h1\"><link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link></variable>" +msgstr "" -#. 3WLvS +#. Ywca6 #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3145087\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Convert text to number, in a locale-independent way.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Testua zenbaki bihurtu, eskualde-ezarpenaren mendekoa ez den moduan.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Converts the string representation of a number into a locale-independent numeric value.</ahelp>" +msgstr "" -#. JUF4C +#. xfP9G #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3149281\n" "help.text" -msgid "Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator" -msgstr "Murriztapenak: LEN(DezimalBereizlea) = 1, DezimalBereizlea parametroak ez du agertu behar TaldeBereizlea parametroan" +msgid "The input text may be in a locale-dependent or other bespoke format." +msgstr "" -#. 2uppP +#. vVK9p #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" -"par_id3149268\n" +"par_id381625600941159\n" +"help.text" +msgid "The output number is formatted as a valid floating point value and shown using the current cell's number format." +msgstr "" + +#. 2Ditv +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id351625601754290\n" +"help.text" +msgid "Refer to the <embedvar href=\"text/shared/01/05020300.xhp#NumbersLink\"/> help page to learn how to change the format of numbers in a cell." +msgstr "" + +#. vEdwF +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id721625602228575\n" "help.text" -msgid "NUMBERVALUE(\"Text\" [;decimal_separator [;group_separator]])" -msgstr "NUMBERVALUE(\"Testua\" [;DezimalBereizlea [;TaldeBereizlea]])" +msgid "NUMBERVALUE(Text[; Decimal Separator[; Group Separator]])" +msgstr "" -#. ytM82 +#. Y3A9n #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3154819\n" "help.text" -msgid "<emph>Text</emph> is a valid number expression and must be entered with quotation marks." -msgstr "<emph>Testua</emph> baliozko data-adierazpena da, eta komatxo artean sartu behar da." +msgid "<emph>Text</emph> is a string that contains the number to be converted." +msgstr "" -#. exDVp +#. gwZ7A #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3154820\n" "help.text" -msgid "<emph>decimal_separator</emph> (optional) defines the character used as the decimal separator." -msgstr "<emph>DezimalBereizlea</emph> (aukerakoa): bereizle dezimal modura erabiliko den karakterea definitzen du." +msgid "<emph>Decimal Separator</emph> is a single character that specifies the decimal separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any decimal or group separators." +msgstr "" -#. PAA4R +#. KJ6WA #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3154821\n" "help.text" -msgid "<emph>group_separator</emph> (optional) defines the character(s) used as the group separator." -msgstr "<emph>TaldeBereizlea</emph> (aukerakoa): talde-bereizle modura erabiliko d(ir)en karakterea(k) definitzen d(it)u." +msgid "<emph>Group Separator</emph> is a string that specifies the character(s) used as the group separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any group separators. The <emph>Decimal Separator</emph> character should not be used in <emph>Group Separator</emph>." +msgstr "" -#. zmrjG +#. yptHN #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3155841\n" "help.text" -msgid "<item type=\"input\">=NUMBERVALUE(\"123.456\";\".\";\",\")</item> yields 123.456" -msgstr "<item type=\"input\">=NUMBERVALUE(\"123,456\";\".\";\",\")</item>: 123,456 ematen du" +msgid "<input>=NUMBERVALUE(\"1.234.567,89\"; \",\"; \".\")</input> returns 1234567.89 (considering en-US locale). The function removes the two group separators and changes the decimal separator from a comma to a full stop." +msgstr "" + +#. UNiLM +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id721625603302860\n" +"help.text" +msgid "<input>=NUMBERVALUE(\"123·4\"; \"·\")</input> returns 123.4 (considering en-US locale). The function changes the decimal separator from a \"·\" to a full stop. No group separator is used in the supplied number and so the <emph>Group Separator</emph> argument is omitted." +msgstr "" + +#. iGGwj +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id491625603415715\n" +"help.text" +msgid "<input>=NUMBERVALUE(\"123e12\")</input> returns 1.23E+14 (considering en-US locale). No decimal or group separators are used in the supplied number and so the <emph>Decimal Separator</emph> and <emph>Group Separator</emph> arguments are omitted." +msgstr "" + +#. vTYDd +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id801625603497421\n" +"help.text" +msgid "<input>=NUMBERVALUE(\"1#!234#!567\"; \".\"; \"#!\")</input> returns 1234567 (considering en-US locale). Note that in this case the group separator is specified as a two-character string." +msgstr "" + +#. 4sMd6 +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id451626100385699\n" +"help.text" +msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE\" name=\"NUMBERVALUE_Wiki\">NUMBERVALUE</link> wiki page for more details about this function." +msgstr "" #. EJhfD #: func_opt_barrier.xhp @@ -64204,14 +64294,14 @@ msgctxt "" msgid "<emph>Text</emph>: A text or reference to a cell where the regular expression is to be applied." msgstr "<emph>Testua</emph>: Adierazpen erregularra aplikatuko zaion testua edo gelaxka baten erreferentzia." -#. gdhZh +#. aaDJc #: 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>Adierazpena</emph>: Adierazpen erregularra ordezkatzen duen testua. Erabili <link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU adierazpen erregularrak</link>. Bat etortzerik ez badago eta <emph>Ordezkoa</emph> ematen ez bada, #E/E itzuliko da." +msgid "<emph>Expression</emph>: A text representing the regular expression, using <link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html\" name=\"ICU REGEXP\">ICU regular expressions</link>. If there is no match and <emph>Replacement</emph> is not given, #N/A is returned." +msgstr "" #. ZBTYi #: func_regex.xhp @@ -64294,14 +64384,14 @@ msgctxt "" 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=\"regex lists\">Adierazpen erregularren zerrenda</link>" -#. U7Ffm +#. 2AHRN #: 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=\"ICU REGEXP\">ICU adierazpen erregularrak</link>" +msgid "<link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html\" name=\"ICU REGEXP\">ICU regular expressions</link>" +msgstr "" #. B64FM #: func_replaceb.xhp @@ -64348,32 +64438,32 @@ msgctxt "" msgid "REPLACEB( Text ; Position ; Length ; NewText )" msgstr "REPLACEB( Testua ; Kokagunea ; Luzera ; TestuBerria )" -#. eY5FG +#. uBLSC #: func_replaceb.xhp msgctxt "" "func_replaceb.xhp\n" "par_id331573510857418\n" "help.text" -msgid "<emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the characters are to be replaced." -msgstr "<emph>Testua</emph>: Karaktereak ordeztuko zaizkion testu-adierazpen bat edo testu-adierazpena duen gelaxka baten erreferentzia bat." +msgid "<emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the bytes are to be replaced." +msgstr "" -#. bqPxd +#. 9a6mz #: func_replaceb.xhp msgctxt "" "func_replaceb.xhp\n" "par_id431573510862075\n" "help.text" -msgid "<emph>Position</emph>: the character position from which text is to be replaced." -msgstr "<emph>Kokagunea</emph>: Testua ordezten hasiko den kokaguneko karakterea." +msgid "<emph>Position</emph>: the byte position from which text is to be replaced." +msgstr "" -#. TtgNA +#. AsHs8 #: func_replaceb.xhp msgctxt "" "func_replaceb.xhp\n" "par_id481573510866260\n" "help.text" -msgid "<emph>Length</emph>: the number of characters to be replaced." -msgstr "<emph>Luzera</emph>: Ordeztuko den karaktere kopurua." +msgid "<emph>Length</emph>: the number of bytes to be replaced." +msgstr "" #. UuACG #: func_replaceb.xhp @@ -64393,6 +64483,15 @@ msgctxt "" msgid "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> returns \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" ." msgstr "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> funtzioak \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" itzultzen du." +#. zzieb +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id721626381053212\n" +"help.text" +msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB\" name=\"REPLACEB_Wiki\">REPLACEB</link> wiki page for more details about this function." +msgstr "" + #. E7heY #: func_roundsig.xhp msgctxt "" @@ -65419,6 +65518,132 @@ msgctxt "" msgid "<item type=\"input\">TODAY()</item> returns the current computer system date." msgstr "<item type=\"input\">=TODAY()</item> funtzioak ordenagailuaren sistemaren uneko data ematen du." +#. w86Dm +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"tit\n" +"help.text" +msgid "VALUE Function" +msgstr "" + +#. D5EDU +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"bm_id831542233029549\n" +"help.text" +msgid "<bookmark_value>VALUE function</bookmark_value> <bookmark_value>text functions;convert text to numeric value</bookmark_value>" +msgstr "" + +#. pkYxF +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"hd_id881628776094597\n" +"help.text" +msgid "<variable id=\"Value_h1\"><link href=\"text/scalc/01/func_value.xhp\" name=\"function VALUE\">VALUE</link></variable>" +msgstr "" + +#. BZ7SU +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id541542230672101\n" +"help.text" +msgid "<variable id=\"func_value_desc\"><ahelp hid=\".\">Converts the string representation of a number to numeric form. If the supplied string is a valid date, time, or date-time, the corresponding date-time serial number is returned.</ahelp></variable>" +msgstr "" + +#. KAY8o +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id701542231253817\n" +"help.text" +msgid "<input>VALUE(Text)</input>" +msgstr "" + +#. QVErw +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id621542232197446\n" +"help.text" +msgid "<emph>Text</emph>: A string (in quotation marks), a number, or a reference to a cell containing one of those types, that contains the value to be converted." +msgstr "" + +#. hMLPV +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id731628787003937\n" +"help.text" +msgid "If the <emph>Text</emph> argument is a string representing a date, time, currency or a numeric value with decimal and thousands separators, the string must comply with current locale settings." +msgstr "" + +#. 3BCEU +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id451628776707264\n" +"help.text" +msgid "<input>=VALUE(\"1234\")</input> returns the numeric value 1234." +msgstr "" + +#. zEuFg +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id101628778036375\n" +"help.text" +msgid "<input>=VALUE(\"+1,234.567\")</input> returns 1234.567 (considering en-US locale). Note that the \"+\" sign could have been omitted." +msgstr "" + +#. Hhrax +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id991628779914913\n" +"help.text" +msgid "<input>=VALUE(\"$100\")</input> returns 100 (considering en-US locale). Note that the currency prefix must match the current locale settings." +msgstr "" + +#. syxTJ +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id101628780114427\n" +"help.text" +msgid "<input>=VALUE(\"50%\")</input> returns 0.5. Note that the character \"%\" causes the numeric part to be divided by 100." +msgstr "" + +#. xDJeH +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id731628780240876\n" +"help.text" +msgid "<input>=VALUE(\"07/30/2021\")</input> returns 44407 (considering en-US locale) which is the date-time sequence number corresponding to the specified date." +msgstr "" + +#. Kkcm7 +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id501628780340635\n" +"help.text" +msgid "<input>=VALUE(\"09:20:25\")</input> returns 0.389178240740741 which is the date-time sequence number corresponding to the specified time value." +msgstr "" + +#. qxHgs +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id801628779804928\n" +"help.text" +msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\" name=\"VALUE Wiki\">VALUE</link> wiki page for more details about this function." +msgstr "" + #. dQeP6 #: func_webservice.xhp msgctxt "" @@ -68938,32 +69163,32 @@ msgctxt "" msgid "The following table displays the results of the descriptive statistics of the sample data above." msgstr "Hurrengo taulak goiko lagin-datuen estatistika deskribatzaileen emaitzak bistaratzen ditu." -#. XC7CC +#. BmGdK #: statistics_descriptive.xhp msgctxt "" "statistics_descriptive.xhp\n" "par_id1000690\n" "help.text" -msgid "Column 1" -msgstr "1. zutabea" +msgid "Maths" +msgstr "" -#. HY2UN +#. BYWoQ #: statistics_descriptive.xhp msgctxt "" "statistics_descriptive.xhp\n" "par_id1000700\n" "help.text" -msgid "Column 2" -msgstr "2. zutabea" +msgid "Physics" +msgstr "" -#. qTDSp +#. FeMDR #: statistics_descriptive.xhp msgctxt "" "statistics_descriptive.xhp\n" "par_id1000710\n" "help.text" -msgid "Column 3" -msgstr "3. zutabea" +msgid "Biology" +msgstr "" #. AjAbs #: statistics_descriptive.xhp @@ -69532,14 +69757,14 @@ msgctxt "" msgid "Regression Analysis" msgstr "Erregresio-analisia" -#. wDYsU +#. vJQLe #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" "bm_id2764278\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value>" -msgstr "<bookmark_value>Analysis tresna-paketea;erregresio-analisia</bookmark_value><bookmark_value>erregresio-analisia;Analysis tresna-paketea</bookmark_value><bookmark_value>datuen estatistikak;erregresio-analisia</bookmark_value>" +msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value><bookmark_value>Confidence level;regression analysis</bookmark_value><bookmark_value>regression analysis;linear</bookmark_value><bookmark_value>regression analysis;power</bookmark_value><bookmark_value>regression analysis;logarithmic</bookmark_value>" +msgstr "" #. UPKr7 #: statistics_regression.xhp @@ -69550,14 +69775,23 @@ msgctxt "" msgid "<variable id=\"regressionanalysish1\"><link href=\"text/scalc/01/statistics_regression.xhp\" name=\"regression analysis\">Regression Analysis</link></variable>" msgstr "<variable id=\"regressionanalysish1\"><link href=\"text/scalc/01/statistics_regression.xhp\" name=\"regression analysis\">Erregresio-analisia</link></variable>" -#. NFhSA +#. A8gk9 #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" "par_id1001240\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the regression analysis of a data set</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Datu multzo baten erregresio-analisia ematen du</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Performs linear, logarithmic, or power regression analysis of a data set comprising one dependent variable and multiple independent variables.</ahelp>" +msgstr "" + +#. PDDGb +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"par_id431629832333206\n" +"help.text" +msgid "For example, a crop yield (dependent variable) may be related to rainfall, temperature conditions, sunshine, humidity, soil quality and more, all of them independent variables." +msgstr "" #. ENJtD #: statistics_regression.xhp @@ -69577,140 +69811,194 @@ msgctxt "" msgid "For more information on regression analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">corresponding Wikipedia article</link>." msgstr "Erregresio-analisiei buruzko informazio gehiagorako, ikusi <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">Wikipediako artikulua.</link>" -#. rdATw +#. G5y4R #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"hd_id1000070\n" +"hd_id891629830986496\n" "help.text" -msgid "Output Regression Type" -msgstr "Irteerako erregresio motak" +msgid "Data" +msgstr "" -#. QMDBG +#. 9uRGh #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1001280\n" +"hd_id101629830993962\n" "help.text" -msgid "Set the regression type. Three types are available:" -msgstr "Ezarri erregresio mota. Hiru mota daude erabilgarri:" +msgid "Independent variable(s) (X) range:" +msgstr "" -#. 7Avaz +#. XGD77 #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201620334364\n" +"par_id961629834099308\n" "help.text" -msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data." -msgstr "<emph>Erregresio lineala</emph>: aurkitu datue ondoen egokitzen zaien marra zuzen bat <item type=\"literal\">y = a.x + b</item> forman, non <item type=\"literal\">a</item> malda den eta <item type=\"literal\">b</item> ebakidura den." +msgid "Enter a single range that contains multiple independent variable observations (along columns or rows). All X variable observations need to be entered adjacent to each other in the same table." +msgstr "" -#. B6dex +#. yCogF #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201620340168\n" +"hd_id871629830998653\n" "help.text" -msgid "<emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type=\"literal\">y = a.ln(x) + b</item>, where <item type=\"literal\">a</item> is the slope, <item type=\"literal\">b</item> is the intercept and <item type=\"literal\">ln(x)</item> is the natural logarithm of <item type=\"literal\">x</item>, that best fits the data." -msgstr "<emph>Erregresio logaritmikoa</emph>: aurkitu datuei ondoen egokitzen zaien kurba logaritmiko bat <item type=\"literal\">y = a.ln(x) + b</item> forman, non <item type=\"literal\">a</item> malda den, <item type=\"literal\">b</item> ebakidura den eta <item type=\"literal\">ln(x)</item> <item type=\"literal\">x</item> balioaren logaritmo naturala den." +msgid "Dependent variable (Y) range:" +msgstr "" -#. txgoZ +#. NiB9B #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201620340139\n" +"par_id391629834089370\n" "help.text" -msgid "<emph>Power regression</emph>: Find a power curve in the form of <item type=\"literal\">y = a.x^b</item>, where <item type=\"literal\">a</item> is the coefficient, <item type=\"literal\">b</item> is the power that best fits the data." -msgstr "<emph>Erregresio potentziala</emph>: Aurkitu datuei ondoen egokitzen zaien kurba potentzial bat <item type=\"literal\">y = a.x^b</item> forman, non <item type=\"literal\">a</item> koefizientea den eta <item type=\"literal\">b</item> potentzia den." +msgid "Enter the range that contains the dependent variable whose regression is to be calculated." +msgstr "" -#. EtPbr +#. A8dZ8 #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1001310\n" +"hd_id931629831003368\n" "help.text" -msgid "The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below." -msgstr "Goiko taulako neurketen hiru <emph>erregresio-analisi</emph> moten emaitzak behean erakusten dira." +msgid "Both X and Y ranges have labels" +msgstr "" -#. iJ7yf +#. mSnba #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090526\n" +"par_id261629834071776\n" "help.text" -msgid "Regression" -msgstr "Erregresioa" +msgid "Check to use the first line (or column) of the data sets as variable names in the output range." +msgstr "" -#. cSAoU +#. 7TDwz #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090542\n" +"hd_id11629831014811\n" "help.text" -msgid "Regression Model" -msgstr "Erregresio-eredua" +msgid "Results to:" +msgstr "" -#. YAGFi +#. CAKdU #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090596\n" +"par_id441629834000533\n" "help.text" -msgid "Linear" -msgstr "Lineala" +msgid "The reference of the top left cell of the range where the results will be displayed." +msgstr "" -#. 2zcqS +#. ZMxv6 #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090586\n" +"hd_id1000070\n" "help.text" -msgid "Logarithmic" -msgstr "Logaritmikoa" +msgid "Output Regression Types" +msgstr "" -#. QvaFq +#. QMDBG #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090555\n" +"par_id1001280\n" "help.text" -msgid "Power" -msgstr "Potentzia" +msgid "Set the regression type. Three types are available:" +msgstr "Ezarri erregresio mota. Hiru mota daude erabilgarri:" -#. oHBnC +#. vauNm #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090553\n" +"par_id1701201620334364\n" "help.text" -msgid "R^2" -msgstr "R^2" +msgid "<emph>Linear Regression</emph>: finds a linear function in the form of y = b + a<sub>1</sub>.[x<sub>1</sub>] + a<sub>2</sub>.[x<sub>2</sub>] + a<sub>3</sub>.[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th slope, [x<sub>i</sub>] is the i-th independent variable, and b is the intercept that best fits the data." +msgstr "" -#. egmFM +#. cR7FM #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090595\n" +"par_id1701201620340168\n" "help.text" -msgid "Standard Error" -msgstr "Errore estandarra" +msgid "<emph>Logarithmic regression</emph>: finds a logarithmic curve in the form of y = b + a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th coefficient, b is the intercept and ln[x<sub>i</sub>] is the natural logarithm of the i-th independent variable, that best fits the data." +msgstr "" + +#. YfNEL +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"par_id1701201620340139\n" +"help.text" +msgid "<emph>Power regression</emph>: finds a power curve in the form of y = exp( b + a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ...), where a<sub>i</sub> is the i-th power, [x<sub>i</sub>] is the i-th independent variable, and b is intercept that best fits the data." +msgstr "" -#. woESA +#. 3KkxA #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090563\n" +"hd_id331629834218606\n" "help.text" -msgid "Slope" -msgstr "Malda" +msgid "Options" +msgstr "" -#. qfNCA +#. uBCr7 #: statistics_regression.xhp msgctxt "" "statistics_regression.xhp\n" -"par_id1701201618090642\n" +"hd_id481629834269509\n" "help.text" -msgid "Intercept" -msgstr "Ebakidura" +msgid "Confidence level" +msgstr "" + +#. YjBMV +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"par_id971629835636129\n" +"help.text" +msgid "A numeric value between 0 and 1 (exclusive), default is 0.95. Calc uses this percentage to compute the corresponding confidence intervals for each of the estimates (namely the slopes and intercept)." +msgstr "" + +#. f2CEs +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"hd_id751629834274709\n" +"help.text" +msgid "Calculate residuals" +msgstr "" + +#. b4unQ +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"par_id401629835408653\n" +"help.text" +msgid "Select whether to opt in or out of computing the residuals, which may be beneficial in cases where you are interested only in the slopes and intercept estimates and their statistics. The residuals give information on how far the actual data points deviate from the predicted data points, based on the regression model." +msgstr "" + +#. F99az +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"hd_id861629834279039\n" +"help.text" +msgid "Force intercept to be zero" +msgstr "" + +#. UYdQb +#: statistics_regression.xhp +msgctxt "" +"statistics_regression.xhp\n" +"par_id121629837424848\n" +"help.text" +msgid "Calculates the regression model using zero as the intercept, thus forcing the model to pass through the origin." +msgstr "" #. u47eB #: statistics_sampling.xhp diff --git a/source/eu/helpcontent2/source/text/scalc/04.po b/source/eu/helpcontent2/source/text/scalc/04.po index 474b6ceedf8..7feedee2eba 100644 --- a/source/eu/helpcontent2/source/text/scalc/04.po +++ b/source/eu/helpcontent2/source/text/scalc/04.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-14 18:09+0100\n" -"PO-Revision-Date: 2021-04-04 23:37+0000\n" +"POT-Creation-Date: 2021-09-10 23:11+0200\n" +"PO-Revision-Date: 2021-09-12 07:36+0000\n" "Last-Translator: Asier Sarasua Garmendia <asiersar@yahoo.com>\n" "Language-Team: Basque <https://translations.documentfoundation.org/projects/libo_help-master/textscalc04/eu/>\n" "Language: eu\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=n != 1;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Weblate 4.4.2\n" +"X-Generator: Weblate 4.8.1\n" "X-POOTLE-MTIME: 1556007671.000000\n" #. NQkD7 @@ -25,14 +25,14 @@ msgctxt "" msgid "Shortcut Keys for Spreadsheets" msgstr "Kalkulu-orrietako laster-teklak" -#. KkAUs +#. DdGD4 #: 01020000.xhp msgctxt "" "01020000.xhp\n" "bm_id3145801\n" "help.text" -msgid "<bookmark_value>spreadsheets; shortcut keys in</bookmark_value><bookmark_value>shortcut keys; spreadsheets</bookmark_value><bookmark_value>sheet ranges; filling</bookmark_value>" -msgstr "<bookmark_value>kalkulu-orriak; laster-teklak: </bookmark_value><bookmark_value>laster-teklak; kalkulu-orriak</bookmark_value><bookmark_value>orri-barrutiak; betetzea</bookmark_value>" +msgid "<bookmark_value>spreadsheets; shortcut keys in</bookmark_value> <bookmark_value>shortcut keys; spreadsheets</bookmark_value> <bookmark_value>sheet ranges; filling</bookmark_value>" +msgstr "<bookmark_value>kalkulu-orrien; laster-teklak</bookmark_value> <bookmark_value>laster-teklak; kalkulu-orrietan</bookmark_value> <bookmark_value>orri-barrutiak; betetzea</bookmark_value>" #. CkSXA #: 01020000.xhp @@ -187,14 +187,14 @@ msgctxt "" msgid "End" msgstr "\"Bukaera\" tekla" -#. ezWwF +#. THrNt #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3155095\n" "help.text" -msgid "Moves the cursor to the last cell of the current row." -msgstr "Uneko errenkadako azken gelaxkara eramaten du kurtsorea." +msgid "Moves the cursor to the last cell that contains values in the current row." +msgstr "Uneko errenkadako balioa duen azken gelaxkara eramaten du kurtsorea." #. FhvWD #: 01020000.xhp @@ -223,14 +223,14 @@ msgctxt "" msgid "Shift+End" msgstr "Shift+End" -#. BnYcn +#. CsAmu #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id4155095\n" "help.text" -msgid "Selects cells from the current cell to the last cell of the current row." -msgstr "Gelaxkak hautatzen ditu, uneko gelaxkatik uneko errenkadaren azken gelaxkaraino." +msgid "Selects all cells from the current cell to the last cell that contains values in the current row." +msgstr "" #. 8bBCM #: 01020000.xhp @@ -331,14 +331,14 @@ msgctxt "" msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left Arrow" msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">⌘</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+ezkerrerako gezia" -#. LWDGG +#. ziZQj #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3154766\n" "help.text" -msgid "Moves the cursor leftward to the start and end of cell blocks with data. If the cell to the left of the cursor is empty or the cell with cursor is empty, cursor moves leftward in row to the next cell with contents. If the row on the left of the cursor is empty, the cursor moves to then first cell in the row." -msgstr "Kurtsorea ezkerrerantz eramaten du, datuak dituen gelaxka-blokeen hasierara eta amaierara. Kurtsorearen ezkerreko gelaxka hutsik badago edo kurtsorea duen gelaxka hutsik badago, kurtsorea ezkerrerantz joango da errenkadan, edukiak dituen hurrengo gelaxkara. Kurtsorearen ezkerreko errenkada hutsik badago, kurtsorea errenkadako lehen gelaxkara joango da." +msgid "Moves the cursor leftward to the start and end of cell blocks with data. If the cell to the left of the cursor is empty or the cell with the cursor is empty, the cursor moves leftward in the current row until it reaches the next cell with contents. If all cells in the same row to the left of the cursor are empty, the cursor moves to the first cell in the row." +msgstr "" #. PgM3v #: 01020000.xhp @@ -349,14 +349,14 @@ msgctxt "" msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right Arrow" msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">⌘</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+eskuinerako gezia" -#. TURv3 +#. WxdVv #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3155593\n" "help.text" -msgid "Moves the cursor rightward to the start and end of cell blocks with contents. If the cell to the right of the cursor is empty or the cursor is in an empty cell, the cursor moves rightward to the next cell that contains data. If the row on the right of the cursor is empty, the cursor moves to the last cell in the row." -msgstr "Kurtsorea eskuinerantz eramaten du, datuak dituen gelaxka-blokeen hasierara eta amaierara. Kurtsorearen eskuineko gelaxka hutsik badago edo kurtsorea duen gelaxka hutsik badago, kurtsorea eskuinerantz joango da edukiak dituen hurrengo gelaxkara. Kurtsorearen eskuineko errenkada hutsik badago, kurtsorea errenkadako azken gelaxkara joango da." +msgid "Moves the cursor rightward to the start and end of cell blocks with data. If the cell to the right of the cursor is empty or the cell with the cursor is empty, the cursor moves rightward in the current row until it reaches the next cell with contents. If all cells in the same row to the right of the cursor are empty, the cursor moves to the last cell in the row." +msgstr "" #. R9tmv #: 01020000.xhp @@ -367,14 +367,14 @@ msgctxt "" msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Up Arrow" msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">⌘</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+gorako gezia" -#. FhV8W +#. UV76n #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3153076\n" "help.text" -msgid "Moves the cursor upward to the start and end of cell blocks with data. If the cell above the cursor is empty or the cursor is in an empty cell, the cursor moves up to the end of next cell block with data. If the column above the cursor is empty, the cursor moves up to first cell in the column." -msgstr "Kurtsorea gorantz eramaten du, datuak dituen gelaxka-blokeen hasierara eta amaierara. Kurtsorearen gaineko gelaxka hutsik badago edo kurtsorea duen gelaxka hutsik badago, kurtsorea gorantz joango da edukiak dituen hurrengo gelaxka-blokera. Kurtsorearen gaineko errenkada hutsik badago, kurtsorea zutabeko lehen gelaxkara joango da." +msgid "Moves the cursor upward to the start and end of cell blocks with data. If the cell above the cursor is empty or the cell with the cursor is empty, the cursor moves upward in the current column until it reaches the next cell with contents. If all cells in the same column above the cursor are empty, the cursor moves to the first cell in the column." +msgstr "" #. EamtM #: 01020000.xhp @@ -385,14 +385,14 @@ msgctxt "" msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down Arrow" msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">⌘</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+beherako gezia" -#. kB7sB +#. x95TY #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3149054\n" "help.text" -msgid "Moves the cursor downward to the start and end of cell blocks with data. If the cell below the cursor is empty or the cursor is in an empty cell, the cursor moves down to the next cell that contains data. If the column below the cursor is empty, the cursor moves down to last cell in the column." -msgstr "Kurtsorea beherantz eramaten du, datuak dituen gelaxka-blokeen hasierara eta amaierara. Kurtsorearen azpiko gelaxka hutsik badago edo kurtsorea duen gelaxka hutsik badago, kurtsorea beherantz joango da edukiak dituen hurrengo gelaxkara. Kurtsorearen azpiko errenkada hutsik badago, kurtsorea zutabeko azken gelaxkara joango da." +msgid "Moves the cursor downward to the start and end of cell blocks with data. If the cell below the cursor is empty or the cell with the cursor is empty, the cursor moves downward in the current column until it reaches the next cell with contents. If all cells in the same column below the cursor are empty, the cursor moves to the last cell in the column." +msgstr "" #. UQi4B #: 01020000.xhp @@ -403,14 +403,14 @@ msgctxt "" msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Arrow" msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">⌘</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+gezia" -#. BKMzG +#. FwaRy #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3159258\n" "help.text" -msgid "Selects all cells of the range created by the cursor movements using the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Arrows</keycode> key combinations. If used to select rows and columns together, a rectangular cell range is selected." -msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>⌘</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+↑↓←→</keycode> tekla-konbinazioak erabilita kurtsorea mugitzean sortutako barrutiko gelaxka guztiak hautatzen ditu. Errenkadak eta zutabeak aldi berean hautatzeko erabili bada, gelaxka-barruti laukizuzena hautatuko da." +msgid "Selects all cells of the range created by the cursor movements using the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Arrows</keycode> key combinations. If used to select rows and columns together, a rectangular cell range is selected. If the cursor is in an empty cell, the selection will stretch from the current cell up to the first cell with value in the direction of the arrow pressed." +msgstr "" #. F95ji #: 01020000.xhp @@ -637,14 +637,68 @@ msgctxt "" msgid "Enter (in a selected range)" msgstr "Sartu (hautatutako barruti batean)" -#. iA7nB +#. aFEgB #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3153935\n" "help.text" -msgid "Moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - General</emph>." -msgstr "Kurtsorea gelaxka bat behera mugitzen du hautatutako barrutian. Kurtsorea mugituko den norabidea zehazteko, aukeratu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Hobespenak</emph></caseinline><defaultinline><emph>Tresnak - Aukerak</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Orokorra</emph>." +msgid "Moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - General</emph> and change the option in <emph>Press Enter to move selection</emph>." +msgstr "" + +#. DbRBy +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id351630625364216\n" +"help.text" +msgid "Enter (after copying cell contents)" +msgstr "" + +#. 5PZQn +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id681630625395135\n" +"help.text" +msgid "If cell contents have just been copied to the clipboard and no additional editing has been done in the current file, then pressing <keycode>Enter</keycode> will paste clipboard contents to the current cursor position." +msgstr "" + +#. 2MKS8 +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id521630625780621\n" +"help.text" +msgid "Shift+Enter" +msgstr "" + +#. dAv3b +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id541630625783264\n" +"help.text" +msgid "If the clipboard contains cell contents and no editing has been done in the file, then <keycode>Shift+Enter</keycode> has the same behavior as <keycode>Enter</keycode> and pastes clipboard contents to the current cursor position." +msgstr "" + +#. so8sW +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id921630625968749\n" +"help.text" +msgid "If no cells are selected, <keycode>Shift+Enter</keycode> moves the cursor to the opposite direction defined in the option <emph>Press Enter to move selection</emph> found in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - General</emph>." +msgstr "" + +#. f4gCc +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id951630626229215\n" +"help.text" +msgid "If a range of cells is selected, <keycode>Shift+Enter</keycode> moves the cursor inside the current selection to the opposite direction defined in the option <emph>Press Enter to move selection</emph>." +msgstr "" #. ESQwM #: 01020000.xhp @@ -727,23 +781,41 @@ msgctxt "" msgid "F2" msgstr "F2" -#. N2Q5C +#. BUfoX #: 01020000.xhp msgctxt "" "01020000.xhp\n" "par_id3148568\n" "help.text" -msgid "Switches to Edit mode and places the cursor at the end of the contents of the current cell. Press again to exit Edit mode." -msgstr "Edizio modura aldatzen du, eta uneko gelaxkaren edukiaren amaieran kokatzen du kurtsorea. Sakatu berriro Edizio modutik irteteko." +msgid "With a cell selected, press F2 to open cell contents for editing. If the cell contains a formula, use arrow keys to navigate the sheet to easily enter range addresses into the formula." +msgstr "" -#. GFKGE +#. KPNsf #: 01020000.xhp msgctxt "" "01020000.xhp\n" -"par_id3153108\n" +"par_id381629750112725\n" "help.text" -msgid "If the cursor is in an input box in a dialog that has a <emph>Minimize </emph>button, the dialog is hidden and the input box remains visible. Press F2 again to show the whole dialog." -msgstr "<emph>Minimizatu</emph> botoia duen elkarrizketako koadro bateko sarrera-koadro batean badago kurtsorea, elkarrizketa-koadroa ezkutatuta egongo da eta sarrera-koadroa ikusgai. Elkarrizketa-koadro osoa ikusteko, sakatu berriro F2." +msgid "Press F2 again to enable the use of arrow keys to move the cursor in the formula text." +msgstr "" + +#. YE2ga +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id481629750230372\n" +"help.text" +msgid "Each additional use of the F2 shortcut switches between the two states previously described." +msgstr "" + +#. Dzhco +#: 01020000.xhp +msgctxt "" +"01020000.xhp\n" +"par_id461629750358215\n" +"help.text" +msgid "Some dialog boxes have input fields with a <emph>Shrink</emph> button. Pressing F2 with the cursor inside such field causes the <emph>Shrink</emph> command to be executed." +msgstr "" #. seNCx #: 01020000.xhp @@ -1033,14 +1105,14 @@ msgctxt "" msgid "Updates the selected chart." msgstr "Hautatutako diagrama eguneratzen du." -#. 7Bnwf +#. VLV2J #: 01020000.xhp msgctxt "" "01020000.xhp\n" "hd_id3149279\n" "help.text" -msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command+T</caseinline><defaultinline>F11</defaultinline></switchinline>" -msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">⌘+T</caseinline><defaultinline>F11</defaultinline></switchinline>" +msgid "<switchinline select=\"sys\"> <caseinline select=\"MAC\">Command+T</caseinline> <defaultinline>F11</defaultinline> </switchinline>" +msgstr "" #. edNSJ #: 01020000.xhp @@ -1752,12 +1824,3 @@ msgctxt "" "help.text" msgid "Removes the current field from the area." msgstr "Uneko eremua kentzen du areatik." - -#. npGBx -#: 01020000.xhp -msgctxt "" -"01020000.xhp\n" -"par_id3150630\n" -"help.text" -msgid "<link href=\"text/shared/04/01010000.xhp\" name=\"shortcut keys in $[officename]\">Shortcut keys in $[officename]</link>" -msgstr "<link href=\"text/shared/04/01010000.xhp\" name=\"shortcut keys in $[officename]\">$[officename] aplikazioko laster-teklak</link>" diff --git a/source/eu/helpcontent2/source/text/scalc/06.po b/source/eu/helpcontent2/source/text/scalc/06.po index 7e662a30f09..9ea9bcfedb4 100644 --- a/source/eu/helpcontent2/source/text/scalc/06.po +++ b/source/eu/helpcontent2/source/text/scalc/06.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2018-11-14 12:22+0100\n" +"POT-Creation-Date: 2019-07-11 18:38+0200\n" "PO-Revision-Date: 2018-04-26 15:53+0000\n" "Last-Translator: Asier Sarasua Garmendia <asiersar@yahoo.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -13,9 +13,10 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=(n != 1);\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Pootle 2.8\n" +"X-Generator: LibreOffice\n" "X-POOTLE-MTIME: 1524758018.000000\n" +#. HDsTF #: calcsamplefiles.xhp msgctxt "" "calcsamplefiles.xhp\n" diff --git a/source/eu/helpcontent2/source/text/scalc/guide.po b/source/eu/helpcontent2/source/text/scalc/guide.po index 79888a83bf6..10afa5c08ab 100644 --- a/source/eu/helpcontent2/source/text/scalc/guide.po +++ b/source/eu/helpcontent2/source/text/scalc/guide.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2021-05-31 15:15+0200\n" +"POT-Creation-Date: 2021-09-10 23:11+0200\n" "PO-Revision-Date: 2021-07-01 16:20+0000\n" "Last-Translator: Asier Sarasua Garmendia <asiersar@yahoo.com>\n" "Language-Team: Basque <https://translations.documentfoundation.org/projects/libo_help-master/textscalcguide/eu/>\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=n != 1;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Weblate 4.6.2\n" +"X-Generator: LibreOffice\n" "X-POOTLE-MTIME: 1562054410.000000\n" #. NXy6S @@ -403,14 +403,14 @@ msgctxt "" msgid "Using AutoFormat for Tables" msgstr "Tauletan autoformatua erabiltzea" -#. 33hwy +#. V4grY #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "bm_id3155132\n" "help.text" -msgid "<bookmark_value>tables; AutoFormat function</bookmark_value> <bookmark_value>defining;AutoFormat function for tables</bookmark_value> <bookmark_value>AutoFormat function</bookmark_value> <bookmark_value>formats; automatically formatting spreadsheets</bookmark_value> <bookmark_value>automatic formatting in spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat function</bookmark_value>" -msgstr "<bookmark_value>taulak; Autoformatuaren funtzioa</bookmark_value> <bookmark_value>definitzea;Autoformatuaren funtzioa tauletarako</bookmark_value> <bookmark_value>Autoformatuaren funtzioa</bookmark_value> <bookmark_value>formatuak; kalkulu-orriak automatikoki formateatzea</bookmark_value> <bookmark_value>kalkulu-orriak automatikoki formateatzea</bookmark_value> <bookmark_value>orriak;Autoformatuaren funtzioa</bookmark_value>" +msgid "<bookmark_value>tables; AutoFormat</bookmark_value> <bookmark_value>AutoFormat cell ranges</bookmark_value> <bookmark_value>formats; automatically formatting spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat</bookmark_value>" +msgstr "" #. EiEMB #: autoformat.xhp @@ -421,122 +421,113 @@ msgctxt "" msgid "<variable id=\"autoformat\"><link href=\"text/scalc/guide/autoformat.xhp\" name=\"Using AutoFormat for Tables\">Applying Automatic Formatting to a Selected Cell Range</link></variable>" msgstr "<variable id=\"autoformat\"><link href=\"text/scalc/guide/autoformat.xhp\" name=\"Using AutoFormat for Tables\">Aplikatu formatu automatikoa hautatutako gelaxka-barrutiari</link></variable>" -#. CC2ie +#. 7xexA #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_id3149401\n" "help.text" -msgid "You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range." -msgstr "Autoformatuarekin berehala aplikatu ahal izango diozu formatua orri bati nahiz hautatutako gelaxka-barruti bati." +msgid "Use the AutoFormat feature to quickly apply a format to a selected cell range." +msgstr "" -#. FGf7G +#. rA9iM #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN10702\n" "help.text" -msgid "To Apply an AutoFormat to a Sheet or Selected Cell Range" -msgstr "Orri bati edo hautatutako gelaxka-barruti bati autoformatua aplikatzeko" +msgid "Applying an AutoFormat to a Selected Cell Range" +msgstr "" -#. XEBko +#. jDKjA #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN106CE\n" "help.text" -msgid "Select the cells, including the column and row headers, that you want to format." -msgstr "Hautatu formateatu nahi dituzun gelaxkak, zutabeetako eta errenkadetako goiburukoak barne." +msgid "Select the range of cells to which the AutoFormat style is to be applied. The range must be at least 3 columns and 3 rows in size." +msgstr "" -#. PMa8H +#. 6GCsB #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN106D5\n" "help.text" -msgid "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>." -msgstr "Aukeratu <item type=\"menuitem\">Formatua - Autoformatu-estiloak</item>." +msgid "Go to <menuitem>Format - AutoFormat Styles</menuitem> to open the AutoFormat dialog." +msgstr "" -#. YT4xh +#. CXiex #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_id3151242\n" +"par_id771630333791025\n" "help.text" -msgid "Select which properties to include in an AutoFormat." -msgstr "Hautatu autoformatu batean sartuko diren propietateak." +msgid "In the <emph>Format</emph> list choose the AutoFormat style to apply." +msgstr "" -#. dhKwA +#. tCZL9 #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_idN10715\n" +"par_id3151242\n" "help.text" -msgid "Click <emph>OK</emph>." -msgstr "Egin klik <emph>Ados</emph> botoian." +msgid "In the <emph>Formatting</emph> section choose which properties from the AutoFormat style to apply to the selected cell range." +msgstr "" -#. 5rFWK +#. rgXQa #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_idN1075D\n" +"par_idN10715\n" "help.text" -msgid "The format is applied to the selected range of cells." -msgstr "Formatua aplikatuko zaio hautatutako gelaxka-barrutiari." +msgid "Click <emph>OK</emph> to apply the AutoFormat style and close the dialog." +msgstr "" -#. gG5Fm +#. EAyCv #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_id3149210\n" "help.text" -msgid "If you do not see any change in color of the cell contents, choose <item type=\"menuitem\">View - Value Highlighting</item>." -msgstr "Aldaketarik ez baduzu ikusten gelaxka-edukiaren kolorean, aukeratu <item type=\"menuitem\">Ikusi - Nabarmendu balioak</item>." +msgid "In case the color of the cell contents does not change, make sure <menuitem>View - Value Highlighting</menuitem> is disabled." +msgstr "" -#. WuFW6 +#. ovMm9 #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_id3155379\n" +"bm_id11630343392868\n" "help.text" -msgid "To Define an AutoFormat for Spreadsheets or Ranges" -msgstr "Kalkulu-orrietarako edo barrutietarako autorformatua aplikatzeko" +msgid "<bookmark_value>defining;AutoFormat styles</bookmark_value>" +msgstr "" -#. kMXDR +#. 5DZHa #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_id3148868\n" +"hd_id731630343367098\n" "help.text" -msgid "You can define a new AutoFormat that is available to all spreadsheets and ranges." -msgstr "Kalkulu-orri eta barruti guztietan erabilgarri egongo den autoformatu berri bat definitu daiteke." +msgid "Defining a new AutoFormat style" +msgstr "" -#. LBQQi +#. 2QDCM #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_id3152985\n" "help.text" -msgid "Format a sheet or range." -msgstr "Eman formatua orri edo barruti bati." +msgid "In a Calc spreadsheet, format a cell range with at least 4 columns and 4 rows to serve as model to create the new AutoFormat style." +msgstr "" -#. JVW7G +#. 3GsCL #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_id3145384\n" "help.text" -msgid "Choose <item type=\"menuitem\">Edit - Select All</item> or select the formatted range." -msgstr "Aukeratu <item type=\"menuitem\">Editatu - Hautatu dena</item> edo hautatu formatua eman zaion barrutia." - -#. VuwGM -#: autoformat.xhp -msgctxt "" -"autoformat.xhp\n" -"par_id3153815\n" -"help.text" -msgid "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>." -msgstr "Aukeratu <item type=\"menuitem\">Formatua - Autoformatu-estiloak</item>." +msgid "Select the cell range formatted in the previous step and go to <menuitem>Format - AutoFormat Styles</menuitem>." +msgstr "" #. CzaoG #: autoformat.xhp @@ -547,23 +538,32 @@ msgctxt "" msgid "Click <emph>Add</emph>." msgstr "Sakatu <emph>Gehitu</emph>." -#. FDB4v +#. GxXmX #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN10760\n" "help.text" -msgid "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the format." -msgstr "<emph>Gehitu formatua</emph> elkarrizketa-koadroko <emph>Izena</emph> eremuan, idatzi formatuarentzako izena." +msgid "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the new AutoFormat style." +msgstr "" -#. YWSGG +#. pMxn9 #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN107C3\n" "help.text" -msgid "Click <emph>OK</emph>." -msgstr "Egin klik <emph>Ados</emph> botoian." +msgid "Click <emph>OK</emph> and close the dialog." +msgstr "" + +#. HJiDi +#: autoformat.xhp +msgctxt "" +"autoformat.xhp\n" +"par_id51630343134146\n" +"help.text" +msgid "The new AutoFormat styles created using the steps above can be applied to any %PRODUCTNAME Calc file. Hence they are not limited to the file where the style was created." +msgstr "" #. hpPvo #: autoformat.xhp @@ -718,14 +718,14 @@ msgctxt "" msgid "User Defined Borders in Cells" msgstr "Erabiltzaileak definitutako ertzak gelaxketan" -#. GxTZ8 +#. RRraV #: borders.xhp msgctxt "" "borders.xhp\n" "bm_id3457441\n" "help.text" -msgid "<bookmark_value>cells;borders</bookmark_value> <bookmark_value>line arrangements with cells</bookmark_value> <bookmark_value>borders;cells</bookmark_value>" -msgstr "<bookmark_value>gelaxkak;ertzak</bookmark_value> <bookmark_value>lerro-antolamenduak gelaxkekin</bookmark_value> <bookmark_value>ertzak;gelaxkak</bookmark_value>" +msgid "<bookmark_value>cells;borders</bookmark_value> <bookmark_value>line arrangements with cells</bookmark_value> <bookmark_value>borders;cells</bookmark_value>" +msgstr "" #. ajMCN #: borders.xhp @@ -898,15 +898,6 @@ msgctxt "" msgid "<image id=\"img_id8139591\" src=\"media/helpimg/border_ca_4.png\" width=\"1.2602in\" height=\"1.5937in\"><alt id=\"alt_id8139591\">borders with a block selected</alt></image>" msgstr "<image id=\"img_id8139591\" src=\"media/helpimg/border_ca_4.png\" width=\"1.2602in\" height=\"1.5937in\"><alt id=\"alt_id8139591\">ertzak bloke bat hautatuta</alt></image>" -#. j9iat -#: borders.xhp -msgctxt "" -"borders.xhp\n" -"par_id5383465\n" -"help.text" -msgid "You cannot apply borders to multiple selections." -msgstr "Hautapen anizkoitzetan ezin da ertzik aplikatu." - #. 2gKsC #: borders.xhp msgctxt "" @@ -1240,6 +1231,51 @@ msgctxt "" msgid "<image id=\"img_id5380718\" src=\"media/helpimg/border_ca_9.png\" width=\"1.2602in\" height=\"1.1252in\"><alt id=\"alt_id5380718\">advanced example for cell borders</alt></image>" msgstr "<image id=\"img_id5380718\" src=\"media/helpimg/border_ca_9.png\" width=\"1.2602in\" height=\"1.1252in\"><alt id=\"alt_id5380718\">gelaxka-ertzen adibide aurreratua</alt></image>" +#. KKHLH +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"bm_id151630452717743\n" +"help.text" +msgid "<bookmark_value>adjacent cells;remove border</bookmark_value>" +msgstr "" + +#. eEE4F +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"hd_id861630451554176\n" +"help.text" +msgid "Adjacent Cells" +msgstr "" + +#. k8s2o +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"par_id231630451548190\n" +"help.text" +msgid "This option becomes available when formatting a range of cells that already have borders and the new format defined for the range involves removing outer borders." +msgstr "" + +#. xADD4 +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"par_id931630451706604\n" +"help.text" +msgid "By default the option <emph>Remove border</emph> is disabled and the borders at the edges of the selected range are left unchanged. Check this option if the borders at the edge of the selection should be removed." +msgstr "" + +#. V8sNd +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"par_id641630452272324\n" +"help.text" +msgid "If the preset <emph>No Borders</emph> is chosen then the <emph>Remove border</emph> option is enabled." +msgstr "" + #. kCAyU #: calc_date.xhp msgctxt "" @@ -10645,6 +10681,123 @@ msgctxt "" msgid "Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the adjacent column to the right, simply copy this formula to the cell to the right. The copy of the formula in column B will be automatically adjusted to =SUM(B1:B9)." msgstr "Errenkadak eta zutabeak aldatzeaz gain txertatu egiten direnean, edo formula bat beste leku batean kopiatzen denean ere alda daitezke erreferentziak. Adibidez, demagun =SUM(A1:A9) formula sartzen duzula 10. errenkadan. Eskuineko zutabearen (B zutabearen) batura kalkulatu nahi baduzu, kopiatu formula eskuineko gelaxkan. B zutabeko formularen kopia automatikoki egokituko da eta =SUM(B1:B9) bihurtuko." +#. kAFBF +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"tit\n" +"help.text" +msgid "Removing Duplicate Values" +msgstr "" + +#. hGQvA +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"bm_id3153896\n" +"help.text" +msgid "<bookmark_value>filters; removing duplicates</bookmark_value> <bookmark_value>filters; finding unique values</bookmark_value>" +msgstr "" + +#. Q5494 +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"hd_id501630021281902\n" +"help.text" +msgid "<variable id=\"filters\"><link href=\"text/scalc/guide/remove_duplicates.xhp\" name=\"Duplicates_h1\">Removing Duplicate Values</link></variable>" +msgstr "" + +#. ocizx +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id3150869\n" +"help.text" +msgid "Consider a single column with values where some may be duplicates. To remove duplicate values and obtain only the unique entries in the column:" +msgstr "" + +#. omVUk +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id631630021463659\n" +"help.text" +msgid "Select the range of values from which duplicate values are to be removed. The values have to be arranged in a single column." +msgstr "" + +#. XvTTj +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id31630021517873\n" +"help.text" +msgid "Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <embedvar href=\"text/shared/02/12090100.xhp#StandardFilter_h1\"/> dialog." +msgstr "" + +#. EVEzq +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id801630022108301\n" +"help.text" +msgid "In <emph>Field Name</emph> make sure that the selected column is the column where the values are stored. If a single column is selected this field will be set automatically." +msgstr "" + +#. TesFn +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id461630022298515\n" +"help.text" +msgid "In <emph>Condition</emph> choose the option <emph>=</emph> (equals sign), which is the default option." +msgstr "" + +#. nWrGh +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id261630022372414\n" +"help.text" +msgid "In <emph>Value</emph> choose the option <emph>Not Empty</emph>." +msgstr "" + +#. fFZRM +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id441630022436605\n" +"help.text" +msgid "Click <emph>Options</emph> and select <emph>No duplications</emph>. If the first value is the column header check <emph>Range contains column labels</emph>." +msgstr "" + +#. sdBSD +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id841630022924442\n" +"help.text" +msgid "Check <emph>Copy results</emph> and use the input box below it to inform a cell address where the unique entries are to be entered." +msgstr "" + +#. DJcXh +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id61630023053412\n" +"help.text" +msgid "Click <emph>OK</emph>. The unique values in the range will be entered starting with the cell selected in the previous step." +msgstr "" + +#. 3qh4V +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"par_id81630022708336\n" +"help.text" +msgid "The <emph>No duplications</emph> option is case sensitive. Therefore, values \"A\" and \"a\" are each considered as unique values." +msgstr "" + #. cPpmr #: rename_table.xhp msgctxt "" @@ -11428,14 +11581,14 @@ msgctxt "" msgid "<link href=\"text/shared/optionen/01060400.xhp\" name=\"Sort lists\">Sort lists</link>" msgstr "<link href=\"text/shared/optionen/01060400.xhp\" name=\"Sort lists\">Ordenatze-zerrendak</link>" -#. atsHK +#. 6GdiT #: specialfilter.xhp msgctxt "" "specialfilter.xhp\n" "tit\n" "help.text" -msgid "Filter: Applying Advanced Filters" -msgstr "Iragazkia: Iragazki aurreratuak aplikatzea" +msgid "Applying Advanced Filters" +msgstr "" #. Gy5TZ #: specialfilter.xhp @@ -11446,14 +11599,14 @@ msgctxt "" msgid "<bookmark_value>filters;defining advanced filters </bookmark_value><bookmark_value>advanced filters</bookmark_value><bookmark_value>defining; advanced filters</bookmark_value><bookmark_value>database ranges; advanced filters</bookmark_value>" msgstr "<bookmark_value>iragazkiak;iragazki aurreratuak definitu</bookmark_value><bookmark_value>iragazki aurreratuak</bookmark_value><bookmark_value>definitu; iragazki aurreratuak</bookmark_value><bookmark_value>datu-baseen barrutiak; iragazki aurreratuak</bookmark_value>" -#. GS4TQ +#. cjgod #: specialfilter.xhp msgctxt "" "specialfilter.xhp\n" "hd_id3148798\n" "help.text" -msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filter: Applying Advanced Filters</link></variable>" -msgstr "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Iragazkia: Iragazki aurreratuak aplikatzea</link></variable>" +msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Applying Advanced Filters\">Applying Advanced Filters</link></variable>" +msgstr "" #. tYuAi #: specialfilter.xhp @@ -13282,6 +13435,276 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04090000.xhp\" name=\"External data dialog\">External data dialog</link>" msgstr "<link href=\"text/scalc/01/04090000.xhp\" name=\"Kanpoko datuen elkarrizketa-koadroa\">Kanpoko datuen elkarrizketa-koadroa</link>" +#. GnXq4 +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"tit\n" +"help.text" +msgid "Using Wildcards in Formulas" +msgstr "" + +#. EvMSm +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"bm_id3152149\n" +"help.text" +msgid "<bookmark_value>wildcards in calc formulas</bookmark_value> <bookmark_value>wildcards, examples</bookmark_value>" +msgstr "" + +#. 98C5v +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"hd_id941629155075179\n" +"help.text" +msgid "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\" name=\"wildcards_link\">Using Wildcards in Formulas</link></variable>" +msgstr "" + +#. yqMKw +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id571629155308959\n" +"help.text" +msgid "Wildcards are special characters that can be used in search strings that are passed as arguments to some Calc functions. They can also be used to define search criteria in the <emph>Find & Replace</emph> dialog. The use of wildcards enables the definition of more advanced search parameters with a single search string." +msgstr "" + +#. vQrdp +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id391629156224638\n" +"help.text" +msgid "%PRODUCTNAME Calc supports either <emph>wildcards</emph> or <emph>regular expressions</emph> as arguments depending on the current application settings. By default %PRODUCTNAME Calc is set to support wildcards instead of regular expressions." +msgstr "" + +#. DyzLn +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id551629156504794\n" +"help.text" +msgid "To make sure wildcards are supported, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>LibreOffice - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and check if the option <emph>Enable wildcards in formulas</emph> is selected. Note that you can use this dialog to switch to regular expressions by choosing <emph>Enable regular expressions in formulas</emph> or choose to support neither wildcards nor regular expressions." +msgstr "" + +#. BHJzs +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id141629156913731\n" +"help.text" +msgid "The following wildcards are supported:" +msgstr "" + +#. tbbPM +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id801629209195110\n" +"help.text" +msgid "Wildcard" +msgstr "" + +#. 7PmfG +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id861629209212608\n" +"help.text" +msgid "Description" +msgstr "" + +#. DfkJA +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id591629209073388\n" +"help.text" +msgid "<emph>? (question mark)</emph>" +msgstr "" + +#. F2wmk +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id31629209073388\n" +"help.text" +msgid "Matches any single character. For example, the search string \"b?g\" matches “bag” and “beg” but will not match \"boog\" or \"mug\"." +msgstr "" + +#. pi9ik +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id121629209114452\n" +"help.text" +msgid "Note that it will not match \"bg\" as well, since \"?\" must match exactly <emph>one</emph> character. The \"?\" wildcard does not correspond to a zero-character match." +msgstr "" + +#. PmsQL +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id981629209073388\n" +"help.text" +msgid "<emph>* (asterisk)</emph>" +msgstr "" + +#. 6V7SE +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id51629209073388\n" +"help.text" +msgid "Matches any sequence of characters, including an empty string. For example, the search string \"*cast\" will match “cast”, “forecast”, and “outcast”, but will not match \"forecaster\" using default %PRODUCTNAME settings." +msgstr "" + +#. 3gkp8 +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id351629209153307\n" +"help.text" +msgid "If the option <menuitem>Search criteria = and <> must apply to whole cells</menuitem> is disabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>LibreOffice - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>, then \"forecaster\" will be a match using the \"*cast\" search string." +msgstr "" + +#. ek6t7 +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id181629209277556\n" +"help.text" +msgid "<emph>~ (tilde)</emph>" +msgstr "" + +#. F3Tuy +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id881629209280877\n" +"help.text" +msgid "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character." +msgstr "" + +#. P35Fo +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id861629209431020\n" +"help.text" +msgid "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\"." +msgstr "" + +#. aCtpj +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id1001629157561261\n" +"help.text" +msgid "Wildcards are supported in %PRODUCTNAME Calc and in Microsoft Excel. Therefore, if interoperability between both applications is needed, choose to work with wildcards instead of regular expressions. Conversely, if interoperability is not necessary, consider using regular expressions for more powerful search capabilities." +msgstr "" + +#. Dwt2G +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"hd_id671629158766165\n" +"help.text" +msgid "Supported Spreadsheet Functions" +msgstr "" + +#. YF9FB +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id161629158785887\n" +"help.text" +msgid "Wildcards are supported by the following spreadsheet functions:" +msgstr "" + +#. rRPbf +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id441629158810517\n" +"help.text" +msgid "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP." +msgstr "" + +#. gfUGT +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id321629158810916\n" +"help.text" +msgid "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS." +msgstr "" + +#. oUwuB +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id941629158811325\n" +"help.text" +msgid "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP." +msgstr "" + +#. Ka6SK +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id41629158919808\n" +"help.text" +msgid "<emph>Other functions:</emph> MATCH and SEARCH." +msgstr "" + +#. 2ZGuQ +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"hd_id701629159564269\n" +"help.text" +msgid "Examples of Wildcards in Formulas" +msgstr "" + +#. GnADR +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id121629289062103\n" +"help.text" +msgid "The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>LibreOffice - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>." +msgstr "" + +#. znKay +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id271629159111490\n" +"help.text" +msgid "<input>=COUNTIF(A1:A10;\"Chi*\")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with \"Chi\" followed by zero or more characters." +msgstr "" + +#. TPRuA +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id741629159343415\n" +"help.text" +msgid "<input>=SUMIF(A1:A5;\"A??\";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with \"A\" followed by exactly two other characters." +msgstr "" + +#. 7GqMs +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id141629159465592\n" +"help.text" +msgid "Wildcard comparisons are <emph>not</emph> case sensitive, hence \"A?\" will match both \"A1\" and \"a1\"." +msgstr "" + #. ysgCC #: year2000.xhp msgctxt "" |