aboutsummaryrefslogtreecommitdiff
path: root/source/ca/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/ca/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/ca/helpcontent2/source/text/scalc/01.po314
1 files changed, 183 insertions, 131 deletions
diff --git a/source/ca/helpcontent2/source/text/scalc/01.po b/source/ca/helpcontent2/source/text/scalc/01.po
index 5e55d7804bb..3a7183ab550 100644
--- a/source/ca/helpcontent2/source/text/scalc/01.po
+++ b/source/ca/helpcontent2/source/text/scalc/01.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-11-19 15:43+0100\n"
+"POT-Creation-Date: 2021-11-25 19:33+0100\n"
"PO-Revision-Date: 2021-11-08 14:36+0000\n"
"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/ca/>\n"
@@ -19092,13 +19092,13 @@ msgctxt ""
msgid "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)."
msgstr "Si Tipus = 0 només es troben coincidències exactes. Si el criteri de cerca es troba més d'una vegada la funció retorna l'índex del primer valor coincident. Només si Tipus = 0 podeu cercar expressions regulars (si està habilitat en opcions de càlcul) o comodins (si està habilitat en opcions de càlcul)."
-#. t3Ems
+#. vCFkE
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3147528\n"
"help.text"
-msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the first value that is larger or equal is returned."
+msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the index of the last value that is larger or equal is returned."
msgstr ""
#. eFMjk
@@ -20308,70 +20308,6 @@ msgctxt ""
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 ""
-#. teACB
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"bm_id8796349\n"
-"help.text"
-msgid "<bookmark_value>ASC function</bookmark_value>"
-msgstr "<bookmark_value>funció ASC</bookmark_value>"
-
-#. Fm36F
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"hd_id7723929\n"
-"help.text"
-msgid "ASC"
-msgstr "ASC"
-
-#. AevxV
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id8455153\n"
-"help.text"
-msgid "<ahelp hid=\".\">The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string.</ahelp>"
-msgstr "<ahelp hid=\".\">La funció ASC converteix caràcters ASCII d'amplada completa a caràcters de mitja amplada i caràcters katakana. Retorna una cadena de text.</ahelp>"
-
-#. bYBvS
-#: 04060110.xhp
-#, fuzzy
-msgctxt ""
-"04060110.xhp\n"
-"par_id9912411\n"
-"help.text"
-msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
-msgstr "Vegeu <link href=\"https//wiki.documentfoundation.org/Calc/Features/JISandASCfunctions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https//wiki.documentfoundation.org/Calc/Features/JISandaSCfunctions</link> per a una taula de conversió."
-
-#. rvCFy
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id1993774\n"
-"help.text"
-msgid "ASC(\"Text\")"
-msgstr "ASC(\"Text\")"
-
-#. V8Nfv
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id2949919\n"
-"help.text"
-msgid "<emph>Text</emph> is the text that contains characters to be converted."
-msgstr "<emph>Text</emph> és el text que conté els caràcters que s'han de convertir."
-
-#. bDFBi
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id2355113\n"
-"help.text"
-msgid "See also JIS function."
-msgstr "Vegeu també la funció JIS."
-
#. rdzbS
#: 04060110.xhp
msgctxt ""
@@ -21204,70 +21140,6 @@ msgctxt ""
msgid "<item type=\"input\">=FIXED(12345.789;8/5)</item> returns 12,345.8 as a text string."
msgstr ""
-#. zxsGX
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"bm_id7319864\n"
-"help.text"
-msgid "<bookmark_value>JIS function</bookmark_value>"
-msgstr "<bookmark_value>funció JIS</bookmark_value>"
-
-#. NdCJa
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"hd_id3666188\n"
-"help.text"
-msgid "JIS"
-msgstr "JIS"
-
-#. ETFXy
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id964384\n"
-"help.text"
-msgid "<ahelp hid=\".\">The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string.</ahelp>"
-msgstr "<ahelp hid=\".\">La funció JIS converteix caràcters ASCII i katakana de mitja amplada a caràcters d'amplada completa. Retorna una cadena de text.</ahelp>"
-
-#. BRYCA
-#: 04060110.xhp
-#, fuzzy
-msgctxt ""
-"04060110.xhp\n"
-"par_id1551561\n"
-"help.text"
-msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
-msgstr "Vegeu <link href=\"https//wiki.documentfoundation.org/Calc/Features/JISandASCfunctions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https//wiki.documentfoundation.org/Calc/Features/JISandaSCfunctions</link> per a una taula de conversió."
-
-#. rDaAZ
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id2504654\n"
-"help.text"
-msgid "JIS(\"Text\")"
-msgstr "JIS(\"Text\")"
-
-#. y9PC3
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id5292519\n"
-"help.text"
-msgid "<emph>Text</emph> is the text that contains characters to be converted."
-msgstr "<emph>Text</emph> és el text que conté els caràcters que s'han de convertir."
-
-#. UXRGt
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id3984496\n"
-"help.text"
-msgid "See also ASC function."
-msgstr "Vegeu també la funció ASC."
-
#. SaBEW
#: 04060110.xhp
msgctxt ""
@@ -56279,6 +56151,96 @@ msgctxt ""
msgid "<input>=ARABIC(\"\")</input> returns 0."
msgstr ""
+#. yugTC
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"tit\n"
+"help.text"
+msgid "ASC Function"
+msgstr ""
+
+#. H3kmF
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"bm_id831542233029549\n"
+"help.text"
+msgid "<bookmark_value>ASC function</bookmark_value> <bookmark_value>text functions;katakana characters</bookmark_value>"
+msgstr ""
+
+#. 5sWTB
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"hd_id881628776094597\n"
+"help.text"
+msgid "<variable id=\"Asc_h1\"><link href=\"text/scalc/01/func_asc.xhp\" name=\"function ASC\">ASC</link></variable>"
+msgstr ""
+
+#. gtGVG
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id541542230672101\n"
+"help.text"
+msgid "<variable id=\"func_asc_desc\"><ahelp hid=\".\">Converts double-byte (full-width) characters to single-byte (half-width) ASCII and katakana characters.</ahelp></variable>"
+msgstr ""
+
+#. zwX68
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id151634221012221\n"
+"help.text"
+msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
+msgstr ""
+
+#. nWQan
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id701542231253817\n"
+"help.text"
+msgid "<input>ASC(Text)</input>"
+msgstr ""
+
+#. npFEH
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id621542232197446\n"
+"help.text"
+msgid "<emph>Text</emph>: the text string that contains characters to be converted."
+msgstr ""
+
+#. d9fM4
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id481637763523789\n"
+"help.text"
+msgid "Applying the ASC function to a string composed of single-byte characters will return the input string without any modifications."
+msgstr ""
+
+#. QXBHB
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id451628776707264\n"
+"help.text"
+msgid "<input>=ASC(\"LibreOffice\")</input> returns the string \"LibreOffice\". No modifications were made because all characters are single-byte characters."
+msgstr ""
+
+#. f8rff
+#: func_asc.xhp
+msgctxt ""
+"func_asc.xhp\n"
+"par_id101628778036375\n"
+"help.text"
+msgid "<input>=ASC(\"ライト\")</input> returns the string \"ライト\", which is composed of single-byte characters."
+msgstr ""
+
#. y9q7t
#: func_averageif.xhp
msgctxt ""
@@ -63333,6 +63295,96 @@ msgctxt ""
msgid "<item type=\"input\">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04."
msgstr "<unk>GA =NUMSETMANAISO(DATA(1999;1;1))</item> retorna 53. La setmana 1 comença el dilluns 1999-01-04."
+#. CB8Vn
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"tit\n"
+"help.text"
+msgid "JIS Function"
+msgstr ""
+
+#. 5Qavf
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"bm_id831542233029549\n"
+"help.text"
+msgid "<bookmark_value>JIS function</bookmark_value>"
+msgstr ""
+
+#. MEYJo
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"hd_id881628776094597\n"
+"help.text"
+msgid "<variable id=\"Jis_h1\"><link href=\"text/scalc/01/func_jis.xhp\" name=\"function JIS\">JIS</link></variable>"
+msgstr ""
+
+#. 3XKQ3
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id541542230672101\n"
+"help.text"
+msgid "<variable id=\"func_jis_desc\"><ahelp hid=\".\">Converts single-byte (half-width) ASCII or katakana characters to double-byte (full-width) characters.</ahelp></variable>"
+msgstr ""
+
+#. UdHVW
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id151634221012221\n"
+"help.text"
+msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
+msgstr ""
+
+#. AjjnX
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id701542231253817\n"
+"help.text"
+msgid "<input>JIS(Text)</input>"
+msgstr ""
+
+#. f9YAh
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id621542232197446\n"
+"help.text"
+msgid "<emph>Text</emph>: the text string that contains characters to be converted."
+msgstr ""
+
+#. b289j
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id481637763523789\n"
+"help.text"
+msgid "Applying the JIS function to a string composed of double-byte characters will return the input string without any modifications."
+msgstr ""
+
+#. BBEVj
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id451628776707264\n"
+"help.text"
+msgid "<input>=JIS(\"LibreOffice\")</input> returns the string \"LibreOffice\". Note that the returned string uses double-byte characters."
+msgstr ""
+
+#. fEFNT
+#: func_jis.xhp
+msgctxt ""
+"func_jis.xhp\n"
+"par_id101628778036375\n"
+"help.text"
+msgid "<input>=JIS(\"ライト\")</input> returns the string \"ライト\", which is composed of double-byte characters."
+msgstr ""
+
#. Cauxq
#: func_maxifs.xhp
#, fuzzy