diff options
Diffstat (limited to 'source/hr/helpcontent2/source/text/scalc/05.po')
| -rw-r--r-- | source/hr/helpcontent2/source/text/scalc/05.po | 1210 |
1 files changed, 945 insertions, 265 deletions
diff --git a/source/hr/helpcontent2/source/text/scalc/05.po b/source/hr/helpcontent2/source/text/scalc/05.po index 95076b8fef3..9077ad12391 100644 --- a/source/hr/helpcontent2/source/text/scalc/05.po +++ b/source/hr/helpcontent2/source/text/scalc/05.po @@ -1,9 +1,9 @@ -#. extracted from helpcontent2/source/text/scalc/05.oo +#. extracted from helpcontent2/source/text/scalc/05 msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"Report-Msgid-Bugs-To: http://qa.openoffice.org/issues/enter_bug.cgi?comment=&component=l10n&form_name=enter_issue&short_desc=Localization+issue+in+file%3A+helpcontent2%2Fsource%2Ftext%2Fscalc%2F05.oo&subcomponent=ui\n" -"POT-Creation-Date: 2012-06-26 09:53+0200\n" +"Report-Msgid-Bugs-To: https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" +"POT-Creation-Date: 2012-11-17 19:03+0200\n" "PO-Revision-Date: 2011-05-03 10:48+0200\n" "Last-Translator: Andras <timar74@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -12,518 +12,1198 @@ msgstr "" "Content-Type: text/plain; charset=utf-8\n" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n" -"X-Generator: Translate Toolkit 1.9.0\n" +"X-Generator: LibreOffice\n" "X-Accelerator-Marker: ~\n" -#: empty_cells.xhp#tit.help.text -msgid "Handling of Empty Cells" -msgstr "Rukovanje praznim ćelijama" - -#: empty_cells.xhp#bm_id3146799.help.text -msgid "<bookmark_value>empty cells;handling of</bookmark_value>" -msgstr "<bookmark_value>prazne ćelije;rukovanje</bookmark_value>" - -#: empty_cells.xhp#hd_id1502121.help.text -msgid "<variable id=\"empty_cells\"><link href=\"text/scalc/05/empty_cells.xhp\">Handling of Empty Cells</link></variable>" -msgstr "" - -#: empty_cells.xhp#par_id8266853.help.text -msgid "In older versions of the software, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1=\"\" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)=\"\" give TRUE if the lookup resulted in an empty cell being returned. " -msgstr "" - -#: empty_cells.xhp#par_id2733542.help.text -msgid "A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected. " -msgstr "" - -#: empty_cells.xhp#par_id4238715.help.text -msgid "For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:" -msgstr "" - -#: empty_cells.xhp#par_id8277230.help.text -msgid "A1: 1 B1: <empty> C1: =B1 (displays 0)" -msgstr "" - -#: empty_cells.xhp#par_id4086428.help.text -msgctxt "empty_cells.xhp#par_id4086428.help.text" -msgid "=B1=0 => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id9024628.help.text -msgid "=B1=\"\" => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id3067110.help.text -msgid "=C1=0 => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id8841822.help.text -msgid "=C1=\"\" => TRUE (previously was FALSE)" -msgstr "" - -#: empty_cells.xhp#par_id4077578.help.text -msgid "=ISNUMBER(B1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id9094515.help.text -msgid "=ISNUMBER(C1) => FALSE (previously was TRUE)" -msgstr "" - -#: empty_cells.xhp#par_id396740.help.text -msgid "=ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1)" -msgstr "" - -#: empty_cells.xhp#par_id3859675.help.text -msgid "=ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, previously was TRUE)" -msgstr "" - -#: empty_cells.xhp#par_id402233.help.text -msgctxt "empty_cells.xhp#par_id402233.help.text" -msgid "=ISTEXT(B1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id1623889.help.text -msgctxt "empty_cells.xhp#par_id1623889.help.text" -msgid "=ISTEXT(C1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id7781914.help.text -msgid "=ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, previously was TRUE)" -msgstr "" - -#: empty_cells.xhp#par_id300912.help.text -msgid "=ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1)" -msgstr "" - -#: empty_cells.xhp#par_id9534592.help.text -msgid "=ISBLANK(B1) => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id4969328.help.text -msgid "=ISBLANK(C1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id9635914.help.text -msgid "=ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, previously was FALSE)" -msgstr "" - -#: empty_cells.xhp#par_id2476577.help.text -msgid "=ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1)" -msgstr "" - -#: empty_cells.xhp#par_id4217047.help.text -msgid "Note that Microsoft Excel behaves different and always returns a number as the result of a reference to an empty cell or a formula cell with the result of an empty cell. For example:" -msgstr "" - -#: empty_cells.xhp#par_id2629474.help.text -msgid "A1: <empty>" -msgstr "" - -#: empty_cells.xhp#par_id8069704.help.text -msgid "B1: =A1 => displays 0, but is just a reference to an empty cell" -msgstr "" - -#: empty_cells.xhp#par_id4524674.help.text -msgid "=ISNUMBER(A1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id4396801.help.text -msgid "=ISTEXT(A1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id5293740.help.text -msgid "=A1=0 => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id7623828.help.text -msgid "=A1=\"\" => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id2861720.help.text -msgid "=ISNUMBER(B1) => FALSE (MS-Excel: TRUE)" -msgstr "" - -#: empty_cells.xhp#par_id9604480.help.text -msgctxt "empty_cells.xhp#par_id9604480.help.text" -msgid "=ISTEXT(B1) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id2298959.help.text -msgctxt "empty_cells.xhp#par_id2298959.help.text" -msgid "=B1=0 => TRUE" -msgstr "" - -#: empty_cells.xhp#par_id4653767.help.text -msgid "=B1=\"\" => TRUE (MS-Excel: FALSE)" -msgstr "" - -#: empty_cells.xhp#par_id8801538.help.text -msgid "C1: =VLOOKUP(...) with empty cell result => displays empty (MS-Excel: displays 0)" -msgstr "" - -#: empty_cells.xhp#par_id6746421.help.text -msgid "=ISNUMBER(VLOOKUP(...)) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id4876247.help.text -msgid "=ISTEXT(VLOOKUP(...)) => FALSE" -msgstr "" - -#: empty_cells.xhp#par_id7458723.help.text -msgid "=ISNUMBER(C1) => FALSE (MS-Excel: TRUE)" -msgstr "" - -#: empty_cells.xhp#par_id2753379.help.text -msgctxt "empty_cells.xhp#par_id2753379.help.text" -msgid "=ISTEXT(C1) => FALSE" -msgstr "" - -#: 02140000.xhp#tit.help.text +#. aqDD +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"tit\n" +"help.text" msgid "Error Codes in %PRODUCTNAME Calc" msgstr "" -#: 02140000.xhp#bm_id3146797.help.text +#. 0N`* +#: 02140000.xhp #, fuzzy +msgctxt "" +"02140000.xhp\n" +"bm_id3146797\n" +"help.text" msgid "<bookmark_value>error codes;list of</bookmark_value>" msgstr "<bookmark_value>prazne ćelije;rukovanje</bookmark_value>" -#: 02140000.xhp#hd_id3146797.1.help.text +#. 5vtb +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"hd_id3146797\n" +"1\n" +"help.text" msgid "<link href=\"text/scalc/05/02140000.xhp\" name=\"Error Codes in %PRODUCTNAME Calc\">Error Codes in <item type=\"productname\">%PRODUCTNAME</item> Calc</link>" msgstr "" -#: 02140000.xhp#par_id3150275.2.help.text +#. kVo- +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150275\n" +"2\n" +"help.text" msgid "The following table is an overview of the error messages for <item type=\"productname\">%PRODUCTNAME</item> Calc. If the error occurs in the cell that contains the cursor, the error message is displayed on the <emph>Status Bar</emph>." msgstr "" -#: 02140000.xhp#bm_id0202201010205429.help.text +#. xAw] +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"bm_id0202201010205429\n" +"help.text" msgid "<bookmark_value>### error message</bookmark_value>" msgstr "" -#: 02140000.xhp#bm_id3154634.help.text +#. ^FyM +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"bm_id3154634\n" +"help.text" msgid "<bookmark_value>invalid references; error messages</bookmark_value> <bookmark_value>error messages;invalid references</bookmark_value> <bookmark_value>#REF error message</bookmark_value>" msgstr "" -#: 02140000.xhp#bm_id3148428.help.text +#. dV5o +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"bm_id3148428\n" +"help.text" msgid "<bookmark_value>invalid names; error messages</bookmark_value> <bookmark_value>#NAME error message</bookmark_value>" msgstr "" -#: 02140000.xhp#par_id3153968.3.help.text +#. VM)- +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153968\n" +"3\n" +"help.text" msgid "Error Code" msgstr "Broj greške" -#: 02140000.xhp#par_id3125863.4.help.text +#. n8bo +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3125863\n" +"4\n" +"help.text" msgid "Message" msgstr "Poruka" -#: 02140000.xhp#par_id3151112.5.help.text +#. ~[+; +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3151112\n" +"5\n" +"help.text" msgid "Explanation" msgstr "" -#: 02140000.xhp#par_id1668467.help.text +#. /:D@ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id1668467\n" +"help.text" msgid "###" msgstr "###" -#: 02140000.xhp#par_id3165766.13.help.text +#. 9a^j +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3165766\n" +"13\n" +"help.text" msgid "none" msgstr "ništa" -#: 02140000.xhp#par_id3169266.14.help.text +#. K/zf +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3169266\n" +"14\n" +"help.text" msgid "The cell is not wide enough to display the contents." msgstr "" -#: 02140000.xhp#par_id3153188.6.help.text +#. ^$69 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153188\n" +"6\n" +"help.text" msgid "501" msgstr "" -#: 02140000.xhp#par_id3148645.7.help.text +#. $6Jw +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148645\n" +"7\n" +"help.text" msgid "Invalid character" msgstr "" -#: 02140000.xhp#par_id3155854.8.help.text +#. *_lP +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155854\n" +"8\n" +"help.text" msgid "Character in a formula is not valid." msgstr "" -#: 02140000.xhp#par_id3145253.9.help.text +#. dO#M +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145253\n" +"9\n" +"help.text" msgid "502" msgstr "" -#: 02140000.xhp#par_id3147397.10.help.text +#. %eu1 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147397\n" +"10\n" +"help.text" msgid "Invalid argument" msgstr "Nedozvoljeni argument" -#: 02140000.xhp#par_id3153160.11.help.text +#. 4b+l +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153160\n" +"11\n" +"help.text" msgid "Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT()." msgstr "" -#: 02140000.xhp#par_id3154015.12.help.text +#. HCpM +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154015\n" +"12\n" +"help.text" msgid "503<br/>#NUM!" msgstr "" -#: 02140000.xhp#par_id3155766.13.help.text +#. e$~0 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155766\n" +"13\n" +"help.text" msgid "Invalid floating point operation" msgstr "" -#: 02140000.xhp#par_id3159266.14.help.text +#. 8WRV +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3159266\n" +"14\n" +"help.text" msgid "A calculation results in an overflow of the defined value range." msgstr "" -#: 02140000.xhp#par_id3149258.15.help.text +#. LoA$ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149258\n" +"15\n" +"help.text" msgid "504" msgstr "" -#: 02140000.xhp#par_id3147344.16.help.text +#. |@(F +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147344\n" +"16\n" +"help.text" msgid "Parameter list error" msgstr "" -#: 02140000.xhp#par_id3147003.17.help.text +#. ^9~3 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147003\n" +"17\n" +"help.text" msgid "Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference." msgstr "" -#: 02140000.xhp#par_id3154532.27.help.text +#. PSZq +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154532\n" +"27\n" +"help.text" msgid "508" msgstr "" -#: 02140000.xhp#par_id3150107.28.help.text +#. xB9* +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150107\n" +"28\n" +"help.text" msgid "Error: Pair missing" msgstr "" -#: 02140000.xhp#par_id3149129.29.help.text +#. wiG} +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149129\n" +"29\n" +"help.text" msgid "Missing bracket, for example, closing brackets, but no opening brackets" msgstr "" -#: 02140000.xhp#par_id3149895.30.help.text +#. i2/I +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149895\n" +"30\n" +"help.text" msgid "509" msgstr "" -#: 02140000.xhp#par_id3155097.31.help.text +#. 8Q[A +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155097\n" +"31\n" +"help.text" msgid "Missing operator" msgstr "" -#: 02140000.xhp#par_id3154649.32.help.text +#. JVE1 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154649\n" +"32\n" +"help.text" msgid "Operator is missing, for example, \"=2(3+4) * \", where the operator between \"2\" and \"(\" is missing." msgstr "" -#: 02140000.xhp#par_id3153813.33.help.text +#. :|+m +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153813\n" +"33\n" +"help.text" msgid "510" msgstr "" -#: 02140000.xhp#par_id3153483.34.help.text -msgctxt "02140000.xhp#par_id3153483.34.help.text" +#. a^!U +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153483\n" +"34\n" +"help.text" msgid "Missing variable" msgstr "" -#: 02140000.xhp#par_id3154710.35.help.text +#. 2Is4 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154710\n" +"35\n" +"help.text" msgid "Variable is missing, for example when two operators are together \"=1+*2\"." msgstr "" -#: 02140000.xhp#par_id3154739.36.help.text +#. 7YMG +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154739\n" +"36\n" +"help.text" msgid "511" msgstr "" -#: 02140000.xhp#par_id3145112.37.help.text -msgctxt "02140000.xhp#par_id3145112.37.help.text" +#. gQE) +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145112\n" +"37\n" +"help.text" msgid "Missing variable" msgstr "" -#: 02140000.xhp#par_id3145319.38.help.text +#. K%K] +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145319\n" +"38\n" +"help.text" msgid "Function requires more variables than are provided, for example, AND() and OR()." msgstr "" -#: 02140000.xhp#par_id3149050.39.help.text +#. L*-V +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149050\n" +"39\n" +"help.text" msgid "512" msgstr "512" -#: 02140000.xhp#par_id3150393.40.help.text +#. #$W? +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150393\n" +"40\n" +"help.text" msgid "Formula overflow" msgstr "" -#: 02140000.xhp#par_id3159259.41.help.text -msgid " <emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512." +#. (,Bu +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3159259\n" +"41\n" +"help.text" +msgid "<emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512." msgstr "" -#: 02140000.xhp#par_id3150537.42.help.text +#. !E)\ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150537\n" +"42\n" +"help.text" msgid "513" msgstr "" -#: 02140000.xhp#par_id3147412.43.help.text +#. c[J% +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147412\n" +"43\n" +"help.text" msgid "String overflow" msgstr "" -#: 02140000.xhp#par_id3145635.44.help.text -msgid " <emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in size." +#. TB/p +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145635\n" +"44\n" +"help.text" +msgid "<emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in size." msgstr "" -#: 02140000.xhp#par_id3149147.45.help.text +#. \TKo +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149147\n" +"45\n" +"help.text" msgid "514" msgstr "" -#: 02140000.xhp#par_id3157904.46.help.text -msgctxt "02140000.xhp#par_id3157904.46.help.text" +#. iL0# +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3157904\n" +"46\n" +"help.text" msgid "Internal overflow" msgstr "" -#: 02140000.xhp#par_id3149352.47.help.text +#. 5f2B +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149352\n" +"47\n" +"help.text" msgid "Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow." msgstr "" -#: 02140000.xhp#par_id3154841.51.help.text +#. ($?. +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154841\n" +"51\n" +"help.text" msgid "516" msgstr "" -#: 02140000.xhp#par_id3147423.52.help.text -msgctxt "02140000.xhp#par_id3147423.52.help.text" +#. Y\k2 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147423\n" +"52\n" +"help.text" msgid "Internal syntax error" msgstr "" -#: 02140000.xhp#par_id3148437.53.help.text +#. lCrb +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148437\n" +"53\n" +"help.text" msgid "Matrix is expected on the calculation stack, but is not available." msgstr "" -#: 02140000.xhp#par_id3155261.54.help.text +#. pn;x +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155261\n" +"54\n" +"help.text" msgid "517" msgstr "" -#: 02140000.xhp#par_id3153934.55.help.text -msgctxt "02140000.xhp#par_id3153934.55.help.text" +#. -T2+ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153934\n" +"55\n" +"help.text" msgid "Internal syntax error" msgstr "" -#: 02140000.xhp#par_id3149507.56.help.text +#. yXC: +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149507\n" +"56\n" +"help.text" msgid "Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function." msgstr "" -#: 02140000.xhp#par_id3148585.57.help.text +#. Uod) +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148585\n" +"57\n" +"help.text" msgid "518" msgstr "" -#: 02140000.xhp#par_id3149189.58.help.text -msgctxt "02140000.xhp#par_id3149189.58.help.text" +#. AH0= +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149189\n" +"58\n" +"help.text" msgid "Internal syntax error" msgstr "" -#: 02140000.xhp#par_id3149545.59.help.text +#. 7QPr +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149545\n" +"59\n" +"help.text" msgid "Variable is not available" msgstr "" -#: 02140000.xhp#par_id3146142.60.help.text +#. Fl`@ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3146142\n" +"60\n" +"help.text" msgid "519<br/>#VALUE" msgstr "" -#: 02140000.xhp#par_id3155954.61.help.text +#. 0u*+ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155954\n" +"61\n" +"help.text" msgid "No result (#VALUE is in the cell rather than Err:519!)" msgstr "" -#: 02140000.xhp#par_id3153108.62.help.text +#. ?EZr +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153108\n" +"62\n" +"help.text" msgid "The formula yields a value that does not correspond to the definition; or a cell that is referenced in the formula contains text instead of a number." msgstr "" -#: 02140000.xhp#par_id3150338.63.help.text +#. ~6z^ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150338\n" +"63\n" +"help.text" msgid "520" msgstr "" -#: 02140000.xhp#par_id3150017.64.help.text -msgctxt "02140000.xhp#par_id3150017.64.help.text" +#. v=}8 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150017\n" +"64\n" +"help.text" msgid "Internal syntax error" msgstr "" -#: 02140000.xhp#par_id3148758.65.help.text +#. /7MT +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148758\n" +"65\n" +"help.text" msgid "Compiler creates an unknown compiler code." msgstr "" -#: 02140000.xhp#par_id3154324.66.help.text +#. pF{S +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154324\n" +"66\n" +"help.text" msgid "521" msgstr "" -#: 02140000.xhp#par_id3153737.67.help.text -msgctxt "02140000.xhp#par_id3153737.67.help.text" +#. 7J$T +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153737\n" +"67\n" +"help.text" msgid "Internal syntax error" msgstr "" -#: 02140000.xhp#par_id3155436.68.help.text +#. #Vis +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155436\n" +"68\n" +"help.text" msgid "No result." msgstr "" -#: 02140000.xhp#par_id3153045.69.help.text +#. n?oO +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153045\n" +"69\n" +"help.text" msgid "522" msgstr "" -#: 02140000.xhp#par_id3149008.70.help.text +#. CV,f +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149008\n" +"70\n" +"help.text" msgid "Circular reference" msgstr "" -#: 02140000.xhp#par_id3157972.71.help.text +#. 6{+z +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3157972\n" +"71\n" +"help.text" msgid "Formula refers directly or indirectly to itself and the <emph>Iterations</emph> option is not set under <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Calculate." msgstr "" -#: 02140000.xhp#par_id3149538.72.help.text +#. )B^z +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149538\n" +"72\n" +"help.text" msgid "523" msgstr "" -#: 02140000.xhp#par_id3150930.73.help.text +#. @J6S +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150930\n" +"73\n" +"help.text" msgid "The calculation procedure does not converge" msgstr "" -#: 02140000.xhp#par_id3150272.74.help.text +#. r(r8 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150272\n" +"74\n" +"help.text" msgid "Function missed a targeted value, or <link href=\"text/shared/optionen/01060500.xhp\">iterative references</link> do not reach the minimum change within the maximum steps that are set." msgstr "" -#: 02140000.xhp#par_id3153544.75.help.text +#. -M59 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153544\n" +"75\n" +"help.text" msgid "524<br/>#REF" msgstr "" -#: 02140000.xhp#par_id3154634.76.help.text +#. =R7D +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154634\n" +"76\n" +"help.text" msgid "invalid references (instead of Err:524 cell contains #REF)" msgstr "" -#: 02140000.xhp#par_id3147539.77.help.text -msgid " <emph>Compiler:</emph> a column or row description name could not be resolved. <emph>Interpreter:</emph> in a formula, the column, row, or sheet that contains a referenced cell is missing." +#. tIBn +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147539\n" +"77\n" +"help.text" +msgid "<emph>Compiler:</emph> a column or row description name could not be resolved. <emph>Interpreter:</emph> in a formula, the column, row, or sheet that contains a referenced cell is missing." msgstr "" -#: 02140000.xhp#par_id3155984.78.help.text +#. \,34 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155984\n" +"78\n" +"help.text" msgid "525<br/>#NAME?" msgstr "" -#: 02140000.xhp#par_id3148428.79.help.text +#. J?;W +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148428\n" +"79\n" +"help.text" msgid "invalid names (instead of Err:525 cell contains #NAME?)" msgstr "" -#: 02140000.xhp#par_id3156259.80.help.text +#. rF%= +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3156259\n" +"80\n" +"help.text" msgid "An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, no macro, incorrect decimal divider, add-in not found." msgstr "" -#: 02140000.xhp#par_id3153720.81.help.text +#. VFvf +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153720\n" +"81\n" +"help.text" msgid "526" msgstr "" -#: 02140000.xhp#par_id3154315.82.help.text -msgctxt "02140000.xhp#par_id3154315.82.help.text" +#. l+t4 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154315\n" +"82\n" +"help.text" msgid "Internal syntax error" msgstr "" -#: 02140000.xhp#par_id3083286.83.help.text +#. huS3 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3083286\n" +"83\n" +"help.text" msgid "Obsolete, no longer used, but could come from old documents if the result is a formula from a domain." msgstr "" -#: 02140000.xhp#par_id3152483.84.help.text +#. q|NZ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3152483\n" +"84\n" +"help.text" msgid "527" msgstr "" -#: 02140000.xhp#par_id3152966.85.help.text -msgctxt "02140000.xhp#par_id3152966.85.help.text" +#. /x$w +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3152966\n" +"85\n" +"help.text" msgid "Internal overflow" msgstr "" -#: 02140000.xhp#par_id3149709.86.help.text -msgid " <emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated." +#. ?Jl8 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149709\n" +"86\n" +"help.text" +msgid "<emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated." msgstr "" -#: 02140000.xhp#par_id5324564.help.text +#. 4D}A +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id5324564\n" +"help.text" msgid "532<br/>#DIV/0!" msgstr "" -#: 02140000.xhp#par_id7941831.help.text +#. [oD\ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id7941831\n" +"help.text" msgid "Division by zero" msgstr "Dijeljenje s nulom" -#: 02140000.xhp#par_id5844294.help.text +#. `or7 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id5844294\n" +"help.text" msgid "Division operator / if the denominator is 0<br/>Some more functions return this error, for example:<br/>VARP with less than 1 argument<br/>STDEVP with less than 1 argument<br/>VAR with less than 2 arguments<br/>STDEV with less than 2 arguments<br/>STANDARDIZE with stdev=0<br/>NORMDIST with stdev=0" msgstr "" + +#. _1@@ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"tit\n" +"help.text" +msgid "Handling of Empty Cells" +msgstr "Rukovanje praznim ćelijama" + +#. -KvH +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"bm_id3146799\n" +"help.text" +msgid "<bookmark_value>empty cells;handling of</bookmark_value>" +msgstr "<bookmark_value>prazne ćelije;rukovanje</bookmark_value>" + +#. IPo, +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"hd_id1502121\n" +"help.text" +msgid "<variable id=\"empty_cells\"><link href=\"text/scalc/05/empty_cells.xhp\">Handling of Empty Cells</link></variable>" +msgstr "" + +#. 0j4[ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id8266853\n" +"help.text" +msgid "In older versions of the software, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1=\"\" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)=\"\" give TRUE if the lookup resulted in an empty cell being returned." +msgstr "" + +#. mr|L +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id2733542\n" +"help.text" +msgid "A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected." +msgstr "" + +#. ]OiA +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4238715\n" +"help.text" +msgid "For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:" +msgstr "" + +#. !p+6 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id8277230\n" +"help.text" +msgid "A1: 1 B1: <empty> C1: =B1 (displays 0)" +msgstr "" + +#. 0fME +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4086428\n" +"help.text" +msgid "=B1=0 => TRUE" +msgstr "" + +#. B_:U +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id9024628\n" +"help.text" +msgid "=B1=\"\" => TRUE" +msgstr "" + +#. wVu# +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id3067110\n" +"help.text" +msgid "=C1=0 => TRUE" +msgstr "" + +#. z+bK +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id8841822\n" +"help.text" +msgid "=C1=\"\" => TRUE (previously was FALSE)" +msgstr "" + +#. Tbmx +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4077578\n" +"help.text" +msgid "=ISNUMBER(B1) => FALSE" +msgstr "" + +#. h0Q] +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id9094515\n" +"help.text" +msgid "=ISNUMBER(C1) => FALSE (previously was TRUE)" +msgstr "" + +#. HPOI +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id396740\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1)" +msgstr "" + +#. qIUC +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id3859675\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, previously was TRUE)" +msgstr "" + +#. [Aea +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id402233\n" +"help.text" +msgid "=ISTEXT(B1) => FALSE" +msgstr "" + +#. ndkI +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id1623889\n" +"help.text" +msgid "=ISTEXT(C1) => FALSE" +msgstr "" + +#. KpH0 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id7781914\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, previously was TRUE)" +msgstr "" + +#. M1%O +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id300912\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1)" +msgstr "" + +#. #Y74 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id9534592\n" +"help.text" +msgid "=ISBLANK(B1) => TRUE" +msgstr "" + +#. Wz8} +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4969328\n" +"help.text" +msgid "=ISBLANK(C1) => FALSE" +msgstr "" + +#. l},# +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id9635914\n" +"help.text" +msgid "=ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, previously was FALSE)" +msgstr "" + +#. APFY +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id2476577\n" +"help.text" +msgid "=ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1)" +msgstr "" + +#. d8Uo +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4217047\n" +"help.text" +msgid "Note that Microsoft Excel behaves different and always returns a number as the result of a reference to an empty cell or a formula cell with the result of an empty cell. For example:" +msgstr "" + +#. ?%Go +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id2629474\n" +"help.text" +msgid "A1: <empty>" +msgstr "" + +#. !ED7 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id8069704\n" +"help.text" +msgid "B1: =A1 => displays 0, but is just a reference to an empty cell" +msgstr "" + +#. YNTk +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4524674\n" +"help.text" +msgid "=ISNUMBER(A1) => FALSE" +msgstr "" + +#. $$4? +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4396801\n" +"help.text" +msgid "=ISTEXT(A1) => FALSE" +msgstr "" + +#. kgE? +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id5293740\n" +"help.text" +msgid "=A1=0 => TRUE" +msgstr "" + +#. flqd +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id7623828\n" +"help.text" +msgid "=A1=\"\" => TRUE" +msgstr "" + +#. 4u$N +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id2861720\n" +"help.text" +msgid "=ISNUMBER(B1) => FALSE (MS-Excel: TRUE)" +msgstr "" + +#. lWu[ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id9604480\n" +"help.text" +msgid "=ISTEXT(B1) => FALSE" +msgstr "" + +#. `pU\ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id2298959\n" +"help.text" +msgid "=B1=0 => TRUE" +msgstr "" + +#. R`XK +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4653767\n" +"help.text" +msgid "=B1=\"\" => TRUE (MS-Excel: FALSE)" +msgstr "" + +#. QK-/ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id8801538\n" +"help.text" +msgid "C1: =VLOOKUP(...) with empty cell result => displays empty (MS-Excel: displays 0)" +msgstr "" + +#. yA=u +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id6746421\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(...)) => FALSE" +msgstr "" + +#. M0CE +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id4876247\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(...)) => FALSE" +msgstr "" + +#. Jd@n +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id7458723\n" +"help.text" +msgid "=ISNUMBER(C1) => FALSE (MS-Excel: TRUE)" +msgstr "" + +#. /+%B +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id2753379\n" +"help.text" +msgid "=ISTEXT(C1) => FALSE" +msgstr "" |