diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2020-04-15 14:08:14 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2020-04-15 14:12:29 +0200 |
| commit | 1cf550347fdb87391903b533dd1c47135875a9d7 (patch) | |
| tree | 42aeb67f0d164abb01f73d6ddc7c1d8927a253a3 /source/ca-valencia/helpcontent2 | |
| parent | 0a73e51795ef412006c59d3723f265fed445dea1 (diff) | |
update translations for master
and force-fix errors using pocheck
Change-Id: I9f37f1bad2c1005d8b63991fb1a66cd2f14e259b
Diffstat (limited to 'source/ca-valencia/helpcontent2')
3 files changed, 1384 insertions, 907 deletions
diff --git a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po b/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po index 069c2f4ef2c..aadd9b007fd 100644 --- a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po +++ b/source/ca-valencia/helpcontent2/source/text/sbasic/shared.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-04-03 11:46+0200\n" +"POT-Creation-Date: 2020-04-15 12:52+0200\n" "PO-Revision-Date: 2018-10-21 20:06+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -2789,15 +2789,6 @@ msgctxt "" msgid "The <literal>Function</literal> is called using the following syntax:" msgstr "" -#. yBxwK -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3146914\n" -"help.text" -msgid "Variable=FunctionName(Parameter1, Parameter2,...)" -msgstr "Variable=FunctionName(Parameter1, Parameter2,...)" - #. 33Sss #: 01020300.xhp msgctxt "" @@ -2870,15 +2861,6 @@ msgctxt "" msgid "If you want to pass a parameter by value insert the key word <literal>ByVal</literal> in front of the parameter when you call a <literal>Sub</literal>, a <literal>Function</literal> or a <literal>Property</literal>, for example:" msgstr "" -#. Vzu4F -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3150042\n" -"help.text" -msgid "Function ReadOnlyParms(ByVal p2, ByVal p2)" -msgstr "" - #. pojXe #: 01020300.xhp msgctxt "" @@ -2888,24 +2870,6 @@ msgctxt "" msgid "' your code goes here" msgstr "" -#. MGPNc -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"bas_id131584367516784\n" -"help.text" -msgid "End Function" -msgstr "" - -#. bz6EJ -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"bas_id801584367475787\n" -"help.text" -msgid "result = ReadOnlyParms(parm1, parm2)" -msgstr "" - #. WF4ND #: 01020300.xhp msgctxt "" @@ -2933,15 +2897,6 @@ msgctxt "" msgid "Functions, procedures or properties can be defined with optional parameters, for example:" msgstr "" -#. qBTxH -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"bas_id761584366669997\n" -"help.text" -msgid "Sub Rounding(number, Optional decimals, Optional format)" -msgstr "" - #. JKj8y #: 01020300.xhp msgctxt "" @@ -2951,15 +2906,6 @@ msgctxt "" msgid "' your code goes here" msgstr "" -#. NtvTc -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"bas_id251584366745722\n" -"help.text" -msgid "End Sub" -msgstr "" - #. EHCCS #: 01020300.xhp msgctxt "" @@ -2987,15 +2933,6 @@ msgctxt "" msgid "Declaring Variables Outside a <literal>Sub</literal> a <literal>Function</literal> or a <literal>Property</literal>" msgstr "" -#. Q3jEW -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3150208\n" -"help.text" -msgid "Global VarName As TYPENAME" -msgstr "Global VarName As TYPENAME" - #. 5JwAY #: 01020300.xhp msgctxt "" @@ -3005,15 +2942,6 @@ msgctxt "" msgid "The variable is valid as long as the %PRODUCTNAME session lasts." msgstr "" -#. CSDs2 -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3153198\n" -"help.text" -msgid "Public VarName As TYPENAME" -msgstr "Public VarName As TYPENAME" - #. 9akEs #: 01020300.xhp msgctxt "" @@ -3023,15 +2951,6 @@ msgctxt "" msgid "The variable is valid in all modules." msgstr "La variable és vàlida a tots els mòduls." -#. ADEKE -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3158212\n" -"help.text" -msgid "Private VarName As TYPENAME" -msgstr "Private VarName As TYPENAME" - #. qeJQx #: 01020300.xhp msgctxt "" @@ -3041,15 +2960,6 @@ msgctxt "" msgid "The variable is only valid in this module." msgstr "La variable només és vàlida en este mòdul." -#. WQdbC -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3150886\n" -"help.text" -msgid "Dim VarName As TYPENAME" -msgstr "Dim VarName As TYPENAME" - #. 85TYe #: 01020300.xhp msgctxt "" @@ -3131,15 +3041,6 @@ msgctxt "" msgid "Saving Variable Content after Exiting a <literal>Sub</literal> a <literal>Function</literal> or a <literal>Property</literal>" msgstr "" -#. qV9Bm -#: 01020300.xhp -msgctxt "" -"01020300.xhp\n" -"par_id3156288\n" -"help.text" -msgid "Static VarName As TYPENAME" -msgstr "Static VarName As TYPENAME" - #. hAB34 #: 01020300.xhp msgctxt "" @@ -17513,32 +17414,32 @@ msgctxt "" msgid "Error-Handling Functions" msgstr "Funcions de gestió d'errors" -#. zqvGA +#. yMyAz #: 03050000.xhp msgctxt "" "03050000.xhp\n" "hd_id3143271\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link>" -msgstr "<link href=\"text/sbasic/shared/03050000.xhp\" name=\"Funcions de gestió d'errors\">Funcions de gestió d'errors</link>" +msgid "<variable id=\"ErrHandlingh1\"><link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link></variable>" +msgstr "" -#. BfMGz +#. KsiEx #: 03050000.xhp msgctxt "" "03050000.xhp\n" "par_id3145068\n" "help.text" -msgid "Use the following statements and functions to define the way $[officename] Basic reacts to run-time errors." -msgstr "Utilitzeu les expressions i les funcions següents per definir la forma en què el $[officename] Basic reacciona als errors d'execució." +msgid "Use the following statements and functions to define the way %PRODUCTNAME Basic reacts to run-time errors." +msgstr "" -#. acGyE +#. 9XGsZ #: 03050000.xhp msgctxt "" "03050000.xhp\n" "par_id3148946\n" "help.text" -msgid "$[officename] Basic offers several methods to prevent the termination of a program when a run-time error occurs." -msgstr "El $[officename] Basic ofereix diversos mètodes per evitar la finalització d'un programa quan es produeix un error d'execució." +msgid "%PRODUCTNAME Basic offers several methods to prevent the termination of a program when a run-time error occurs." +msgstr "" #. C2vFE #: 03050100.xhp @@ -17945,6 +17846,15 @@ msgctxt "" msgid "Syntax:" msgstr "Sintaxi:" +#. fGsdv +#: 03050500.xhp +msgctxt "" +"03050500.xhp\n" +"par_id491585753339474\n" +"help.text" +msgid "<image src=\"media/helpimg/sbasic/On-Error_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">On Error Statement diagram</alt></image>" +msgstr "" + #. 7FXhq #: 03050500.xhp msgctxt "" @@ -22994,14 +22904,14 @@ msgctxt "" msgid "For...Next Statement" msgstr "" -#. YGeU7 +#. Byex6 #: 03090202.xhp msgctxt "" "03090202.xhp\n" "bm_id3149205\n" "help.text" -msgid "<bookmark_value>For statement</bookmark_value> <bookmark_value>To statement</bookmark_value> <bookmark_value>Step statement</bookmark_value> <bookmark_value>Next statement</bookmark_value>" -msgstr "<bookmark_value>expressió For</bookmark_value> <bookmark_value>expressió To</bookmark_value> <bookmark_value>expressió Step</bookmark_value> <bookmark_value>expressió Next</bookmark_value>" +msgid "<bookmark_value>For statement</bookmark_value> <bookmark_value>For Each statement</bookmark_value> <bookmark_value>In keyword</bookmark_value> <bookmark_value>Next keyword</bookmark_value> <bookmark_value>Step keyword</bookmark_value> <bookmark_value>To keyword</bookmark_value> <bookmark_value>Step keyword</bookmark_value>" +msgstr "" #. LVP76 #: 03090202.xhp @@ -23012,14 +22922,14 @@ msgctxt "" msgid "<link href=\"text/sbasic/shared/03090202.xhp\" name=\"For...Next Statement\">For...Next Statement</link>" msgstr "" -#. P6gje +#. AFEvH #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3143267\n" "help.text" -msgid "Repeats the statements between the For...Next block a specified number of times." -msgstr "Repeteix les expressions entre el bloc For..Next un número especificat de vegades." +msgid "Repeats the statements between the <literal>For...Next</literal> block a specified number of times." +msgstr "" #. h79GC #: 03090202.xhp @@ -23030,50 +22940,59 @@ msgctxt "" msgid "Syntax:" msgstr "Sintaxi:" -#. 7GuT6 +#. UqJyC #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3148473\n" +"par_id491585753339474\n" "help.text" -msgid "For counter=start To end [Step step]" -msgstr "For counter=start To end [Step step]" +msgid "<image src=\"media/helpimg/sbasic/For-Next_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">For Statement diagram</alt></image>" +msgstr "" -#. Qn7bF +#. SuZFA #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3156024\n" "help.text" -msgid "statement block" -msgstr "bloc d'expressió" +msgid "statement-block" +msgstr "" -#. 5H2nw +#. CCuTr #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3146796\n" +"par_id3159414\n" "help.text" -msgid "[Exit For]" -msgstr "[Exit For]" +msgid "statement-block" +msgstr "" -#. oPL7W +#. bcKDQ #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3159414\n" +"par_id491585653339474\n" "help.text" -msgid "statement block" -msgstr "bloc d'expressió" +msgid "<image src=\"media/helpimg/sbasic/For-Each_statement.svg\" id=\"img_id4156297484514\"><alt id=\"alt_id15152797484514\">For Each Statement diagram</alt></image>" +msgstr "" -#. 7DuFn +#. YbrKJ #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3153897\n" +"bas_id821586521234861\n" "help.text" -msgid "Next [counter]" -msgstr "Next [counter]" +msgid "statement-block" +msgstr "" + +#. 75jXr +#: 03090202.xhp +msgctxt "" +"03090202.xhp\n" +"bas_id501586521235517\n" +"help.text" +msgid "statement-block" +msgstr "" #. hE24y #: 03090202.xhp @@ -23084,41 +23003,41 @@ msgctxt "" msgid "Variables:" msgstr "Variables:" -#. H4t3c +#. iPLzw #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3150358\n" "help.text" -msgid "<emph>Counter:</emph> Loop counter initially assigned the value to the right of the equal sign (start). Only numeric variables are valid. The loop counter increases or decreases according to the variable Step until End is passed." -msgstr "<emph>Counter:</emph> El comptador de bucle inicialment assignat al valor de la dreta del signe igual (inici). Només són vàlides les variables numèriques. El comptador de bucle augmenta o disminueix segons la variable Step fins que passa End." +msgid "<emph>counter:</emph> Loop <literal>counter</literal> initially assigned the value to the right of the equal sign (<literal>start</literal>). Only numeric variables are valid. The loop counter increases or decreases according to the variable <literal>step</literal> until <literal>end</literal> is passed." +msgstr "" -#. PBGU7 +#. crpJL #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3152455\n" "help.text" -msgid "<emph>Start:</emph> Numeric variable that defines the initial value at the beginning of the loop." -msgstr "<emph>Start:</emph> Variable numèrica que defineix el valor inicial al principi del bucle." +msgid "<emph>start:</emph> Numeric variable that defines the initial value at the beginning of the loop." +msgstr "" -#. B53Sh +#. u8ZEL #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3151043\n" "help.text" -msgid "<emph>End:</emph> Numeric variable that defines the final value at the end of the loop." -msgstr "<emph>End:</emph> Variable numèrica que defineix el valor final al final del bucle." +msgid "<emph>end:</emph> Numeric variable that defines the final value at the end of the loop." +msgstr "" -#. RN6Cp +#. TmxSC #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3156281\n" "help.text" -msgid "<emph>Step:</emph> Sets the value by which to increase or decrease the loop counter. If Step is not specified, the loop counter is incremented by 1. In this case, End must be greater than Start. If you want to decrease Counter, End must be less than Start, and Step must be assigned a negative value." -msgstr "<emph>Step:</emph> Defineix el valor pel qual cal incrementar o reduir el comptador de bucles. Si no s'especifica Step, el comptador de bucles s'incrementa per 1. En este cas, End ha de ser superior a Start. Si voleu reduir el comptador, End ha de fer inferior a Start, i s'ha d'assignar un valor negatiu a Step." +msgid "<emph>step:</emph> Sets the value by which to increase or decrease the loop counter. If <literal>step</literal> is not specified, the loop counter is incremented by 1. In this case, <literal>end</literal> must be greater than <literal>start</literal>. If you want to decrease <literal>counter</literal>, <literal>end</literal> must be less than <literal>start</literal>, and <literal>step</literal> must be assigned a negative value." +msgstr "" #. VMWd9 #: 03090202.xhp @@ -23129,14 +23048,14 @@ msgctxt "" msgid "The <emph>For...Next</emph> loop repeats all of the statements in the loop for the number of times that is specified by the parameters." msgstr "El bucle <emph>For...Next</emph> repeteix totes les expressions del bucle per al nombre de vegades que s'especifica als paràmetres." -#. MzbXT +#. 6pQ2G #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3147287\n" "help.text" -msgid "As the counter variable is decreased, $[officename] Basic checks if the end value has been reached. As soon as the counter passes the end value, the loop automatically ends." -msgstr "A mesura que la variable de comptador disminueix, el $[officename] Basic comprova si s'ha assolit el valor final. Tan prompte com el comptador passa el valor final, el bucle finalitza automàticament." +msgid "As the <literal>counter</literal> variable is decreased, %PRODUCTNAME Basic checks if the <literal>end</literal> value has been reached. As soon as the <literal>counter</literal> passes the <literal>end</literal> value, the loop automatically terminates." +msgstr "" #. hFEyc #: 03090202.xhp @@ -23156,14 +23075,14 @@ msgctxt "" msgid "If you specify an increment of 0, the statements between <emph>For</emph> and <emph>Next</emph> are repeated continuously." msgstr "Si especifiqueu un increment de 0, les expressions entre <emph>For</emph> i <emph>Next</emph> es repeteixen contínuament." -#. wMUFA +#. Xxfcy #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3155854\n" "help.text" -msgid "When counting down the counter variable, $[officename] Basic checks for overflow or underflow. The loop ends when Counter exceeds End (positive Step value) or is less than End (negative Step value)." -msgstr "En comptar arrere la variable de comptador, el $[officename] Basic comprova el desbordament o el valor inferior al desbordament. El bucle acaba quan el comptador supera End (valor de Step positiu) o és inferior a End valor de Step negatiu)." +msgid "When counting down the counter variable, %PRODUCTNAME Basic checks for overflow or underflow. The loop ends when <literal>counter</literal> exceeds <literal>end</literal> (positive Step value) or is less than <literal>end</literal> (negative Step value)." +msgstr "" #. DNpBx #: 03090202.xhp @@ -23174,167 +23093,113 @@ msgctxt "" msgid "Use the <emph>Exit For</emph> statement to exit the loop unconditionally. This statement must be within a <emph>For...Next</emph> loop. Use the <emph>If...Then</emph> statement to test the exit condition as follows:" msgstr "Utilitzeu l'expressió <emph>Exit For</emph> per eixir incondicionalment del bucle. Esta expressió ha d'estar a dins d'un bucle <emph>For...Next</emph>. Utilitzeu l'expressió <emph>If...Then</emph> per provar la condició de eixida de la forma següent:" -#. vYTyG +#. M36BA #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3153190\n" +"bas_id621586522583437\n" "help.text" -msgid "For..." -msgstr "Per a..." - -#. AeEhE -#: 03090202.xhp -msgctxt "" -"03090202.xhp\n" -"par_id3149482\n" -"help.text" -msgid "statements" -msgstr "expressions" - -#. qvVwR -#: 03090202.xhp -msgctxt "" -"03090202.xhp\n" -"par_id3147124\n" -"help.text" -msgid "If condition = True Then Exit For" -msgstr "If condition = True Then Exit For" - -#. FuKCd -#: 03090202.xhp -msgctxt "" -"03090202.xhp\n" -"par_id3153159\n" -"help.text" -msgid "statements" -msgstr "expressions" +msgid "statement-block" +msgstr "" -#. LoD97 +#. k56rG #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3154096\n" +"bas_id711586522584013\n" "help.text" -msgid "Next" -msgstr "Següent" +msgid "statement-block" +msgstr "" -#. KfKRR +#. C2e3R #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3156286\n" "help.text" -msgid "Note: In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited." -msgstr "Nota: En bucles <emph>For...Next</emph> imbricats, si eixiu d'un bucle incondicionalment amb <emph>Exit For</emph>, només se ix d'un bucle." +msgid "In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited." +msgstr "" -#. McR4Z +#. Xo6Nj #: 03090202.xhp msgctxt "" "03090202.xhp\n" "hd_id3148457\n" "help.text" -msgid "Example" -msgstr "Exemple" +msgid "Examples" +msgstr "" -#. 3hXfC +#. mdCY2 #: 03090202.xhp msgctxt "" "03090202.xhp\n" "par_id3151074\n" "help.text" -msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that are first filled with various contents:" -msgstr "A l'exemple següent s'utilitzen dos bucles imbricats per ordenar una matriu de cadenes amb 10 elements ( sEntry() ), que s'omplen primer amb diferents continguts:" - -#. k2qGE -#: 03090202.xhp -msgctxt "" -"03090202.xhp\n" -"par_id3155767\n" -"help.text" -msgid "sEntry(0) = \"Jerry\"" -msgstr "sEntry(0) = \"Jaume\"" - -#. jfGrU -#: 03090202.xhp -msgctxt "" -"03090202.xhp\n" -"par_id3153711\n" -"help.text" -msgid "sEntry(1) = \"Patty\"" -msgstr "sEntry(1) = \"Patri\"" - -#. LBHzA -#: 03090202.xhp -msgctxt "" -"03090202.xhp\n" -"par_id3148993\n" -"help.text" -msgid "sEntry(2) = \"Kurt\"" -msgstr "sEntry(2) = \"Joan\"" +msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that is filled with various contents:" +msgstr "" -#. hBFon +#. uEoLD #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3156382\n" +"par_id561586524231943\n" "help.text" -msgid "sEntry(3) = \"Thomas\"" -msgstr "sEntry(3) = \"Tomàs\"" +msgid "This explores the content of an array to display each item it contains." +msgstr "" -#. 2Afje +#. TGDLQ #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3155174\n" +"bas_id511586523090639\n" "help.text" -msgid "sEntry(4) = \"Michael\"" -msgstr "sEntry(4) = \"Miquel\"" +msgid "Sub list_iteration" +msgstr "" -#. SGKJB +#. biVQS #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3166448\n" +"bas_id391586523091799\n" "help.text" -msgid "sEntry(5) = \"David\"" -msgstr "sEntry(5) = \"David\"" +msgid "cutlery = Array(\"fork\", \"knife\", \"spoon\")" +msgstr "" -#. 856Y8 +#. AupdW #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3149255\n" +"bas_id811586523092655\n" "help.text" -msgid "sEntry(6) = \"Cathy\"" -msgstr "sEntry(6) = \"Cati\"" +msgid "For Each item in cutlery" +msgstr "" -#. qAQBw +#. BdxhG #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3149565\n" +"bas_id271586523092911\n" "help.text" -msgid "sEntry(7) = \"Susie\"" -msgstr "sEntry(7) = \"Sandra\"" +msgid "Print item" +msgstr "" -#. zUTiM +#. Pjkxm #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3145148\n" +"bas_id941586523093415\n" "help.text" -msgid "sEntry(8) = \"Edward\"" -msgstr "sEntry(8) = \"Eduard\"" +msgid "Next ' item" +msgstr "" -#. AsMRN +#. ArG25 #: 03090202.xhp msgctxt "" "03090202.xhp\n" -"par_id3145229\n" +"bas_id301586523093607\n" "help.text" -msgid "sEntry(9) = \"Christine\"" -msgstr "sEntry(9) = \"Cristina\"" +msgid "End Sub" +msgstr "" #. GD68h #: 03090203.xhp @@ -24119,14 +23984,14 @@ msgctxt "" msgid "<link href=\"text/sbasic/shared/03090401.xhp\" name=\"Call Statement\">Call Statement</link>" msgstr "" -#. wneEE +#. nPKzF #: 03090401.xhp msgctxt "" "03090401.xhp\n" "par_id3153394\n" "help.text" -msgid "Transfers the control of the program to a subroutine, a function, or a DLL procedure." -msgstr "Transfereix el control del programa a una subrutina, una funció o un procediment DLL." +msgid "Transfers the control of the program to a subroutine, a function, or a procedure of a <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Dynamic Link Library\">Dynamic Link Library (DLL)</link>. The keyword, type and number of parameters is dependent on the routine that is being called." +msgstr "" #. MdeJS #: 03090401.xhp @@ -24164,32 +24029,50 @@ msgctxt "" msgid "Parameters:" msgstr "Paràmetres:" -#. dbwfN +#. C2MXB #: 03090401.xhp msgctxt "" "03090401.xhp\n" "par_id3148473\n" "help.text" -msgid "<emph>name:</emph> Name of the subroutine, the function, or the DLL that you want to call" +msgid "<emph>name:</emph> Name of the subroutine, the function, or the <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Dynamic Link Library\">DLL</link> that you want to call" msgstr "" -#. iFYrJ +#. 23rrr #: 03090401.xhp msgctxt "" "03090401.xhp\n" "par_id3148946\n" "help.text" -msgid "<emph>param:</emph> Parameters to pass to the procedure. The keyword, type and number of parameters is dependent on the routine that is being called." +msgid "<emph>param:</emph> Keyword parameter name to pass to the routine, followed by its <emph>value</emph>. The name must match the routine declaration. Keywords are optional and can be used in any order." msgstr "" -#. 4LVmZ +#. r9JSP +#: 03090401.xhp +msgctxt "" +"03090401.xhp\n" +"par_id871586190690812\n" +"help.text" +msgid "<emph>value:</emph> Positional parameter value. The type is dependent on the routine that is being called" +msgstr "" + +#. gANH7 +#: 03090401.xhp +msgctxt "" +"03090401.xhp\n" +"par_id421586006407428\n" +"help.text" +msgid "When mixing positional and keyword parameters, make sure positional parameters are following the routine declaration order." +msgstr "" + +#. xFXk8 #: 03090401.xhp msgctxt "" "03090401.xhp\n" "par_id3154216\n" "help.text" -msgid "A keyword is optional when you call a procedure. If a function is executed as an expression, the parameters must be enclosed by brackets in the statement. If a DLL is called, it must first be specified in the <emph>Declare-Statement</emph>." -msgstr "Una paraula clau és opcional quan crideu un procediment. Si una funció s'executa com una expressió, els paràmetres s'han d'incloure entre parèntesis a l'expressió. Si es crida una DLL, primer s'ha d'especificar a la <emph>expressió Declare</emph>." +msgid "When a function is used as an expression, enclosing parameters with brackets becomes necessary. Using a <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Declare Statement\">Declare statement</link> is compulsory prior to call a DLL." +msgstr "" #. QZZ8c #: 03090401.xhp @@ -25901,13 +25784,13 @@ msgctxt "" msgid "<bookmark_value>CVErr function</bookmark_value>" msgstr "<bookmark_value>Funció CVErr</bookmark_value>" -#. hpChf +#. zHAeD #: 03100080.xhp msgctxt "" "03100080.xhp\n" "par_idN1054B\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link>" +msgid "<variable id=\"CvErrh1\"><link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link></variable>" msgstr "" #. 3B8u2 @@ -28682,13 +28565,13 @@ msgctxt "" msgid "<bookmark_value>IsError function</bookmark_value>" msgstr "<bookmark_value>Funció IsError</bookmark_value>" -#. CG3nf +#. FDXnr #: 03102450.xhp msgctxt "" "03102450.xhp\n" "par_idN1054E\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link>" +msgid "<variable id=\"IsErrorh1\"><link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link></variable>" msgstr "" #. yQg58 @@ -29375,14 +29258,14 @@ msgctxt "" msgid "Syntax:" msgstr "Sintaxi:" -#. 6bD7g +#. ZR3gW #: 03103100.xhp msgctxt "" "03103100.xhp\n" -"par_id3154285\n" +"par_id41586012988213\n" "help.text" -msgid "[Let] VarName=Expression" -msgstr "[Let] VarName=Expression" +msgid "<image src=\"media/helpimg/sbasic/LetSet_statement.svg\" id=\"img_id4156306484514\"><alt id=\"alt_id15152796484514\">Let Statement diagram</alt></image>" +msgstr "" #. X4WmE #: 03103100.xhp @@ -29393,14 +29276,14 @@ msgctxt "" msgid "Parameters:" msgstr "Paràmetres:" -#. GDfsk +#. DpLuj #: 03103100.xhp msgctxt "" "03103100.xhp\n" "par_id3147560\n" "help.text" -msgid "<emph>VarName:</emph> Variable that you want to assign a value to. Value and variable type must be compatible." -msgstr "<emph>VarName:</emph> Variable a la qual voleu assignar un valor. Valor i tipus de variable han de ser compatibles." +msgid "<emph>variable:</emph> Variable that you want to assign a value to. Value and variable type must be compatible." +msgstr "" #. ZCswn #: 03103100.xhp @@ -30104,14 +29987,14 @@ msgctxt "" msgid "Set Statement" msgstr "" -#. zHGh5 +#. GzHJQ #: 03103700.xhp msgctxt "" "03103700.xhp\n" "bm_id3154422\n" "help.text" -msgid "<bookmark_value>Set statement</bookmark_value> <bookmark_value>Nothing object</bookmark_value>" -msgstr "<bookmark_value>expressió Set</bookmark_value> <bookmark_value>objecte Nothing</bookmark_value>" +msgid "<bookmark_value>Set statement</bookmark_value> <bookmark_value>New keyword</bookmark_value> <bookmark_value>Nothing object</bookmark_value>" +msgstr "" #. eramH #: 03103700.xhp @@ -30122,14 +30005,14 @@ msgctxt "" msgid "<link href=\"text/sbasic/shared/03103700.xhp\" name=\"Set Statement\">Set Statement</link>" msgstr "" -#. EZQ7H +#. qNuUW #: 03103700.xhp msgctxt "" "03103700.xhp\n" "par_id3159149\n" "help.text" -msgid "Sets an object reference on a variable or a Property." -msgstr "Estableix una referència d'objecte en una variable o en una propietat." +msgid "Sets an object reference on a variable." +msgstr "" #. MkkED #: 03103700.xhp @@ -30140,14 +30023,23 @@ msgctxt "" msgid "Syntax:" msgstr "Sintaxi:" -#. VNH9y +#. DiSYW +#: 03103700.xhp +msgctxt "" +"03103700.xhp\n" +"par_id491585753339474\n" +"help.text" +msgid "<image src=\"media/helpimg/sbasic/LetSet_statement.svg\" id=\"img_id4156306484514\"><alt id=\"alt_id15152796484514\">Set Statement diagram</alt></image>" +msgstr "" + +#. P5Xm2 #: 03103700.xhp msgctxt "" "03103700.xhp\n" "par_id3154217\n" "help.text" -msgid "Set ObjectVar = Object" -msgstr "Set ObjectVar = Object" +msgid "Set variable = object" +msgstr "" #. r4fJx #: 03103700.xhp @@ -30158,32 +30050,41 @@ msgctxt "" msgid "Parameters:" msgstr "Paràmetres:" -#. CMGdW +#. K6c5D #: 03103700.xhp msgctxt "" "03103700.xhp\n" "par_id3156281\n" "help.text" -msgid "<emph>ObjectVar:</emph> a variable or a property that requires an object reference." -msgstr "<emph>ObjectVar:</emph> una variable o una propietat que requereix una referència d'objecte." +msgid "<emph>variable:</emph> a variable or a property that requires an object reference." +msgstr "" -#. F7X5E +#. kSZDp #: 03103700.xhp msgctxt "" "03103700.xhp\n" "par_id3159252\n" "help.text" -msgid "<emph>Object:</emph> Object that the variable or the property refers to." -msgstr "<emph>Objecte:</emph> Objecte al qual fa referència la variable o la propietat." +msgid "<emph>object:</emph> Object that the variable refers to." +msgstr "" -#. 27u9f +#. goUzz #: 03103700.xhp msgctxt "" "03103700.xhp\n" "par_idN10623\n" "help.text" -msgid "<emph>Nothing</emph> - Assign the <emph>Nothing</emph> object to a variable to remove a previous assignment." -msgstr "<emph>Res</emph> - Assigna l'objecte <emph>Res</emph> a una variable per suprimir una assignació anterior." +msgid "<emph>Nothing</emph> - Assign <emph>Nothing</emph> to a variable to remove a previous assignment." +msgstr "" + +#. PUiZf +#: 03103700.xhp +msgctxt "" +"03103700.xhp\n" +"par_id101586014505785\n" +"help.text" +msgid "The keyword <emph>Set</emph> is optional." +msgstr "" #. SGsRz #: 03103700.xhp @@ -30194,6 +30095,15 @@ msgctxt "" msgid "Example:" msgstr "Exemple:" +#. dt2A8 +#: 03103700.xhp +msgctxt "" +"03103700.xhp\n" +"par_id841586014507226\n" +"help.text" +msgid "Use <emph>New</emph> only to assign a <link href=\"text/sbasic/shared/classmodule\" name=\"ClassModule\">class module</link> instance to a variable." +msgstr "" + #. ukqdX #: 03103800.xhp msgctxt "" @@ -40175,6 +40085,186 @@ msgctxt "" msgid "See also <link href=\"text/sbasic/shared/00000002.xhp\" name=\"external\">URL Notation</link>" msgstr "" +#. PRG9t +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"tit\n" +"help.text" +msgid "Resume Statement" +msgstr "" + +#. sMcg4 +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"N0001\n" +"help.text" +msgid "<bookmark_value>Resume statement</bookmark_value>" +msgstr "" + +#. LTupm +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"N0002\n" +"help.text" +msgid "<variable id=\"resumeh1\"><link href=\"text/sbasic/shared/Resume.xhp\" name=\"Resume statement\">Resume Statement</link></variable>" +msgstr "" + +#. AVhyb +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"N0003\n" +"help.text" +msgid "Resets error information and indicates what to execute next." +msgstr "" + +#. FhZm3 +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id491585753339474\n" +"help.text" +msgid "<image src=\"media/helpimg/sbasic/Resume_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Resume Statement diagram</alt></image>" +msgstr "" + +#. KAJEM +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id481586090298901\n" +"help.text" +msgid "<emph>0: </emph>Resets error information and re-executes the instruction that caused the error. <emph>0</emph> is optional." +msgstr "" + +#. RTTux +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id331586090532804\n" +"help.text" +msgid "<emph>label: </emph>Resets error information and executes the instruction at the given label." +msgstr "" + +#. 7RP8z +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id331586090432804\n" +"help.text" +msgid "<emph>Next: </emph>Resets error information and executes the instruction following the one that caused the error." +msgstr "" + +#. 3Jge7 +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id441586333320983\n" +"help.text" +msgid "Error information is built with <literal>Erl</literal>, <literal>Err</literal> and <literal>Error$</literal> functions." +msgstr "" + +#. PoXod +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id741586333516110\n" +"help.text" +msgid "<literal>Erl</literal>: Module line number where error occurs." +msgstr "" + +#. aX9ZN +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id81586333580520\n" +"help.text" +msgid "<literal>Err</literal>: Error number." +msgstr "" + +#. ctA2t +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id721586333586263\n" +"help.text" +msgid "<literal>Error[$]</literal>: Error description." +msgstr "" + +#. fDJgb +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id941586091561618\n" +"help.text" +msgid "Using <emph>Resume</emph> to reset error information prevents the propagation of the handled condition to calling routines." +msgstr "" + +#. coy5D +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"hd_id441586092960246\n" +"help.text" +msgid "Examples:" +msgstr "" + +#. 4dyMX +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id961586248539108\n" +"help.text" +msgid "Typical error handling routines are: alerting the user, fixing the error, logging error information or re-throwing custom errors that provide explanations with resolution instructions. Use <literal>Resume label</literal> when requiring such mechanisms." +msgstr "" + +#. VCDS3 +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"bas_id451586093122848\n" +"help.text" +msgid "' routine code goes here" +msgstr "" + +#. BFzfG +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"bas_id515860931234846\n" +"help.text" +msgid "Error 91 ' example error" +msgstr "" + +#. uFVnv +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"bas_id361586093126654\n" +"help.text" +msgid "' routine cleanup code goes here" +msgstr "" + +#. UNbMJ +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id61586095819168\n" +"help.text" +msgid "Use <literal>Resume Next</literal>, for example, when reporting anomalies encountered for an iterating process that must not be interrupted. In which case multiple handling routines may be required." +msgstr "" + +#. AeVfB +#: Resume.xhp +msgctxt "" +"Resume.xhp\n" +"par_id461586091018138\n" +"help.text" +msgid "Using <literal>Resume</literal> without parameters to re-execute the faulty instruction can fit certain situations. However that may cause a never ending loop." +msgstr "" + #. MqMrx #: classmodule.xhp msgctxt "" diff --git a/source/ca-valencia/helpcontent2/source/text/scalc/01.po b/source/ca-valencia/helpcontent2/source/text/scalc/01.po index 22a07e17828..a3b678a2574 100644 --- a/source/ca-valencia/helpcontent2/source/text/scalc/01.po +++ b/source/ca-valencia/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-04-03 11:46+0200\n" +"POT-Creation-Date: 2020-04-15 12:52+0200\n" "PO-Revision-Date: 2018-11-12 13:23+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -6200,14 +6200,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calcula l'import rebut que es paga per un valor de renda fixa en un moment determinat.</ahelp>" -#. XhTVX +#. BiDCz #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3145362\n" "help.text" -msgid "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)" -msgstr "REBUT(\"Liquidació\"; \"Venciment\"; Inversió; Descompte; Base)" +msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])" +msgstr "" #. oHAVz #: 04060103.xhp @@ -6992,14 +6992,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calcula la bonificació (el descompte) del títol en forma de percentatge.</ahelp>" -#. tusey +#. fBGBA #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3149756\n" "help.text" -msgid "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)" -msgstr "DESC(\"Liquidació\"; \"Venciment\"; Preu; Reemborsament; Base)" +msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])" +msgstr "" #. Uyj29 #: 04060103.xhp @@ -7082,13 +7082,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calcula la duració d'un valor de renda fixa en anys.</ahelp>" -#. bJZPP +#. 7ixum #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153373\n" "help.text" -msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)" +msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])" msgstr "" #. JeeVp @@ -7145,13 +7145,13 @@ msgctxt "" msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the duration?" msgstr "Es compra un títol el dia 1/1/2001; la data de venciment és l'1/1/2006. El tipus d'interés del cupó és del 8%. El rendiment és del 9,0%. L'interés es paga semestralment (la freqüència és 2). Si feu un càlcul (base 3) d'interessos sobre saldos diaris, quina és la duració?" -#. ggYzf +#. ADc8t #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3154902\n" "help.text" -msgid "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>" +msgid "<input>=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</input> returns 4.2 years." msgstr "" #. TjeEJ @@ -12662,420 +12662,6 @@ msgctxt "" msgid "<item type=\"input\">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately 0.69897)." msgstr "<item type=\"input\">=LOG10(5)</item> retorna el logaritme en base 10 de 5 (aproximadament 0,69897)." -#. fnS8m -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id3152518\n" -"help.text" -msgid "<bookmark_value>CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>" -msgstr "<bookmark_value>funció ARRODMULTSUP</bookmark_value><bookmark_value>arrodoniment;cap amunt fins a múltiples significatius</bookmark_value>" - -#. FtjnD -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3152518\n" -"help.text" -msgid "CEILING" -msgstr "ARRODMULTSUP" - -#. BDPUw -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3153422\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of Significance.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Arrodoneix un nombre cap al múltiple més proper d'Importància.</ahelp>" - -#. fhdEu -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3153454\n" -"help.text" -msgid "CEILING(Number; Significance; Mode)" -msgstr "ARRODMULTSUP(Nombre; Precisió; Mode)" - -#. PyYGM -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3153467\n" -"help.text" -msgid "<emph>Number</emph> is the number that is to be rounded up." -msgstr "<emph>Nombre</emph> és el nombre que s'ha d'arrodonir a l'alça." - -#. GQVYD -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155000\n" -"help.text" -msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up." -msgstr "<emph>Importància</emph> és el nombre al múltiple del qual s'ha d'arrodonir a l'alça el valor." - -#. dEi4T -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155020\n" -"help.text" -msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero." -msgstr "" - -#. MUqdA -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163792\n" -"help.text" -msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero." -msgstr "" - -#. B5jSx -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3145710\n" -"help.text" -msgid "<item type=\"input\">=CEILING(-11;-2)</item> returns -10" -msgstr "<item type=\"input\">=ARRODMULTSUP(-11;-2)</item> retorna -10." - -#. H6Ai9 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3145725\n" -"help.text" -msgid "<item type=\"input\">=CEILING(-11;-2;0)</item> returns -10" -msgstr "<item type=\"input\">=ARRODMULTSUP(-11;-2;0)</item> retorna -10." - -#. X8Ebc -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3145740\n" -"help.text" -msgid "<item type=\"input\">=CEILING(-11;-2;1)</item> returns -12" -msgstr "<item type=\"input\">=ARRODMULTSUP(-11;-2;1)</item> retorna -12." - -#. NWAdq -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id2952518\n" -"help.text" -msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>" -msgstr "<bookmark_value>funció ARRODMULTSUP.PRECIS</bookmark_value><bookmark_value>arrodoniment;cap amunt fins a múltiples significatius</bookmark_value>" - -#. TL2Mo -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id2952518\n" -"help.text" -msgid "CEILING.PRECISE" -msgstr "ARRODMULTSUP.PRECIS" - -#. uP3ef -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2953422\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_CEIL_MS\">Arrodoneix un nombre cap amunt al múltiple més proper de la Precisió, sense importar el signe de la Precisió.</ahelp>" - -#. af8Jy -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2953454\n" -"help.text" -msgid "CEILING.PRECISE(Number; Significance)" -msgstr "ARRODMULTSUP.PRECIS(Nombre;Precisió)" - -#. c2S3Q -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2953467\n" -"help.text" -msgid "<emph>Number</emph> (required) is the number that is to be rounded up." -msgstr "<emph>Nombre</emph> (necessari) és el nombre que s'ha d'arrodonir a l'alça." - -#. De3wj -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2955000\n" -"help.text" -msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up." -msgstr "<emph>Precisió</emph> (opcional) és el nombre al múltiple del qual s'ha d'arrodonir a l'alça el valor." - -#. ATzN5 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2945710\n" -"help.text" -msgid "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> returns -10" -msgstr "<item type=\"input\">=ARRODMULTSUP.PRECIS(-11;-2)</item> retorna -10" - -#. CyR3Z -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id911516997198644\n" -"help.text" -msgid "<bookmark_value>CEILING.MATH function</bookmark_value>" -msgstr "" - -#. 47WTb -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id91516997330445\n" -"help.text" -msgid "CEILING.MATH" -msgstr "" - -#. fj22A -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id81516997342088\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>" -msgstr "" - -#. dEs2U -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id841516997669932\n" -"help.text" -msgid "CEILING.MATH(Number; Significance; Mode)" -msgstr "" - -#. mVrcG -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id651516997706287\n" -"help.text" -msgid "<emph>Number</emph> is the number that is to be rounded up." -msgstr "" - -#. eWEoz -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id491516997725772\n" -"help.text" -msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up." -msgstr "" - -#. DhhJP -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id451516997742909\n" -"help.text" -msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero." -msgstr "" - -#. pNkWd -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id291516998575663\n" -"help.text" -msgid "This function exists for interoperability with Microsoft Excel 2013 or newer." -msgstr "" - -#. AWN7C -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id111516997803684\n" -"help.text" -msgid "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9" -msgstr "" - -#. VRy7N -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id1001516997821483\n" -"help.text" -msgid "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9" -msgstr "" - -#. Cqx7f -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id641516997837754\n" -"help.text" -msgid "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12" -msgstr "" - -#. 5eFKb -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id921516998608939\n" -"help.text" -msgid "<bookmark_value>CEILING.XCL function</bookmark_value>" -msgstr "" - -#. 7CEZC -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id411516998838823\n" -"help.text" -msgid "CEILING.XCL" -msgstr "" - -#. vYMF6 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id811516998845826\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>" -msgstr "" - -#. hh5aZ -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id251516998856873\n" -"help.text" -msgid "CEILING.XCL(Number; Significance)" -msgstr "" - -#. cwEnK -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id671516998874263\n" -"help.text" -msgid "<emph>Number</emph> is the number that is to be rounded." -msgstr "" - -#. RLTcE -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id151516998882622\n" -"help.text" -msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded." -msgstr "" - -#. FZWHB -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id341516998889754\n" -"help.text" -msgid "This function exists for interoperability with Microsoft Excel 2007 or older versions." -msgstr "" - -#. UuVCG -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id91516998917254\n" -"help.text" -msgid "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3" -msgstr "" - -#. mD3Gy -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id761516998929693\n" -"help.text" -msgid "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8" -msgstr "" - -#. C59zA -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id671516998958873\n" -"help.text" -msgid "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12" -msgstr "" - -#. VwPyC -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id8952518\n" -"help.text" -msgid "<bookmark_value>ISO.CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>" -msgstr "<bookmark_value>funció ARRODMULTSUP.ISO</bookmark_value><bookmark_value>arrodoniment;cap amunt fins a múltiples significatius</bookmark_value>" - -#. DhoD5 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id8952518\n" -"help.text" -msgid "ISO.CEILING" -msgstr "ARRODMULTSUP.ISO" - -#. a8Z2B -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8953422\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Arrodoneix un nombre cap amunt al múltiple més proper de la Precisió, sense importar el signe de la Precisió</ahelp>" - -#. iGoz8 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8953454\n" -"help.text" -msgid "ISO.CEILING(Number; Significance)" -msgstr "ARRODMULTSUP.ISO(Nombre; Precisió)" - -#. p7ssP -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8953467\n" -"help.text" -msgid "<emph>Number</emph> (required) is the number that is to be rounded up." -msgstr "<emph>Nombre</emph> (necessari) és el nombre que s'ha d'arrodonir a l'alça." - -#. FBHry -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8955000\n" -"help.text" -msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up." -msgstr "<emph>Precisió</emph> (opcional) és el nombre al múltiple del qual s'ha d'arrodonir a l'alça el valor." - -#. M8dYu -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8945710\n" -"help.text" -msgid "<item type=\"input\">=ISO.CEILING(-11;-2)</item> returns -10" -msgstr "<item type=\"input\">=ARRODMULTSUP.ISO(-11;-2)</item> retorna -10" - #. tQjUA #: 04060106.xhp msgctxt "" @@ -15038,168 +14624,6 @@ msgctxt "" msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5." msgstr "<item type=\"input\">=SENAR(-3,1)</item> retorna -5." -#. CR7gG -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id2957404\n" -"help.text" -msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>FLOOR.XCL function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" -msgstr "" - -#. ticPN -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id2957404\n" -"help.text" -msgid "FLOOR.PRECISE" -msgstr "ARRODMULTINF.PRECIS" - -#. eZWE9 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2957432\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Arrodoneix un nombre cap avall al múltiple més proper de la Precisió, sense importar el signe de la Precisió</ahelp>" - -#. BKB8E -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2957464\n" -"help.text" -msgid "FLOOR.PRECISE(Number; Significance)" -msgstr "ARRODMULTINF.PRECIS(Nombre; Precisió)" - -#. Mt3KY -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2957478\n" -"help.text" -msgid "<emph>Number</emph> is the number that is to be rounded down." -msgstr "<emph>Nombre</emph> és el nombre que s'ha d'arrodonir a la baixa." - -#. oe3sn -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2957497\n" -"help.text" -msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down." -msgstr "<emph>Precisió</emph> és el valor al múltiple del qual s'ha d'arrodonir a la baixa el nombre." - -#. FCZhS -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2963945\n" -"help.text" -msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12" -msgstr "<item type=\"input\">=ARRODMULTINF.PRECIS( -11;-2)</item> retorna -12" - -#. aDgE5 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id3157404\n" -"help.text" -msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>FLOOR.MATH function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" -msgstr "" - -#. BAZE3 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3157404\n" -"help.text" -msgid "FLOOR" -msgstr "ARRODMULTINF" - -#. WHyYX -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3157432\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number down to the nearest multiple of Significance.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Arrodoneix un nombre a la baixa cap al múltiple més proper de Precisió.</ahelp>" - -#. DDbJ6 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3157464\n" -"help.text" -msgid "FLOOR(Number; Significance; Mode)" -msgstr "ARRODMULTINF(Nombre; Precisió; Mode)" - -#. cEAXh -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3157478\n" -"help.text" -msgid "<emph>Number</emph> is the number that is to be rounded down." -msgstr "<emph>Nombre</emph> és el nombre que s'ha d'arrodonir a la baixa." - -#. zEGez -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3157497\n" -"help.text" -msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down." -msgstr "<emph>Precisió</emph> és el valor al múltiple del qual s'ha d'arrodonir a la baixa el nombre." - -#. dDExC -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3157517\n" -"help.text" -msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero." -msgstr "" - -#. Z6Cnd -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163894\n" -"help.text" -msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero." -msgstr "" - -#. 4FuF8 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163945\n" -"help.text" -msgid "<item type=\"input\">=FLOOR( -11;-2)</item> returns -12" -msgstr "<item type=\"input\">=ARRODMULTINF( -11;-2)</item> retorna -12." - -#. R4ppE -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163966\n" -"help.text" -msgid "<item type=\"input\">=FLOOR( -11;-2;0)</item> returns -12" -msgstr "<item type=\"input\">=ARRODMULTINF( -11;-2;0)</item> retorna -12." - -#. aWzUK -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163988\n" -"help.text" -msgid "<item type=\"input\">=FLOOR( -11;-2;1)</item> returns -10" -msgstr "<item type=\"input\">=ARRODMULTINF( -11;-2;1)</item> retorna -10." - #. itiAQ #: 04060106.xhp msgctxt "" @@ -16586,41 +16010,41 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns." msgstr "<ahelp hid=\"HID_FUNC_MMULT\">Calcula el producte de dues matrius.</ahelp> El nombre de columnes de la matriu 1 ha de coincidir amb el nombre de files de la matriu 2. La matriu quadrada té el mateix nombre de files i de columnes." -#. dEKAU +#. JUTAD #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3150798\n" "help.text" -msgid "MMULT(Array; Array)" -msgstr "MULTM(Matriu; Matriu)" +msgid "MMULT(Array 1; Array 2)" +msgstr "" -#. noXqv +#. DqghH #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3150812\n" "help.text" -msgid "<emph>Array</emph> at first place represents the first array used in the array product." -msgstr "En la primera posició, <emph>Matriu</emph> representa la primera matriu que s'utilitza en el producte de la matriu." +msgid "<emph>Array 1</emph> represents the first array used in the array product." +msgstr "" -#. 5qGeT +#. FDfwg #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3152553\n" "help.text" -msgid "<emph>Array</emph> at second place represents the second array with the same number of rows." -msgstr "En la segona posició, <emph>Matriu</emph> representa la segona matriu amb el mateix nombre de files." +msgid "<emph>Array 2</emph> represents the second array with the same number of rows." +msgstr "" -#. RoWHa +#. CuGxm #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3146826\n" "help.text" -msgid "Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range." -msgstr "Seleccioneu un interval quadrat. Trieu la funció MULTM. Seleccioneu la primera <emph>Matriu</emph> i, tot seguit, seleccioneu la segona <emph>Matriu</emph>. Mitjançant l'<emph>Auxiliar de funcions</emph>, activeu la casella de selecció <emph>Matriu</emph>. Feu clic a <emph>D'acord</emph>. La matriu obtinguda apareixerà en el primer interval seleccionat." +msgid "Select a square range. Choose the MMULT function. Select <emph>Array 1</emph>, then select <emph>Array 2</emph>. Using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range." +msgstr "" #. vPBWq #: 04060107.xhp @@ -18314,15 +17738,6 @@ msgctxt "" msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518." msgstr "Si la cel·la A1 mostra Err:518, la funció <item type=\"input\">=TIPUSERROR(A1)</item> retorna el nombre 518." -#. FWJTB -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"hd_id275141466817507\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/func_error_type.xhp#error_type_head\"/>" -msgstr "" - #. mtLKD #: 04060109.xhp msgctxt "" @@ -33785,6 +33200,15 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the inverse of CHISQDIST.</ahelp>" msgstr "<ahelp hid=\".\">Retorna la inversa de DISTKHIQUAD.</ahelp>" +#. ELVTS +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id21585771564740\n" +"help.text" +msgid "CHISQINV(Probability; Degrees of Freedom)" +msgstr "" + #. KibGe #: 04060181.xhp msgctxt "" @@ -35765,6 +35189,15 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST." msgstr "<ahelp hid=\".\">Retorna el valor de la funció gamma.</ahelp> Tingueu en compte que INVGAMMA no és la inversa de GAMMA, sinó DISTGAMMA." +#. WT29Z +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id211585771824267\n" +"help.text" +msgid "GAMMA(Number)" +msgstr "" + #. 2DdQa #: 04060182.xhp msgctxt "" @@ -36638,14 +36071,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Retorna la distribució hipergeomètrica.</ahelp>" -#. fNMzN +#. 5uQ3c #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3155388\n" "help.text" -msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation)" -msgstr "DISTHIPGEOM(X; MostraN; Èxits; PoblacióN)" +msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])" +msgstr "" #. ingyW #: 04060182.xhp @@ -36683,6 +36116,15 @@ msgctxt "" msgid "<emph>NPopulation </emph>is the size of the total population." msgstr "<emph>PoblacióN</emph> és la mida de la població total." +#. oDuYV +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id231585952506847\n" +"help.text" +msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter." +msgstr "" + #. WUiB6 #: 04060182.xhp msgctxt "" @@ -55988,6 +55430,528 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "Si E2 = llapis, la funció retorna 65, perquè l'enllaç a la cel·la se substitueix amb el seu contingut." +#. s6GFW +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"tit\n" +"help.text" +msgid "Ceiling functions" +msgstr "" + +#. EWCte +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"hd_id971586216771519\n" +"help.text" +msgid "Ceiling functions" +msgstr "" + +#. M92qb +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"bm_id3152518\n" +"help.text" +msgid "<bookmark_value>CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" +msgstr "" + +#. XR3RK +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"hd_id3152518\n" +"help.text" +msgid "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\" name=\"CEILING\">CEILING</link></variable>" +msgstr "" + +#. E9m3Y +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id3153422\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of s significance value.</ahelp>" +msgstr "" + +#. PfT3s +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id601586207136514\n" +"help.text" +msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs." +msgstr "" + +#. s9tRF +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id3163792\n" +"help.text" +msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero." +msgstr "" + +#. mZwNV +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id3153454\n" +"help.text" +msgid "CEILING(Number[; Significance[; Mode]])" +msgstr "" + +#. XHjhc +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id3153467\n" +"help.text" +msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number." +msgstr "" + +#. XEqxw +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id3155000\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>." +msgstr "" + +#. AosjB +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id3155020\n" +"help.text" +msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero)." +msgstr "" + +#. Ka9pC +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id281586208138400\n" +"help.text" +msgid "<input>=CEILING(3.45)</input> returns 4." +msgstr "" + +#. ztdNi +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id921586208142416\n" +"help.text" +msgid "<input>=CEILING(3.45, 3)</input> returns 6." +msgstr "" + +#. XGfA3 +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id921586208146984\n" +"help.text" +msgid "<input>=CEILING(-1.234)</input> returns -1." +msgstr "" + +#. ss5WP +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id491586208152183\n" +"help.text" +msgid "<input>=CEILING(-45.67, -2, 0)</input> returns -44." +msgstr "" + +#. FY9XN +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id291586208158119\n" +"help.text" +msgid "<input>=CEILING(-45.67, -2, 1)</input> returns -46." +msgstr "" + +#. rZ78k +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"bm_id2952518\n" +"help.text" +msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" +msgstr "" + +#. 5DWRd +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"hd_id2952518\n" +"help.text" +msgid "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\" name=\"CEILING.PRECISE\">CEILING.PRECISE</link></variable>" +msgstr "" + +#. aTD6P +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id2953422\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of a significance value.</ahelp>" +msgstr "" + +#. BjuBa +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id151586642494759\n" +"help.text" +msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored." +msgstr "" + +#. EErBR +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id631586642933797\n" +"help.text" +msgid "This function calculates identical results to the <link href=\"#Section312\" name=\"isoceiling\">ISO.CEILING</link> function." +msgstr "" + +#. yYT7X +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id2953454\n" +"help.text" +msgid "CEILING.PRECISE(Number[; Significance])" +msgstr "" + +#. FaYeD +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id2955000\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." +msgstr "" + +#. 6Vtow +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id461586211894475\n" +"help.text" +msgid "This function calculates identical results to the ISO.CEILING function" +msgstr "" + +#. 8WiRx +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id201586213398634\n" +"help.text" +msgid "<input>=CEILING.PRECISE(3.45)</input> returns 4." +msgstr "" + +#. kkosx +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id651586213406243\n" +"help.text" +msgid "<input>=CEILING.PRECISE(-45.67,2)</input> returns -44." +msgstr "" + +#. WV9bx +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"bm_id911516997198644\n" +"help.text" +msgid "<bookmark_value>CEILING.MATH function</bookmark_value>" +msgstr "" + +#. 7xeKu +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"hd_id91516997330445\n" +"help.text" +msgid "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\" name=\"CEILING.MATH\">CEILING.MATH</link></variable>" +msgstr "" + +#. AzJvD +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id81516997342088\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number to the nearest multiple of a significance value.</ahelp>" +msgstr "" + +#. QLGe7 +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id911586642319078\n" +"help.text" +msgid "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored." +msgstr "" + +#. Km7yb +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id841516997669932\n" +"help.text" +msgid "CEILING.MATH(Number[; Significance[; Mode]])" +msgstr "" + +#. EAezJ +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id491516997725772\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." +msgstr "" + +#. EiWLa +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id451516997742909\n" +"help.text" +msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)." +msgstr "" + +#. aYczG +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id291516998575663\n" +"help.text" +msgid "This function exists for interoperability with Microsoft Excel 2013 or newer." +msgstr "" + +#. je22s +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id331586208590009\n" +"help.text" +msgid "<input>=CEILING.MATH(3.45)</input> returns 4." +msgstr "" + +#. 6BkMe +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id481586208595809\n" +"help.text" +msgid "<input>=CEILING.MATH(3.45,-3)</input> returns 6." +msgstr "" + +#. Eby7i +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id641586208600665\n" +"help.text" +msgid "<input>=CEILING.MATH(-1.234)</input> returns -1." +msgstr "" + +#. fH4Yt +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id151586208604536\n" +"help.text" +msgid "<input>=CEILING.MATH(-45.67,-2,0)</input> returns -44." +msgstr "" + +#. MGVBD +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id971586208611345\n" +"help.text" +msgid "<input>=CEILING.MATH(-45.67,+2, 1)</input> returns -46." +msgstr "" + +#. EzE9t +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"bm_id921516998608939\n" +"help.text" +msgid "<bookmark_value>CEILING.XCL function</bookmark_value>" +msgstr "" + +#. CRMmT +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"hd_id411516998838823\n" +"help.text" +msgid "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\" name=\"CEILING.XCL\">CEILING.XCL</link></variable>" +msgstr "" + +#. 2tuD3 +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id811516998845826\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number to the nearest multiple of a significance value.</ahelp>" +msgstr "" + +#. tAyJj +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id361586213828675\n" +"help.text" +msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative." +msgstr "" + +#. 2CKjm +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id881586213934118\n" +"help.text" +msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function." +msgstr "" + +#. GspBr +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id251516998856873\n" +"help.text" +msgid "CEILING.XCL(Number; Significance)" +msgstr "" + +#. eTSgx +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id151516998882622\n" +"help.text" +msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded." +msgstr "" + +#. 6n7qn +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id421586214128242\n" +"help.text" +msgid "<input>=CEILING.XCL(3.45,2)</input> returns 4." +msgstr "" + +#. SZYUC +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id651586214132234\n" +"help.text" +msgid "<input>=CEILING.XCL(-45.67,2)</input> returns -44." +msgstr "" + +#. pz8Go +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id811586214136666\n" +"help.text" +msgid "<input>=CEILING.XCL(-45.67,-2)</input> returns -46." +msgstr "" + +#. GMzhD +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"bm_id8952518\n" +"help.text" +msgid "<bookmark_value>ISO.CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" +msgstr "" + +#. q22aC +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"hd_id8952518\n" +"help.text" +msgid "<variable id=\"ISO.CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\" name=\"ISO.CEILING\">ISO.CEILING</link></variable>" +msgstr "" + +#. 5beBC +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id8953422\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of a significance value.</ahelp>" +msgstr "" + +#. SFZNu +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id101586214229587\n" +"help.text" +msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored." +msgstr "" + +#. qu8FG +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id821586214265060\n" +"help.text" +msgid "This function calculates identical results to the <link href=\"#Section311\" name=\"ceilingprecise\">CEILING.PRECISE</link> function." +msgstr "" + +#. LZzHU +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id8953454\n" +"help.text" +msgid "ISO.CEILING(Number[; Significance])" +msgstr "" + +#. hwhCW +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id8955000\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." +msgstr "" + +#. FSFdP +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id801586214431463\n" +"help.text" +msgid "<input>=ISO.CEILING(3.45)</input> returns 4." +msgstr "" + +#. ENMYD +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id181586214438808\n" +"help.text" +msgid "<input>=ISO.CEILING(-45.67,2)</input> returns 44." +msgstr "" + #. GuEcB #: func_color.xhp msgctxt "" @@ -56951,14 +56915,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TAGE360\">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_TAGE360\">Retorna la diferència entre dues dates basada en l'any de 360 dies utilitzat en el càlcul d'interessos.</ahelp>" -#. ow4Jg +#. Vndiw #: func_days360.xhp msgctxt "" "func_days360.xhp\n" "par_id3155313\n" "help.text" -msgid "DAYS360(\"Date1\"; \"Date2\"; Type)" -msgstr "DIES360(\"Data1\"; \"Data2\"; Tipus)" +msgid "DAYS360(Date1; Date2[; Type])" +msgstr "" #. 5qfGz #: func_days360.xhp @@ -57608,6 +57572,429 @@ msgctxt "" msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19." msgstr "" +#. aACGP +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"tit\n" +"help.text" +msgid "FLOOR Functions" +msgstr "" + +#. RuCRw +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"hd_id391586285373874\n" +"help.text" +msgid "FLOOR Functions" +msgstr "" + +#. hkrkw +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"bm_id3157404\n" +"help.text" +msgid "<bookmark_value>FLOOR function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgstr "" + +#. KoqGL +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"hd_id3157404\n" +"help.text" +msgid "<variable id=\"FLOORh1\"><link href=\"text/scalc/01/func_floor.xhp#floor\" name=\"FLOOR\">FLOOR</link></variable>" +msgstr "" + +#. VSV8H +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id3157432\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>" +msgstr "" + +#. 345Fr +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id661586285977707\n" +"help.text" +msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs." +msgstr "" + +#. 2haGU +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id3157464\n" +"help.text" +msgid "FLOOR(Number[; Significance[; Mode]])" +msgstr "" + +#. ERf3D +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id3153467\n" +"help.text" +msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number." +msgstr "" + +#. 8w8tL +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id3157497\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>." +msgstr "" + +#. qCpHR +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id3157517\n" +"help.text" +msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)." +msgstr "" + +#. 5kHtR +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id3163894\n" +"help.text" +msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions." +msgstr "" + +#. EU85r +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id761586287595376\n" +"help.text" +msgid "<input>=FLOOR(3.45)</input> returns 3." +msgstr "" + +#. vuJc5 +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id311586287600048\n" +"help.text" +msgid "<input>=FLOOR(3.45, 3)</input> returns 3." +msgstr "" + +#. uTWTb +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id661586287604519\n" +"help.text" +msgid "<input>=FLOOR(-1.234)</input> returns -2." +msgstr "" + +#. 8ZGDc +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id741586287608968\n" +"help.text" +msgid "<input>=FLOOR(-45.67, -2, 0)</input> returns -46." +msgstr "" + +#. gXsTm +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id431586287616089\n" +"help.text" +msgid "<input>=FLOOR(-45.67, -2, 1)</input> returns -44." +msgstr "" + +#. zzTLr +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"bm_id811586290952465\n" +"help.text" +msgid "<bookmark_value>FLOOR.MATH function</bookmark_value>" +msgstr "" + +#. rEELD +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"hd_id1001586287279297\n" +"help.text" +msgid "<variable id=\"FLOOR.MATHh1\"><link href=\"text/scalc/01/func_floor.xhp#floormath\" name=\"FLOOR.MATH\">FLOOR.MATH</link></variable>" +msgstr "" + +#. BBjwd +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id721586287302689\n" +"help.text" +msgid "Rounds a number to the nearest multiple of a significance value." +msgstr "" + +#. UJLZc +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id311586287323417\n" +"help.text" +msgid "For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored." +msgstr "" + +#. 4weAd +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id851586287535879\n" +"help.text" +msgid "This function exists for interoperability with Microsoft Excel 2013 or newer." +msgstr "" + +#. 4DFyG +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id161586287421523\n" +"help.text" +msgid "FLOOR.MATH(Number[; Significance[; Mode]])" +msgstr "" + +#. Un6FB +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id231586287448716\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." +msgstr "" + +#. L9MKT +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id261586287494401\n" +"help.text" +msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero)." +msgstr "" + +#. wCd8C +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id101586287621816\n" +"help.text" +msgid "<input>=FLOOR.MATH(3.45)</input> returns 3." +msgstr "" + +#. p27MD +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id771586287627784\n" +"help.text" +msgid "<input>=FLOOR.MATH(3.45,-3)</input> returns 3." +msgstr "" + +#. Fehfx +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id981586287632392\n" +"help.text" +msgid "<input>=FLOOR.MATH(-1.234)</input> returns -2." +msgstr "" + +#. eQfea +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id631586287637256\n" +"help.text" +msgid "<input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46." +msgstr "" + +#. XXqpS +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id371586287641888\n" +"help.text" +msgid "<input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44." +msgstr "" + +#. 9MJem +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"bm_id2957404\n" +"help.text" +msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgstr "" + +#. niyQj +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"hd_id2957404\n" +"help.text" +msgid "<variable id=\"FLOOR.PRECISEh1\"><link href=\"text/scalc/01/func_floor.xhp#floorprecise\" name=\"FLOOR.PRECISE\">FLOOR.PRECISE</link></variable>" +msgstr "" + +#. DgQBx +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id2957432\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of a significance value.</ahelp>" +msgstr "" + +#. NHMnz +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id261586641501175\n" +"help.text" +msgid "For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored." +msgstr "" + +#. ni9y2 +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id2957464\n" +"help.text" +msgid "FLOOR.PRECISE(Number[; Significance])" +msgstr "" + +#. pirHp +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id2957497\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." +msgstr "" + +#. smFCw +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id981586291388900\n" +"help.text" +msgid "<input>=FLOOR.PRECISE(3.45)</input> returns 3." +msgstr "" + +#. Q9vnd +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id831586291395477\n" +"help.text" +msgid "<input>=FLOOR.PRECISE(-45.67,2)</input> returns -46." +msgstr "" + +#. HnS5F +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"bm_id171586291849333\n" +"help.text" +msgid "<bookmark_value>FLOOR.XCL function</bookmark_value>" +msgstr "" + +#. LMEET +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"hd_id791586291468176\n" +"help.text" +msgid "<variable id=\"FLOOR.XCLh1\"><link href=\"text/scalc/01/func_floor.xhp#floorxcl\" name=\"FLOOR.XCL\">FLOOR.XCL</link></variable>" +msgstr "" + +#. WMsAT +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id521586291476023\n" +"help.text" +msgid "Rounds a number to the nearest multiple of a significance value." +msgstr "" + +#. jrymG +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id401586291488768\n" +"help.text" +msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative." +msgstr "" + +#. BFXRR +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id231586291503319\n" +"help.text" +msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function." +msgstr "" + +#. WA7uC +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id491586291532177\n" +"help.text" +msgid "FLOOR.XCL(Number; Significance)" +msgstr "" + +#. aRww7 +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id761586291578755\n" +"help.text" +msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded." +msgstr "" + +#. HXuMo +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id531586291622306\n" +"help.text" +msgid "<input>=FLOOR.XCL(3.45,2)</input> returns 2." +msgstr "" + +#. gFyGC +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id361586291628003\n" +"help.text" +msgid "<input>=FLOOR.XCL(-45.67,2)</input> returns -46." +msgstr "" + +#. EU7xy +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id801586291641099\n" +"help.text" +msgid "<input>=FLOOR.XCL(-45.67,-2)</input> returns -44." +msgstr "" + #. 2YcR7 #: func_forecastetsadd.xhp msgctxt "" diff --git a/source/ca-valencia/helpcontent2/source/text/swriter/01.po b/source/ca-valencia/helpcontent2/source/text/swriter/01.po index 5cdddf6bc1a..a8967322c48 100644 --- a/source/ca-valencia/helpcontent2/source/text/swriter/01.po +++ b/source/ca-valencia/helpcontent2/source/text/swriter/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-04-03 11:47+0200\n" +"POT-Creation-Date: 2020-04-08 14:22+0200\n" "PO-Revision-Date: 2018-10-21 20:06+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -7307,13 +7307,13 @@ msgctxt "" msgid "Name" msgstr "Nom" -#. Zjnxw +#. kDDEs #: 04090002.xhp msgctxt "" "04090002.xhp\n" "par_id3156259\n" "help.text" -msgid "<variable id=\"FieldValue\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Type the name of the user-defined field that you want to create.</ahelp></variable> To set a target, click \"Set Reference\" in the <emph>Type</emph> list, type a name in this box, and then click <emph>Insert</emph>. To reference the new target, click the target name in the <emph>Selection</emph> list." +msgid "<variable id=\"FieldName\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Type the name of the user-defined field that you want to create.</ahelp></variable> To set a target, click \"Set Reference\" in the <emph>Type</emph> list, type a name in this box, and then click <emph>Insert</emph>. To reference the new target, click the target name in the <emph>Selection</emph> list." msgstr "" #. DRRLC |