diff options
Diffstat (limited to 'translations/source/tg/helpcontent2/source/text/scalc/05.po')
| -rw-r--r-- | translations/source/tg/helpcontent2/source/text/scalc/05.po | 1205 |
1 files changed, 1205 insertions, 0 deletions
diff --git a/translations/source/tg/helpcontent2/source/text/scalc/05.po b/translations/source/tg/helpcontent2/source/text/scalc/05.po new file mode 100644 index 000000000..bb4302ad0 --- /dev/null +++ b/translations/source/tg/helpcontent2/source/text/scalc/05.po @@ -0,0 +1,1205 @@ +#. extracted from helpcontent2/source/text/scalc/05 +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: 2022-01-31 18:19+0100\n" +"PO-Revision-Date: 2018-09-03 13:29+0000\n" +"Last-Translator: Anonymous Pootle User\n" +"Language-Team: LANGUAGE <LL@li.org>\n" +"Language: tg\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=utf-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=2; plural=(n != 1);\n" +"X-Accelerator-Marker: ~\n" +"X-Generator: LibreOffice\n" +"X-POOTLE-MTIME: 1535981358.000000\n" + +#. Cxzki +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"tit\n" +"help.text" +msgid "Error Codes in %PRODUCTNAME Calc" +msgstr "Коди хато дар %PRODUCTNAME Calc" + +#. DTQVB +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"bm_id3146797\n" +"help.text" +msgid "<bookmark_value>error codes;list of</bookmark_value>" +msgstr "" + +#. tQSnG +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"hd_id3146797\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 "<link href=\"text/scalc/05/02140000.xhp\" name=\"Error Codes in %PRODUCTNAME Calc\">Кодҳои хато дар <item type=\"productname\">%PRODUCTNAME</item> Calc</link>" + +#. B8xxG +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150275\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 "Ҷадвали зер дорои маълумоти мухтасар оиди хатоҳои<item type=\"productname\">%PRODUCTNAME</item> Calc мебошад. Агар дар чашмак хато рух диҳад, онгоҳ хато дар <emph>Сатри ҳолат</emph>нишон дода мешавад." + +#. if8BJ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"bm_id0202201010205429\n" +"help.text" +msgid "<bookmark_value>### error message</bookmark_value>" +msgstr "" + +#. Po6SQ +#: 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 "" + +#. k8cUm +#: 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 "<bookmark_value>номи ғалатӣ; хато</bookmark_value><bookmark_value>хатои #NAME </bookmark_value>" + +#. xVUPK +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153968\n" +"help.text" +msgid "Error Code" +msgstr "Коди хато" + +#. g3Daf +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3125863\n" +"help.text" +msgid "Message" +msgstr "Хабар" + +#. VMubU +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3151112\n" +"help.text" +msgid "Explanation" +msgstr "Шарҳ" + +#. yWDxR +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3165766\n" +"help.text" +msgid "none" +msgstr "ягон" + +#. MEFVX +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3169266\n" +"help.text" +msgid "The cell is not wide enough to display the contents." +msgstr "" + +#. vF3za +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3165767\n" +"help.text" +msgid "none" +msgstr "" + +#. 6s9C6 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3169267\n" +"help.text" +msgid "This value is outside of limits valid for this format" +msgstr "" + +#. ApVjg +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148645\n" +"help.text" +msgid "Invalid character" +msgstr "Рамзи ғалатӣ" + +#. Eiafx +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155854\n" +"help.text" +msgid "Character in a formula is not valid." +msgstr "Рамз дар формула ғалатӣ аст, мисол \"=1Eq\" ба ҷои \"=1E2\"." + +#. prgrW +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147397\n" +"help.text" +msgid "Invalid argument" +msgstr "Аргументи ғалатӣ" + +#. Ynv5c +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153160\n" +"help.text" +msgid "Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT()." +msgstr "" + +#. XtB4F +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154015\n" +"help.text" +msgid "503<br/>#NUM!" +msgstr "" + +#. JWvJX +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155766\n" +"help.text" +msgid "Invalid floating point operation" +msgstr "Амали ғалатии нуқтаи шинокун" + +#. UFyAw +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3159266\n" +"help.text" +msgid "A calculation results in an overflow of the defined value range." +msgstr "Тақсим ба 0, ё дигар ҳисобкунӣ, ки натиҷаи нодурусти арзишҳои додашуда мебошад." + +#. EnQy4 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147344\n" +"help.text" +msgid "Parameter list error" +msgstr "Хатои параметрҳои рӯйхат" + +#. HE3Sh +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147003\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 "Параметри функтсия ғалат аст, мисол, матн дар ҷои рақам." + +#. tazac +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150107\n" +"help.text" +msgid "Error: Pair missing" +msgstr "Хато: Ҷуфт вуҷуд надорад" + +#. CvpDc +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149129\n" +"help.text" +msgid "Missing bracket, for example, closing brackets, but no opening brackets" +msgstr "Қавс вуҷуд надорад, мисол қавси пӯшиш на қавси кушоиш" + +#. iTRKB +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155097\n" +"help.text" +msgid "Missing operator" +msgstr "Оператор намерасад" + +#. BzU6T +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154649\n" +"help.text" +msgid "Operator is missing, for example, \"=2(3+4) * \", where the operator between \"2\" and \"(\" is missing." +msgstr "Оператор вуҷуд надорад, мисол \"=2(3+4) * \", ки оператри миҳни \"2\" ва \"(\" вуҷуд надорад." + +#. Wh5hy +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153483\n" +"help.text" +msgid "Missing variable" +msgstr "Тағирҳбанда вуҷуд надорад" + +#. NCtXf +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154710\n" +"help.text" +msgid "Variable is missing, for example when two operators are together \"=1+*2\"." +msgstr "Тағирҳбанда вуҷуд надорад, мисол ду оператор бе тағирёбанда пайвастанд \"=1+*2\"." + +#. VFzXS +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145112\n" +"help.text" +msgid "Missing variable" +msgstr "Тағирҳбанда вуҷуд надорад" + +#. oEvWy +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145319\n" +"help.text" +msgid "Function requires more variables than are provided, for example, AND() and OR()." +msgstr "Функтсия тағирёбандаи зиёд мехоҳад, мисол AND() ва OR()." + +#. 3VQCp +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150393\n" +"help.text" +msgid "Formula overflow" +msgstr "Хатои формула" + +#. rJXWR +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3159259\n" +"help.text" +msgid "<emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 8192." +msgstr "" + +#. T3ZaN +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147412\n" +"help.text" +msgid "String overflow" +msgstr "Барзиёдии силсила" + +#. XbagT +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3145635\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 "" + +#. E7ohJ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3157904\n" +"help.text" +msgid "Internal overflow" +msgstr "Барзиёдии дохилӣ" + +#. GsAC7 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149352\n" +"help.text" +msgid "Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow." +msgstr "Оператсияи низомноккунӣ дар шумораи зиёди далелҳои рақамӣ (max. 100000) ё барзиёдӣ дар анбори ҳисоб." + +#. LKnWm +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147424\n" +"help.text" +msgid "Internal syntax error" +msgstr "" + +#. 8f6zE +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148438\n" +"help.text" +msgid "Unknown error." +msgstr "" + +#. voVnC +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147423\n" +"help.text" +msgid "Internal syntax error" +msgstr "Хатои синтаксисии дохилӣ" + +#. ZqovV +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148437\n" +"help.text" +msgid "Matrix is expected on the calculation stack, but is not available." +msgstr "Дар анбори ҳисобкунӣ матритса дар назар дошта шудааст, вале вуҷуд надорад." + +#. VoVHv +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153934\n" +"help.text" +msgid "Internal syntax error" +msgstr "Хатои синтаксисии дохилӣ" + +#. iTiDA +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149507\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 "Коди номаълум, мисол ҳуҷҷати дорои функтсияи нав ба версияи кӯҳна гузошта шудааст, ки ин функтсияро надорад." + +#. oRBwe +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149189\n" +"help.text" +msgid "Internal syntax error" +msgstr "Хатои синтаксисии дохилӣ" + +#. VMwqF +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149545\n" +"help.text" +msgid "Variable is not available" +msgstr "Тағирёбанда вуҷуд надорад" + +#. 3Ewjd +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3146142\n" +"help.text" +msgid "519<br/>#VALUE!" +msgstr "" + +#. c9Gyw +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155954\n" +"help.text" +msgid "No value (instead of Err:519 cell displays #VALUE!)" +msgstr "" + +#. cf6oh +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153108\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 "Формула арзиши ба маёсад номувофиқро қабул намекунад, ё чашмаки ҳаволашуда дар ҷои рақам матн дорад." + +#. z3KSt +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150017\n" +"help.text" +msgid "Internal syntax error" +msgstr "Хатои синтаксисии дохилӣ" + +#. 9JdQC +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148758\n" +"help.text" +msgid "Compiler creates an unknown compiler code." +msgstr "Компилятор коди номаълум месозад." + +#. xbiK9 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153737\n" +"help.text" +msgid "Internal syntax error (instead of Err:521 cell displays #NULL!)" +msgstr "" + +#. AiUic +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155436\n" +"help.text" +msgid "No code or no result." +msgstr "" + +#. SWNv6 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149008\n" +"help.text" +msgid "Circular reference" +msgstr "Ҳаволаи сарбаста" + +#. SNPhH +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3157972\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 "Формула бавосита ё бевосита ба худаш ишора мекунад ва параметри <emph>Итератсия</emph> дар Асбобҳо - Параметрҳо - %PRODUCTNAME Calc - Ҳисобкунӣ интихоб нашудааст." + +#. Z3Q9Q +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150930\n" +"help.text" +msgid "The calculation procedure does not converge" +msgstr "Протседураи ҳисоб мувофиқ нест" + +#. T3NrF +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3150272\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 "Функтсия арзиши натиҷавиро гум кард, ё <link href=\"text/shared/optionen/01060500.xhp\">ҳаволаҳои инеративӣ </link> бо қадамҳои максималии гузошташуда ба тағиротҳои минималӣ намерасанд." + +#. K9EbP +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3153544\n" +"help.text" +msgid "524<br/>#REF!" +msgstr "" + +#. aHB3e +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154634\n" +"help.text" +msgid "Not a valid reference (instead of Err:524 cell displays #REF!)" +msgstr "" + +#. iGGQE +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147539\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 "<emph>Компилятор:</emph> номи шарҳи сутун ё сатр муқаррар карда нашуд. <emph>Интерпритер:</emph> дар формула, сутун, сатр, ё саҳифае, ки ҳавола шудааст вуҷуд надорад." + +#. XgsB8 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155984\n" +"help.text" +msgid "525<br/>#NAME?" +msgstr "" + +#. KxXmj +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3148428\n" +"help.text" +msgid "invalid names (instead of Err:525 cell displays #NAME?)" +msgstr "" + +#. pTzCU +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3156259\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 "Муайянкунанда санҷида нашуд, мисол ҳаволаи ғалатӣ, номи нодурусти домейн, номи сутун/сатр вуҷуд надорад, макро вуҷуд надорад, тақсимкунандаи ғалатии даҳӣ, васлак пайдо нашуд." + +#. sJuxt +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154315\n" +"help.text" +msgid "Internal syntax error" +msgstr "Хатои синтаксисии дохилӣ" + +#. v7KEg +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3083286\n" +"help.text" +msgid "Obsolete, no longer used, but could come from old documents if the result is a formula from a domain." +msgstr "Мансӯқ, дигар истифода намешавад, вале метавонад дар ҳуҷҷатҳои кӯҳна вохурад." + +#. M3m5X +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3152966\n" +"help.text" +msgid "Internal overflow" +msgstr "Барзиёдии дохилӣ" + +#. UsyTo +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149709\n" +"help.text" +msgid "<emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated." +msgstr "<emph>Интерпритор: </emph>Ҳаволаҳо, ба мисли чашмак ба чашмак, хеле мураккабанд." + +#. 2ECY7 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id4152967\n" +"help.text" +msgid "No AddIn" +msgstr "" + +#. zaCCw +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149710\n" +"help.text" +msgid "<emph>Interpreter: </emph>AddIn not found." +msgstr "" + +#. kAqvA +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3152967\n" +"help.text" +msgid "No Macro" +msgstr "" + +#. 6S7DQ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3149711\n" +"help.text" +msgid "<emph>Interpreter: </emph>Macro not found." +msgstr "" + +#. gBQnb +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id5324564\n" +"help.text" +msgid "532<br/>#DIV/0!" +msgstr "" + +#. sfCB6 +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id7941831\n" +"help.text" +msgid "Division by zero" +msgstr "" + +#. BC4Gt +#: 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 "" + +#. qUCvU +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id951549820044260\n" +"help.text" +msgid "Nested arrays are not supported" +msgstr "" + +#. GVEyH +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id781549820065619\n" +"help.text" +msgid "For example, ={1;{2}}" +msgstr "" + +#. ejYrQ +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id521549825734781\n" +"help.text" +msgid "Error: Array or matrix size" +msgstr "" + +#. GXCEU +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id931549825818729\n" +"help.text" +msgid "Unsupported inline array content" +msgstr "" + +#. 6EgLN +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id551549825825905\n" +"help.text" +msgid "For example, ={1+2}" +msgstr "" + +#. Nhzyi +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id131549825893410\n" +"help.text" +msgid "External content disabled" +msgstr "" + +#. XT6PG +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id881549825900965\n" +"help.text" +msgid "Happens if a function that requires (re)loading of external sources is encountered and the user hasn't confirmed reloading of external sources yet" +msgstr "" + +#. f9Foc +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"tit\n" +"help.text" +msgid "Handling of Empty Cells" +msgstr "" + +#. nVAzC +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"bm_id3146799\n" +"help.text" +msgid "<bookmark_value>empty cells;handling of</bookmark_value>" +msgstr "" + +#. VYKrS +#: 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 "" + +#. TB34B +#: 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 "" + +#. FKFTK +#: 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 "" + +#. sHJvH +#: 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 "" + +#. DFVNU +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id291535142746121\n" +"help.text" +msgid "Case" +msgstr "" + +#. 5pQ8p +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id441535142746121\n" +"help.text" +msgid "Formula" +msgstr "" + +#. siSXA +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id261535142746121\n" +"help.text" +msgid "Results and comments" +msgstr "" + +#. y3GkG +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id941535142746122\n" +"help.text" +msgid "A1: 1<br/>B1: <Empty>" +msgstr "" + +#. y3NDD +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id851535142746123\n" +"help.text" +msgid "Displays 0" +msgstr "" + +#. x3Fkf +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id981535142948275\n" +"help.text" +msgid "<variable id=\"vtrue\">TRUE</variable>" +msgstr "" + +#. jGD6d +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id1001535143031604\n" +"help.text" +msgid "TRUE (previously was FALSE)" +msgstr "" + +#. rLs5m +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id201535143064244\n" +"help.text" +msgid "=ISNUMBER(B1)" +msgstr "" + +#. aBBEF +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id421535143064245\n" +"help.text" +msgid "<variable id=\"vfalse\">FALSE</variable>" +msgstr "" + +#. 8taRG +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id681535143124250\n" +"help.text" +msgid "=ISNUMBER(C1)" +msgstr "" + +#. srU2T +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id211535143124250\n" +"help.text" +msgid "FALSE (previously was TRUE)" +msgstr "" + +#. gUyG5 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id221535143151829\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;2))" +msgstr "" + +#. eHH8h +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id271535143151830\n" +"help.text" +msgid "FALSE (B1)" +msgstr "" + +#. 24jXb +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id861535143183196\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;3))" +msgstr "" + +#. TGuuU +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id371535143183197\n" +"help.text" +msgid "FALSE (C1, previously was TRUE)" +msgstr "" + +#. td3QN +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id191535143228538\n" +"help.text" +msgid "=ISTEXT(B1)" +msgstr "" + +#. usWWT +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id251535143279847\n" +"help.text" +msgid "=ISTEXT(C1)" +msgstr "" + +#. MoQBw +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id641535143301636\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(1;A1:C1;2))" +msgstr "" + +#. DCsDd +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id391535143301637\n" +"help.text" +msgid "FALSE (B1, previously was TRUE)" +msgstr "" + +#. aBByS +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id661535143336012\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(1;A1:C1;3))" +msgstr "" + +#. wyXe6 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id11535143336012\n" +"help.text" +msgid "FALSE (C1)" +msgstr "" + +#. kkBGf +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id661535143373396\n" +"help.text" +msgid "=ISBLANK(B1)" +msgstr "" + +#. 7m34D +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id281535143396581\n" +"help.text" +msgid "=ISBLANK(C1)" +msgstr "" + +#. NCnu6 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id31535143422248\n" +"help.text" +msgid "=ISBLANK(VLOOKUP(1;A1:C1;2))" +msgstr "" + +#. YXdDe +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id871535143422248\n" +"help.text" +msgid "TRUE (B1, previously was FALSE)" +msgstr "" + +#. us9L8 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id731535143454577\n" +"help.text" +msgid "=ISBLANK(VLOOKUP(1;A1:C1;3))" +msgstr "" + +#. 6PxBF +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id941535143454577\n" +"help.text" +msgid "FALSE (C1)" +msgstr "" + +#. wAsrJ +#: 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 "" + +#. YCDpa +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id251535143557533\n" +"help.text" +msgid "Case" +msgstr "" + +#. t8EJk +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id441535143557533\n" +"help.text" +msgid "Formula" +msgstr "" + +#. 23UDU +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id481535143557533\n" +"help.text" +msgid "Results and comments" +msgstr "" + +#. 87W9A +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id311535143557534\n" +"help.text" +msgid "A1: <Empty>" +msgstr "" + +#. NaWZa +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id961535143557535\n" +"help.text" +msgid "Displays 0, but is just a reference to an empty cell." +msgstr "" + +#. GJtfQ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id441535143762523\n" +"help.text" +msgid "=ISNUMBER(A1)" +msgstr "" + +#. GZbTC +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id751535143810734\n" +"help.text" +msgid "=ISTEXT(A1)" +msgstr "" + +#. ag84f +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id121535143920008\n" +"help.text" +msgid "=ISNUMBER(B1)" +msgstr "" + +#. XHXqn +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id391535143920009\n" +"help.text" +msgid "FALSE (Microsoft Excel: TRUE)" +msgstr "" + +#. ndXeg +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id371535143961386\n" +"help.text" +msgid "=ISTEXT(B1)" +msgstr "" + +#. xykic +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id111535144016852\n" +"help.text" +msgid "TRUE (Microsoft Excel: FALSE)" +msgstr "" + +#. JGAPT +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id771535144043975\n" +"help.text" +msgid "C1: =VLOOKUP(...) with empty cell result" +msgstr "" + +#. 7rzAj +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id311535144043975\n" +"help.text" +msgid "displays empty (Microsoft Excel: displays 0)" +msgstr "" + +#. QZZQE +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id761535144080504\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(...))" +msgstr "" + +#. aioag +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id11535144101388\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(...))" +msgstr "" + +#. DuoyG +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id131535144123734\n" +"help.text" +msgid "=ISNUMBER(C1)" +msgstr "" + +#. 8qC4h +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id151535144123735\n" +"help.text" +msgid "FALSE (Microsoft Excel: TRUE)" +msgstr "" + +#. 2nREc +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id981535144159183\n" +"help.text" +msgid "=ISTEXT(C1)" +msgstr "" |