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.po236
1 files changed, 154 insertions, 82 deletions
diff --git a/source/ca/helpcontent2/source/text/scalc/01.po b/source/ca/helpcontent2/source/text/scalc/01.po
index 7e716700f67..abc3ac6f56e 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: 2020-10-23 13:36+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-08-30 19:35+0000\n"
"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: Catalan <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/ca/>\n"
@@ -12590,13 +12590,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_LOG\">Retorna el logaritme d'un nombre a la base indicada.</ahelp>"
-#. ShWCR
+#. uDAq7
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3144732\n"
"help.text"
-msgid "LOG(Number[; Base])"
+msgid "LOG(Number [; Base])"
msgstr ""
#. Eiqiq
@@ -12842,6 +12842,15 @@ msgctxt ""
msgid "<item type=\"literal\">Base^Exponent</item>"
msgstr "<item type=\"literal\">Base^Exponent</item>"
+#. dRQh7
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id241599040594931\n"
+"help.text"
+msgid "<literal>=POWER(0,0)</literal> returns 1."
+msgstr ""
+
#. D3Ghv
#: 04060106.xhp
msgctxt ""
@@ -13247,13 +13256,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_RUNDEN\">Rounds a number to a certain number of decimal places.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_RUNDEN\">Arrodoneix un nombre a un nombre determinat de xifres decimals.</ahelp>"
-#. p64i9
+#. kj4B7
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3158182\n"
"help.text"
-msgid "ROUND(Number[; Count])"
+msgid "ROUND(Number [; Count])"
msgstr ""
#. yE5Jb
@@ -13346,13 +13355,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Arrodoneix un nombre cap avall, cap a zero, a una precisió determinada.</ahelp>"
-#. uqe8Y
+#. MnKJo
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3146051\n"
"help.text"
-msgid "ROUNDDOWN(Number[; Count])"
+msgid "ROUNDDOWN(Number [; Count])"
msgstr ""
#. EXn4P
@@ -13436,13 +13445,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Arrodoneix un nombre a l'alça, allunyat de zero, amb una precisió determinada.</ahelp>"
-#. smgCC
+#. Gz3SM
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3163328\n"
"help.text"
-msgid "ROUNDUP(Number[; Count])"
+msgid "ROUNDUP(Number [; Count])"
msgstr ""
#. x59Ls
@@ -13913,13 +13922,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value."
msgstr "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Suma les cel·les que s'han indicat segons uns criteris determinats.</ahelp> Aquesta funció s'utilitza per cercar un valor determinat en un interval."
-#. PcPNo
+#. KsFtX
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3152028\n"
"help.text"
-msgid "SUMIF(Range; Criteria[; SumRange])"
+msgid "SUMIF(Range; Criteria [; SumRange])"
msgstr ""
#. rYzXG
@@ -14435,13 +14444,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from Euros.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converteix les antigues monedes nacionals europees en euros, i viceversa.</ahelp>"
-#. qh8S5
+#. G7CMF
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3143748\n"
"help.text"
-msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\"[; full_precision][; triangulation_precision])"
+msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\" [; full_precision [; triangulation_precision]])"
msgstr ""
#. 4KJUc
@@ -14543,14 +14552,14 @@ msgctxt ""
msgid "At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies."
msgstr "Anteriorment, la llista de factors de conversió incloïen les monedes antigues europees i l'euro (vegeu els exemples següents). És recomanable utilitzar la funció nova CONVERSIOEURO per a convertir aquestes monedes."
-#. GhdsH
+#. o7nsC
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902131191\n"
"help.text"
-msgid "CONVERT_OOO(value;\"text\";\"text\")"
-msgstr "CONVERTEIX_OOO(Valor;\"Text\";\"Text\")"
+msgid "CONVERT_OOO(value; \"text\"; \"text\")"
+msgstr ""
#. egbGd
#: 04060106.xhp
@@ -17225,13 +17234,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VARIATION\">Calcula els punts de la tendència exponencial d'una matriu.</ahelp>"
-#. 8VMBq
+#. GMVAK
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3166377\n"
"help.text"
-msgid "GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])"
+msgid "GROWTH(DataY [; [ DataX ] [; [ NewDataX ] [; FunctionType ] ] ])"
msgstr ""
#. CA3qD
@@ -18980,31 +18989,31 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_WAHL\">Utilitza un índex per retornar un valor d'una llista de fins a 30 valors.</ahelp>"
-#. r7bDk
+#. V8cAu
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3155425\n"
"help.text"
-msgid "CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])"
+msgid "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])"
msgstr ""
-#. dt8SY
+#. CNK7e
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3144755\n"
"help.text"
-msgid "<emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list."
-msgstr ""
+msgid "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list."
+msgstr "<emph>Índex</emph> és una referència o un nombre entre 1 i 30 que indica quin valor s'ha d'extreure de la llista."
-#. nR3mX
+#. GGWDt
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149939\n"
"help.text"
-msgid "<emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values."
+msgid "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values."
msgstr ""
#. s64Du
@@ -27962,13 +27971,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VDB\">Retorna la depreciació d'un actiu durant un període indicat o parcial utilitzant un mètode d'amortització variable de saldo decreixent.</ahelp>"
-#. DSd3v
+#. pUVVr
#: 04060118.xhp
msgctxt ""
"04060118.xhp\n"
"par_id3149025\n"
"help.text"
-msgid "VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])"
+msgid "VDB(Cost; Salvage; Life; Start; End [; Factor [; NoSwitch]])"
msgstr ""
#. zGhDb
@@ -42263,6 +42272,15 @@ msgctxt ""
msgid "Name"
msgstr "Nom"
+#. 3juWm
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id401599494815994\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. PcMRq
#: 04060199.xhp
msgctxt ""
@@ -42488,6 +42506,15 @@ msgctxt ""
msgid "Name"
msgstr "Nom"
+#. CCsqC
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599495083374\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. AdNBV
#: 04060199.xhp
msgctxt ""
@@ -42686,6 +42713,15 @@ msgctxt ""
msgid "Name"
msgstr "Nom"
+#. Y4cRR
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599494708332\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. s2CGS
#: 04060199.xhp
msgctxt ""
@@ -42767,6 +42803,15 @@ msgctxt ""
msgid "Name"
msgstr "Nom"
+#. tfD9G
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id521599494740206\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. 52L2C
#: 04060199.xhp
msgctxt ""
@@ -43784,24 +43829,6 @@ msgctxt ""
msgid "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Allows you to specify a variety of formatting options and to apply attributes to the selected cells.</ahelp></variable>"
msgstr "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Us permet indicar diverses opcions de formatació i aplicar atributs a les cel·les seleccionades.</ahelp></variable>"
-#. C3jH9
-#: 05020000.xhp
-msgctxt ""
-"05020000.xhp\n"
-"hd_id3145785\n"
-"help.text"
-msgid "<link href=\"text/shared/01/05020300.xhp\" name=\"Numbers\">Numbers</link>"
-msgstr "<link href=\"text/shared/01/05020300.xhp\" name=\"Nombres\">Nombres</link>"
-
-#. ZgrYD
-#: 05020000.xhp
-msgctxt ""
-"05020000.xhp\n"
-"hd_id3146119\n"
-"help.text"
-msgid "<link href=\"text/shared/01/05020100.xhp\" name=\"Font\">Font</link>"
-msgstr "<link href=\"text/shared/01/05020100.xhp\" name=\"Tipus de lletra\">Tipus de lletra</link>"
-
#. BW9bs
#: 05020600.xhp
msgctxt ""
@@ -44639,6 +44666,15 @@ msgctxt ""
msgid "Page Style"
msgstr "Estil de pàgina"
+#. vEZHA
+#: 05070000.xhp
+msgctxt ""
+"05070000.xhp\n"
+"bm_id651593596384469\n"
+"help.text"
+msgid "<bookmark_value>style;page</bookmark_value><bookmark_value>page;style</bookmark_value><bookmark_value>format;page</bookmark_value><bookmark_value>formatting;page</bookmark_value>"
+msgstr ""
+
#. YjqDi
#: 05070000.xhp
msgctxt ""
@@ -45368,32 +45404,32 @@ msgctxt ""
msgid "<ahelp hid=\".uno:AddPrintArea\">Adds the current selection to the defined print areas.</ahelp>"
msgstr "<ahelp hid=\".uno:AddPrintArea\">Afegeix la selecció actual a les àrees d'impressió definides.</ahelp>"
-#. fcvcu
+#. U9JPr
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"tit\n"
"help.text"
-msgid "Styles"
-msgstr "Estils"
+msgid "Styles in Calc"
+msgstr "Estils al Calc"
-#. 3fyBn
+#. rJpRh
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"bm_id3150447\n"
"help.text"
-msgid "<bookmark_value>Stylist, see Styles window</bookmark_value> <bookmark_value>Styles window</bookmark_value> <bookmark_value>formats; Styles window</bookmark_value> <bookmark_value>formatting; Styles window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
-msgstr "<bookmark_value>estilista, vegeu la finestra Estils</bookmark_value><bookmark_value>finestra Estils</bookmark_value><bookmark_value>formats; finestra Estils</bookmark_value><bookmark_value>formatació; finestra Estils</bookmark_value><bookmark_value>pot de pintura per aplicar estils</bookmark_value>"
+msgid "<bookmark_value>Stylist, see Styles window</bookmark_value><bookmark_value>Styles window</bookmark_value><bookmark_value>formats; Styles window</bookmark_value><bookmark_value>formatting; Styles window</bookmark_value><bookmark_value>paint can for applying styles</bookmark_value><bookmark_value>styles in spreadsheets</bookmark_value><bookmark_value>styles; in Calc</bookmark_value>"
+msgstr ""
-#. eA3vo
+#. WerNG
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"hd_id3150447\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
-msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Estils\">Estils</link>"
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles in Calc</link>"
+msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Estils al Calc</link>"
#. bBG57
#: 05100000.xhp
@@ -45440,23 +45476,14 @@ msgctxt ""
msgid "Double-click the style in the Styles window."
msgstr "Feu doble clic a l'estil a la finestra Estils."
-#. DCJfB
-#: 05100000.xhp
-msgctxt ""
-"05100000.xhp\n"
-"hd_id3153877\n"
-"help.text"
-msgid "Cell Styles"
-msgstr ""
-
-#. DAX9B
+#. SbgEE
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3145801\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
-msgstr "<ahelp hid=\".\">Mostra la llista d'estils de cel·la disponibles per a la <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"formatació indirecta de cel·les\">formatació indirecta de cel·les</link>.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles.</ahelp>"
+msgstr "<ahelp hid=\".\">Mostra la llista dels estils de cel·la disponibles.</ahelp>"
#. JcMEc
#: 05100000.xhp
@@ -45476,23 +45503,23 @@ msgctxt ""
msgid "Cell Styles"
msgstr "Estils de cel·la"
-#. hkDXo
+#. 7FwJf
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
-"hd_id3153963\n"
+"hd_id171593598056580\n"
"help.text"
-msgid "Page Styles"
-msgstr ""
+msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"page styles\">Page Styles</link>"
+msgstr "<link href=\"text/scalc/01/05070000.xhp\" name=\"page styles\">Estils de pàgina</link>"
-#. DxrsL
+#. 4XFww
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3147003\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>"
-msgstr "<ahelp hid=\".\">Mostra els estils de pàgina disponibles per a la formatació indirecta de pàgines.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the Page Styles available.</ahelp>"
+msgstr "<ahelp hid=\".\">Mostra els estils de pàgina disponibles.</ahelp>"
#. cM9f4
#: 05100000.xhp
@@ -52163,6 +52190,15 @@ msgctxt ""
msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
msgstr ""
+#. ZjDq9
+#: 12090106.xhp
+msgctxt ""
+"12090106.xhp\n"
+"par_id681598453957935\n"
+"help.text"
+msgid "Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details\"."
+msgstr ""
+
#. B9FE5
#: 12090200.xhp
msgctxt ""
@@ -53153,6 +53189,15 @@ msgctxt ""
msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
msgstr "Aquesta funció forma part de l'estàndard Open Document Format for Office Applications (OpenDocument), versió 1.2 (ISO/IEC 26300:2-2015)."
+#. BFcB6
+#: ODFF.xhp
+msgctxt ""
+"ODFF.xhp\n"
+"hd_id1000013\n"
+"help.text"
+msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.3."
+msgstr ""
+
#. SGHPh
#: calculate.xhp
msgctxt ""
@@ -53180,6 +53225,24 @@ msgctxt ""
msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>"
msgstr ""
+#. J8xZD
+#: cell_styles.xhp
+msgctxt ""
+"cell_styles.xhp\n"
+"tit\n"
+"help.text"
+msgid "Cell Styles"
+msgstr "Estils de cel·les"
+
+#. 8o4Ez
+#: cell_styles.xhp
+msgctxt ""
+"cell_styles.xhp\n"
+"hd_id811593560413206\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/cell_styles.xhp\" name=\"Cell Style\">Cell Styles</link>"
+msgstr "<link href=\"text/scalc/01/cell_styles.xhp\" name=\"Cell Style\">Estils de cel·les</link>"
+
#. AZNrM
#: common_func.xhp
msgctxt ""
@@ -54530,6 +54593,15 @@ msgctxt ""
msgid "<emph>Reference 1, Reference 2, … ,Reference 255</emph> are references to cells."
msgstr ""
+#. 4BGvn
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id1001601332672155\n"
+"help.text"
+msgid "This function is always recalculated whenever a recalculation occurs."
+msgstr ""
+
#. 8DbP2
#: func_aggregate.xhp
msgctxt ""
@@ -55169,15 +55241,6 @@ msgctxt ""
msgid "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error."
msgstr ""
-#. HSE9d
-#: func_averageif.xhp
-msgctxt ""
-"func_averageif.xhp\n"
-"par_id38832436828097\n"
-"help.text"
-msgid "In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text."
-msgstr ""
-
#. u7E4B
#: func_averageif.xhp
msgctxt ""
@@ -64367,6 +64430,15 @@ msgctxt ""
msgid "Calculation"
msgstr "Càlcul"
+#. Q8ewH
+#: func_yearfrac.xhp
+msgctxt ""
+"func_yearfrac.xhp\n"
+"par_id3154502\n"
+"help.text"
+msgid "0 or missing"
+msgstr ""
+
#. CkPny
#: func_yearfrac.xhp
msgctxt ""