aboutsummaryrefslogtreecommitdiff
path: root/source/pt-BR/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/pt-BR/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/pt-BR/helpcontent2/source/text/scalc/01.po320
1 files changed, 187 insertions, 133 deletions
diff --git a/source/pt-BR/helpcontent2/source/text/scalc/01.po b/source/pt-BR/helpcontent2/source/text/scalc/01.po
index 67dc6c01a1a..f18c9413f32 100644
--- a/source/pt-BR/helpcontent2/source/text/scalc/01.po
+++ b/source/pt-BR/helpcontent2/source/text/scalc/01.po
@@ -3,9 +3,9 @@ msgid ""
msgstr ""
"Project-Id-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"
-"PO-Revision-Date: 2021-11-18 15:37+0000\n"
-"Last-Translator: Olivier Hallot <olivier.hallot@libreoffice.org>\n"
+"POT-Creation-Date: 2021-11-25 19:33+0100\n"
+"PO-Revision-Date: 2021-11-25 16:38+0000\n"
+"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: Portuguese (Brazil) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/pt_BR/>\n"
"Language: pt-BR\n"
"MIME-Version: 1.0\n"
@@ -19006,14 +19006,14 @@ 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 "Se Tipo = 0, somente valores exatos existentes serão encontrados. Se o critério de pesquisa for encontrado mais de uma vez, a função retorna o índice do primeiro valor encontrado. Somente quando Tipo = 0 é que se pode procurar por expressões regulares ou caracteres curinga (se ativados nas opções de cálculo)."
-#. 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."
-msgstr "Se Tipo = 1 ou o terceiro parâmetro for omitido, o índice do último valor que for menor ou igual ao critério de pesquisa será retornado. Para Tipo = -1, o primeiro valor que for maior ou igual será retornado."
+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
#: 04060109.xhp
@@ -20212,69 +20212,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 "Esteja ciente de que a função de Autocorreção do Calc pode modificar aspas duplas. A Autocorreção não deve alterar as aspas duplas nas células de fórmula, mas pode alterar aquelas usadas em células sem fórmula que contenham texto. Por exemplo, se você copiar um texto que está rodeado por alguma outra forma de aspas duplas tipográficas, como as aspas duplas à esquerda (U+201C) e as aspas duplas à direita (U+201D) e, em seguida, colar em um célula da fórmula, pode ocorrer um erro. Abra a área <emph>Aspas duplas</emph> da caixa de diálogo <menuitem>Ferramentas - Opções de autocorreção - Opções do local </menuitem> para definir os caracteres usados para corrigir automaticamente o início e o fim das aspas tipográficas. Desmarque a caixa de seleção <menuitem> Substituir</menuitem> para desativar o recurso."
-#. teACB
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"bm_id8796349\n"
-"help.text"
-msgid "<bookmark_value>ASC function</bookmark_value>"
-msgstr "<bookmark_value>função 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=\".\">A função ASC converte caracteres ASCII e katakana de largura inteira para meia largura. Retorna um texto.</ahelp>"
-
-#. bYBvS
-#: 04060110.xhp
-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 "Consulte <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> para ver a tabela de conversões."
-
-#. rvCFy
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id1993774\n"
-"help.text"
-msgid "ASC(\"Text\")"
-msgstr "ASC(\"Texto\")"
-
-#. 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>Texto</emph> é o texto que contém os caracteres a converter."
-
-#. bDFBi
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id2355113\n"
-"help.text"
-msgid "See also JIS function."
-msgstr "Veja também a função JIS."
-
#. rdzbS
#: 04060110.xhp
msgctxt ""
@@ -21103,69 +21040,6 @@ msgctxt ""
msgid "<item type=\"input\">=FIXED(12345.789;8/5)</item> returns 12,345.8 as a text string."
msgstr "<item type=\"input\">=DEF.NÚM.DEC(123456,789;8/5)</item> retorna 12.345,8 como um texto."
-#. zxsGX
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"bm_id7319864\n"
-"help.text"
-msgid "<bookmark_value>JIS function</bookmark_value>"
-msgstr "<bookmark_value>função 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=\".\">A função JIS converte caracteres ASCII e katakana de meia largura para largura inteira. Retorna um texto.</ahelp>"
-
-#. BRYCA
-#: 04060110.xhp
-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 "Consulte <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> para ver a tabela de conversões."
-
-#. rDaAZ
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id2504654\n"
-"help.text"
-msgid "JIS(\"Text\")"
-msgstr "JIS(\"Texto\")"
-
-#. 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>Texto</emph> é o texto que contém os caracteres a converter."
-
-#. UXRGt
-#: 04060110.xhp
-msgctxt ""
-"04060110.xhp\n"
-"par_id3984496\n"
-"help.text"
-msgid "See also ASC function."
-msgstr "Veja também a função ASC."
-
#. SaBEW
#: 04060110.xhp
msgctxt ""
@@ -55771,6 +55645,96 @@ msgctxt ""
msgid "<input>=ARABIC(\"\")</input> returns 0."
msgstr "<input>=ÁRABE(\"\")</input> retorna 0."
+#. 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 ""
@@ -62530,6 +62494,96 @@ msgctxt ""
msgid "<item type=\"input\">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04."
msgstr "<item type=\"input\">=NUMSEMANAISO(DATA(1999;1;1))</item> retorna 53. A semana 1 começa na segunda-feira 4 de janeiro de 1999."
+#. 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
msgctxt ""
@@ -64985,7 +65039,7 @@ msgctxt ""
"par_id3151756\n"
"help.text"
msgid "A formula such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be entered as an <link href=\"text/scalc/01/04060107.html#hd_id3148474\" name=\"ARRAY_FORMULA\">array formula</link> by pressing the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum."
-msgstr "Uma fórmula tal como <input>=SOMA((A1: A40>=C1)*(A1: A40<C2)*B1: B40)</input> pode ser inserida como uma <link href=\"text/scalc/01/04060107.html#hd_id3148474 \"name=\"ARRAY_FORMULA\">fórmula de matriz</link> pressionando as teclas Shift<switchinline select =\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+ Enter em vez de simplesmente pressionar a tecla Enter para terminar de inserir a fórmula. A fórmula será então mostrada na barra de Fórmula entre colchetes e opera multiplicando os elementos correspondentes das matrizes e retornando sua soma."
+msgstr "Uma fórmula tal como <input>=SOMA((A1: A40>=C1)*(A1: A40<C2)*B1: B40)</input> pode ser inserida como uma <link href=\"text/scalc/01/04060107.html#hd_id3148474\" name=\"ARRAY_FORMULA\">fórmula de matriz</link> pressionando as teclas Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+ Enter em vez de simplesmente pressionar a tecla Enter para terminar de inserir a fórmula. A fórmula será então mostrada na barra de Fórmula entre colchetes e opera multiplicando os elementos correspondentes das matrizes e retornando sua soma."
#. FWxB2
#: func_sum.xhp