diff options
Diffstat (limited to 'translations/source/zh-CN/helpcontent2/source/text/scalc/05.po')
| -rw-r--r-- | translations/source/zh-CN/helpcontent2/source/text/scalc/05.po | 1205 |
1 files changed, 1205 insertions, 0 deletions
diff --git a/translations/source/zh-CN/helpcontent2/source/text/scalc/05.po b/translations/source/zh-CN/helpcontent2/source/text/scalc/05.po new file mode 100644 index 000000000..cec73a32e --- /dev/null +++ b/translations/source/zh-CN/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: 2020-03-31 10:35+0200\n" +"PO-Revision-Date: 2019-07-10 01:37+0000\n" +"Last-Translator: Dian LI <xslidian@gmail.com>\n" +"Language-Team: LANGUAGE <LL@li.org>\n" +"Language: zh_CN\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=utf-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=1; plural=0;\n" +"X-Accelerator-Marker: ~\n" +"X-Generator: LibreOffice\n" +"X-POOTLE-MTIME: 1562722664.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 "<bookmark_value>错误代码;列表</bookmark_value>" + +#. 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=\"%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 "<bookmark_value>### 错误消息</bookmark_value>" + +#. 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 "<bookmark_value>无效引用; 错误消息</bookmark_value> <bookmark_value>错误消息; 无效引用</bookmark_value> <bookmark_value>#REF 错误消息</bookmark_value>" + +#. 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 "公式中的字符无效。" + +#. 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 "函数参数无效。例如，要在 SQRT() 函数中使用附属，请用 IMSQRT()。" + +#. XtB4F +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154015\n" +"help.text" +msgid "503<br/>#NUM!" +msgstr "503<br/>#NUM!" + +#. 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 "某运算导致溢出定义的值域。" + +#. 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 "「<emph>编译器</emph>」:公式中内部标记 (即运算符、变量、括号) 的总数超过了 8192。" + +#. T3ZaN +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3147412\n" +"help.text" +msgid "String overflow" +msgstr "字符串溢出" + +#. h9Kok +#: 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 "「<emph>编译器</emph>」:公式中标识符的大小超过 64 KB。「<emph>解释器:</emph>」字符串运算结果的大小超过 64 KB。" + +#. 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 "排序运算带有过多的数字数据 (最大为 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 "" + +#. ESdqW +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3155954\n" +"help.text" +msgid "No result (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><switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - 偏好设置</caseinline><defaultinline>工具 - 选项</defaultinline></switchinline> - %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 "" + +#. ioqDF +#: 02140000.xhp +msgctxt "" +"02140000.xhp\n" +"par_id3154634\n" +"help.text" +msgid "invalid references (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 "525<br/>#NAME?" + +#. 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 "532<br/>#DIV/0!" + +#. 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 "除法运算符 / 如果分母是 0 <br/>一些函数返回错误，例如: <br/>VARP 参数的数目小于 1<br/>STDEVP 参数的数目小于 1<br/>VAR 参数的数目小于 2<br/>STDEV 参数的数目小于 2<br/>STANDARDIZE 中 stdev=0<br/>NORMDIST 中 stdev=0" + +#. 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 "例如 ={1;{2}}" + +#. 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 "例如 ={1+2}" + +#. 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 "<bookmark_value>空白单元格; 处理</bookmark_value>" + +#. 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 "<variable id=\"empty_cells\"><link href=\"text/scalc/05/empty_cells.xhp\">处理空白单元格</link></variable>" + +#. 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 "在较旧版本的软件中，空白单元格在某些上下文中强制设为数字 0，在另一些地方强制设为空字符串，但在直接比较中有例外情况，如果 A1 为空，那么 =A1=0 和 =A1=\"\" 的结果都是 TRUE。空值一直延续到对该值的调用才发生改变，所以当 lookup 的结果是返回一个空单元格时就有 =VLOOKUP(...)=0 和 =VLOOKUP(...)=\"\" 的值是 TRUE。" + +#. 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 "对一个空白单元格的简单引用仍显示为数字 0，但不再必须为数字类型。因此，与引用单元格的比较如所期望的那样。" + +#. 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 "对于以下示例，A1 包含一个数字，B1 为空，C1 包含对 B1 的引用:" + +#. 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 "A1: 1<br/>B1: <Empty>" + +#. y3NDD +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id851535142746123\n" +"help.text" +msgid "Displays 0" +msgstr "显示 0" + +#. x3Fkf +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id981535142948275\n" +"help.text" +msgid "<variable id=\"vtrue\">TRUE</variable>" +msgstr "<variable id=\"vtrue\">TRUE</variable>" + +#. jGD6d +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id1001535143031604\n" +"help.text" +msgid "TRUE (previously was FALSE)" +msgstr "TRUE (之前为 FALSE)" + +#. rLs5m +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id201535143064244\n" +"help.text" +msgid "=ISNUMBER(B1)" +msgstr "=ISNUMBER(B1)" + +#. aBBEF +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id421535143064245\n" +"help.text" +msgid "<variable id=\"vfalse\">FALSE</variable>" +msgstr "<variable id=\"vfalse\">FALSE</variable>" + +#. 8taRG +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id681535143124250\n" +"help.text" +msgid "=ISNUMBER(C1)" +msgstr "=ISNUMBER(C1)" + +#. srU2T +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id211535143124250\n" +"help.text" +msgid "FALSE (previously was TRUE)" +msgstr "FALSE (之前为 TRUE)" + +#. gUyG5 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id221535143151829\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;2))" +msgstr "=ISNUMBER(VLOOKUP(1;A1:C1;2))" + +#. eHH8h +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id271535143151830\n" +"help.text" +msgid "FALSE (B1)" +msgstr "FALSE (B1)" + +#. 24jXb +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id861535143183196\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;3))" +msgstr "=ISNUMBER(VLOOKUP(1;A1:C1;3))" + +#. TGuuU +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id371535143183197\n" +"help.text" +msgid "FALSE (C1, previously was TRUE)" +msgstr "FALSE (C1, 之前为 TRUE)" + +#. td3QN +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id191535143228538\n" +"help.text" +msgid "=ISTEXT(B1)" +msgstr "=ISTEXT(B1)" + +#. usWWT +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id251535143279847\n" +"help.text" +msgid "=ISTEXT(C1)" +msgstr "=ISTEXT(C1)" + +#. MoQBw +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id641535143301636\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(1;A1:C1;2))" +msgstr "=ISTEXT(VLOOKUP(1;A1:C1;2))" + +#. DCsDd +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id391535143301637\n" +"help.text" +msgid "FALSE (B1, previously was TRUE)" +msgstr "FALSE (B1, 之前为 TRUE)" + +#. aBByS +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id661535143336012\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(1;A1:C1;3))" +msgstr "=ISTEXT(VLOOKUP(1;A1:C1;3))" + +#. wyXe6 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id11535143336012\n" +"help.text" +msgid "FALSE (C1)" +msgstr "FALSE (C1)" + +#. kkBGf +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id661535143373396\n" +"help.text" +msgid "=ISBLANK(B1)" +msgstr "=ISBLANK(B1)" + +#. 7m34D +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id281535143396581\n" +"help.text" +msgid "=ISBLANK(C1)" +msgstr "=ISBLANK(C1)" + +#. NCnu6 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id31535143422248\n" +"help.text" +msgid "=ISBLANK(VLOOKUP(1;A1:C1;2))" +msgstr "=ISBLANK(VLOOKUP(1;A1:C1;2))" + +#. YXdDe +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id871535143422248\n" +"help.text" +msgid "TRUE (B1, previously was FALSE)" +msgstr "TRUE (B1, 之前为 FALSE)" + +#. us9L8 +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id731535143454577\n" +"help.text" +msgid "=ISBLANK(VLOOKUP(1;A1:C1;3))" +msgstr "=ISBLANK(VLOOKUP(1;A1:C1;3))" + +#. 6PxBF +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id941535143454577\n" +"help.text" +msgid "FALSE (C1)" +msgstr "FALSE (C1)" + +#. 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 "请注意，在 Microsoft Excel 中的处理方式有所不同，它总是返回一个数字作为对一个空白单元格或者返回值是空白单元格的公式的引用结果。例如:" + +#. 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 "A1: <空白>" + +#. 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 "显示 0，但只是对空单元格的引用。" + +#. GJtfQ +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id441535143762523\n" +"help.text" +msgid "=ISNUMBER(A1)" +msgstr "=ISNUMBER(A1)" + +#. GZbTC +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id751535143810734\n" +"help.text" +msgid "=ISTEXT(A1)" +msgstr "=ISTEXT(A1)" + +#. ag84f +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id121535143920008\n" +"help.text" +msgid "=ISNUMBER(B1)" +msgstr "=ISNUMBER(B1)" + +#. XHXqn +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id391535143920009\n" +"help.text" +msgid "FALSE (Microsoft Excel: TRUE)" +msgstr "FALSE (Microsoft Excel: TRUE)" + +#. ndXeg +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id371535143961386\n" +"help.text" +msgid "=ISTEXT(B1)" +msgstr "=ISTEXT(B1)" + +#. xykic +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id111535144016852\n" +"help.text" +msgid "TRUE (Microsoft Excel: FALSE)" +msgstr "TRUE (Microsoft Excel: FALSE)" + +#. JGAPT +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id771535144043975\n" +"help.text" +msgid "C1: =VLOOKUP(...) with empty cell result" +msgstr "C1: =VLOOKUP(...) 单元格查找结果为空" + +#. 7rzAj +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id311535144043975\n" +"help.text" +msgid "displays empty (Microsoft Excel: displays 0)" +msgstr "显示空 (Microsoft Excel: 显示 0)" + +#. QZZQE +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id761535144080504\n" +"help.text" +msgid "=ISNUMBER(VLOOKUP(...))" +msgstr "=ISNUMBER(VLOOKUP(...))" + +#. aioag +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id11535144101388\n" +"help.text" +msgid "=ISTEXT(VLOOKUP(...))" +msgstr "=ISTEXT(VLOOKUP(...))" + +#. DuoyG +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id131535144123734\n" +"help.text" +msgid "=ISNUMBER(C1)" +msgstr "=ISNUMBER(C1)" + +#. 8qC4h +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id151535144123735\n" +"help.text" +msgid "FALSE (Microsoft Excel: TRUE)" +msgstr "FALSE (Microsoft Excel: TRUE)" + +#. 2nREc +#: empty_cells.xhp +msgctxt "" +"empty_cells.xhp\n" +"par_id981535144159183\n" +"help.text" +msgid "=ISTEXT(C1)" +msgstr "=ISTEXT(C1)" |