diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2017-05-09 16:11:32 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2017-05-09 16:37:41 +0200 |
| commit | eb9ec1c794a0d3b8522375c7a87ac3ee999c8a66 (patch) | |
| tree | 4729b5cc168353458cda5d1b9ea3174a476c2b4b /source/text/scalc/05 | |
| parent | 7897a9174b6b4a91134398359f3f1e690c774b69 (diff) | |
remove obsolete oldref attribute (removes one context line in pot)
also remove obsolete l10n attribute (doesn't affect translations/pot)
Change-Id: I809866ea7b16cb1cacad9efacb6fdeebae38ea9f
Diffstat (limited to 'source/text/scalc/05')
| -rw-r--r-- | source/text/scalc/05/02140000.xhp | 160 | ||||
| -rw-r--r-- | source/text/scalc/05/OpenCL_options.xhp | 54 | ||||
| -rw-r--r-- | source/text/scalc/05/empty_cells.xhp | 74 |
3 files changed, 144 insertions, 144 deletions
diff --git a/source/text/scalc/05/02140000.xhp b/source/text/scalc/05/02140000.xhp index 3e6789c667..459462fb6f 100644 --- a/source/text/scalc/05/02140000.xhp +++ b/source/text/scalc/05/02140000.xhp @@ -29,8 +29,8 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3146797"><bookmark_value>error codes;list of</bookmark_value> </bookmark><comment>mw deleted "%PRODUCTNAME Calc;error codes"</comment> -<paragraph xml-lang="en-US" id="hd_id3146797" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/05/02140000.xhp" name="Error Codes in %PRODUCTNAME Calc">Error Codes in <item type="productname">%PRODUCTNAME</item> Calc</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3150275" role="paragraph" l10n="U" oldref="2">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>.</paragraph> +<paragraph xml-lang="en-US" id="hd_id3146797" role="heading" level="1"><link href="text/scalc/05/02140000.xhp" name="Error Codes in %PRODUCTNAME Calc">Error Codes in <item type="productname">%PRODUCTNAME</item> Calc</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3150275" role="paragraph">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>.</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id0202201010205429"><bookmark_value>### error message</bookmark_value></bookmark> <bookmark xml-lang="en-US" branch="index" id="bm_id3154634"><bookmark_value>invalid references; error messages</bookmark_value> <bookmark_value>error messages;invalid references</bookmark_value> @@ -42,293 +42,293 @@ <table id="tbl_id3147559"> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153968" role="tablehead" l10n="U" oldref="3">Error Code</paragraph> + <paragraph xml-lang="en-US" id="par_id3153968" role="tablehead">Error Code</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3125863" role="tablehead" l10n="U" oldref="4">Message</paragraph> + <paragraph xml-lang="en-US" id="par_id3125863" role="tablehead">Message</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3151112" role="tablehead" l10n="U" oldref="5">Explanation</paragraph> + <paragraph xml-lang="en-US" id="par_id3151112" role="tablehead">Explanation</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id1668467" role="tablecontent" l10n="NEW">###</paragraph> + <paragraph xml-lang="en-US" id="par_id1668467" role="tablecontent">###</paragraph> </tablecell> <tablecell> -<paragraph xml-lang="en-US" id="par_id3165766" role="tablecontent" l10n="U" oldref="13">none</paragraph> +<paragraph xml-lang="en-US" id="par_id3165766" role="tablecontent">none</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3169266" role="tablecontent" l10n="CHG" oldref="14">The cell is not wide enough to display the contents.</paragraph> + <paragraph xml-lang="en-US" id="par_id3169266" role="tablecontent">The cell is not wide enough to display the contents.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153188" role="tablecontent" l10n="U" oldref="6">501</paragraph> + <paragraph xml-lang="en-US" id="par_id3153188" role="tablecontent">501</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3148645" role="tablecontent" l10n="U" oldref="7">Invalid character</paragraph> + <paragraph xml-lang="en-US" id="par_id3148645" role="tablecontent">Invalid character</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155854" role="tablecontent" l10n="U" oldref="8">Character in a formula is not valid.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155854" role="tablecontent">Character in a formula is not valid.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145253" role="tablecontent" l10n="U" oldref="9">502</paragraph> + <paragraph xml-lang="en-US" id="par_id3145253" role="tablecontent">502</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147397" role="tablecontent" l10n="U" oldref="10">Invalid argument</paragraph> + <paragraph xml-lang="en-US" id="par_id3147397" role="tablecontent">Invalid argument</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153160" role="tablecontent" l10n="U" oldref="11">Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT().</paragraph> + <paragraph xml-lang="en-US" id="par_id3153160" role="tablecontent">Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT().</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154015" role="tablecontent" l10n="U" oldref="12">503<br/>#NUM!</paragraph> + <paragraph xml-lang="en-US" id="par_id3154015" role="tablecontent">503<br/>#NUM!</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155766" role="tablecontent" l10n="U" oldref="13">Invalid floating point operation</paragraph> + <paragraph xml-lang="en-US" id="par_id3155766" role="tablecontent">Invalid floating point operation</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3159266" role="tablecontent" l10n="CHG" oldref="14">A calculation results in an overflow of the defined value range.</paragraph> + <paragraph xml-lang="en-US" id="par_id3159266" role="tablecontent">A calculation results in an overflow of the defined value range.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149258" role="tablecontent" l10n="U" oldref="15">504</paragraph> + <paragraph xml-lang="en-US" id="par_id3149258" role="tablecontent">504</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent" l10n="U" oldref="16">Parameter list error</paragraph> + <paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent">Parameter list error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147003" role="tablecontent" l10n="U" oldref="17">Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147003" role="tablecontent">Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154532" role="tablecontent" l10n="U" oldref="27">508</paragraph> + <paragraph xml-lang="en-US" id="par_id3154532" role="tablecontent">508</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150107" role="tablecontent" l10n="U" oldref="28">Error: Pair missing</paragraph> + <paragraph xml-lang="en-US" id="par_id3150107" role="tablecontent">Error: Pair missing</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149129" role="tablecontent" l10n="U" oldref="29">Missing bracket, for example, closing brackets, but no opening brackets</paragraph> + <paragraph xml-lang="en-US" id="par_id3149129" role="tablecontent">Missing bracket, for example, closing brackets, but no opening brackets</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149895" role="tablecontent" l10n="U" oldref="30">509</paragraph> + <paragraph xml-lang="en-US" id="par_id3149895" role="tablecontent">509</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155097" role="tablecontent" l10n="U" oldref="31">Missing operator</paragraph> + <paragraph xml-lang="en-US" id="par_id3155097" role="tablecontent">Missing operator</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154649" role="tablecontent" l10n="U" oldref="32">Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154649" role="tablecontent">Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153813" role="tablecontent" l10n="U" oldref="33">510</paragraph> + <paragraph xml-lang="en-US" id="par_id3153813" role="tablecontent">510</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153483" role="tablecontent" l10n="U" oldref="34">Missing variable</paragraph> + <paragraph xml-lang="en-US" id="par_id3153483" role="tablecontent">Missing variable</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154710" role="tablecontent" l10n="U" oldref="35">Variable is missing, for example when two operators are together "=1+*2".</paragraph> + <paragraph xml-lang="en-US" id="par_id3154710" role="tablecontent">Variable is missing, for example when two operators are together "=1+*2".</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154739" role="tablecontent" l10n="U" oldref="36">511</paragraph> + <paragraph xml-lang="en-US" id="par_id3154739" role="tablecontent">511</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145112" role="tablecontent" l10n="U" oldref="37">Missing variable</paragraph> + <paragraph xml-lang="en-US" id="par_id3145112" role="tablecontent">Missing variable</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145319" role="tablecontent" l10n="U" oldref="38">Function requires more variables than are provided, for example, AND() and OR().</paragraph> + <paragraph xml-lang="en-US" id="par_id3145319" role="tablecontent">Function requires more variables than are provided, for example, AND() and OR().</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149050" role="tablecontent" l10n="U" oldref="39">512</paragraph> + <paragraph xml-lang="en-US" id="par_id3149050" role="tablecontent">512</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150393" role="tablecontent" l10n="U" oldref="40">Formula overflow</paragraph> + <paragraph xml-lang="en-US" id="par_id3150393" role="tablecontent">Formula overflow</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3159259" role="tablecontent" l10n="U" oldref="41"> + <paragraph xml-lang="en-US" id="par_id3159259" role="tablecontent"> <emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 8192.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150537" role="tablecontent" l10n="U" oldref="42">513</paragraph> + <paragraph xml-lang="en-US" id="par_id3150537" role="tablecontent">513</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147412" role="tablecontent" l10n="U" oldref="43">String overflow</paragraph> + <paragraph xml-lang="en-US" id="par_id3147412" role="tablecontent">String overflow</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145635" role="tablecontent" l10n="U" oldref="44"> + <paragraph xml-lang="en-US" id="par_id3145635" role="tablecontent"> <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.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149147" role="tablecontent" l10n="U" oldref="45">514</paragraph> + <paragraph xml-lang="en-US" id="par_id3149147" role="tablecontent">514</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3157904" role="tablecontent" l10n="U" oldref="46">Internal overflow</paragraph> + <paragraph xml-lang="en-US" id="par_id3157904" role="tablecontent">Internal overflow</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149352" role="tablecontent" l10n="U" oldref="47">Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149352" role="tablecontent">Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154841" role="tablecontent" l10n="U" oldref="51">516</paragraph> + <paragraph xml-lang="en-US" id="par_id3154841" role="tablecontent">516</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147423" role="tablecontent" l10n="U" oldref="52">Internal syntax error</paragraph> + <paragraph xml-lang="en-US" id="par_id3147423" role="tablecontent">Internal syntax error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3148437" role="tablecontent" l10n="U" oldref="53">Matrix is expected on the calculation stack, but is not available.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148437" role="tablecontent">Matrix is expected on the calculation stack, but is not available.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155261" role="tablecontent" l10n="U" oldref="54">517</paragraph> + <paragraph xml-lang="en-US" id="par_id3155261" role="tablecontent">517</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153934" role="tablecontent" l10n="U" oldref="55">Internal syntax error</paragraph> + <paragraph xml-lang="en-US" id="par_id3153934" role="tablecontent">Internal syntax error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149507" role="tablecontent" l10n="U" oldref="56">Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149507" role="tablecontent">Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3148585" role="tablecontent" l10n="U" oldref="57">518</paragraph> + <paragraph xml-lang="en-US" id="par_id3148585" role="tablecontent">518</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149189" role="tablecontent" l10n="U" oldref="58">Internal syntax error</paragraph> + <paragraph xml-lang="en-US" id="par_id3149189" role="tablecontent">Internal syntax error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149545" role="tablecontent" l10n="U" oldref="59">Variable is not available</paragraph> + <paragraph xml-lang="en-US" id="par_id3149545" role="tablecontent">Variable is not available</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3146142" role="tablecontent" l10n="U" oldref="60">519<br/>#VALUE</paragraph> + <paragraph xml-lang="en-US" id="par_id3146142" role="tablecontent">519<br/>#VALUE</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155954" role="tablecontent" l10n="U" oldref="61">No result (#VALUE is in the cell rather than Err:519!)</paragraph> + <paragraph xml-lang="en-US" id="par_id3155954" role="tablecontent">No result (#VALUE is in the cell rather than Err:519!)</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153108" role="tablecontent" l10n="CHG" oldref="62">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.<comment>i63264</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3153108" role="tablecontent">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.<comment>i63264</comment></paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150338" role="tablecontent" l10n="U" oldref="63">520</paragraph> + <paragraph xml-lang="en-US" id="par_id3150338" role="tablecontent">520</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150017" role="tablecontent" l10n="U" oldref="64">Internal syntax error</paragraph> + <paragraph xml-lang="en-US" id="par_id3150017" role="tablecontent">Internal syntax error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3148758" role="tablecontent" l10n="U" oldref="65">Compiler creates an unknown compiler code.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148758" role="tablecontent">Compiler creates an unknown compiler code.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154324" role="tablecontent" l10n="U" oldref="66">521</paragraph> + <paragraph xml-lang="en-US" id="par_id3154324" role="tablecontent">521</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153737" role="tablecontent" l10n="U" oldref="67">Internal syntax error</paragraph> + <paragraph xml-lang="en-US" id="par_id3153737" role="tablecontent">Internal syntax error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155436" role="tablecontent" l10n="U" oldref="68">No result.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155436" role="tablecontent">No result.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153045" role="tablecontent" l10n="U" oldref="69">522</paragraph> + <paragraph xml-lang="en-US" id="par_id3153045" role="tablecontent">522</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149008" role="tablecontent" l10n="U" oldref="70">Circular reference</paragraph> + <paragraph xml-lang="en-US" id="par_id3149008" role="tablecontent">Circular reference</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3157972" role="tablecontent" l10n="CHG" oldref="71">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 + <paragraph xml-lang="en-US" id="par_id3157972" role="tablecontent">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.<comment>UFI: fixes #i23854#</comment></paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149538" role="tablecontent" l10n="U" oldref="72">523</paragraph> + <paragraph xml-lang="en-US" id="par_id3149538" role="tablecontent">523</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150930" role="tablecontent" l10n="U" oldref="73">The calculation procedure does not converge</paragraph> + <paragraph xml-lang="en-US" id="par_id3150930" role="tablecontent">The calculation procedure does not converge</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150272" role="tablecontent" l10n="CHG" oldref="74">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.<comment>UFI: see #33769#</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3150272" role="tablecontent">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.<comment>UFI: see #33769#</comment></paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153544" role="tablecontent" l10n="U" oldref="75">524<br/>#REF</paragraph> + <paragraph xml-lang="en-US" id="par_id3153544" role="tablecontent">524<br/>#REF</paragraph> </tablecell> <tablecell> -<paragraph xml-lang="en-US" id="par_id3154634" role="tablecontent" l10n="U" oldref="76">invalid references (instead of Err:524 cell contains #REF)</paragraph> +<paragraph xml-lang="en-US" id="par_id3154634" role="tablecontent">invalid references (instead of Err:524 cell contains #REF)</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3147539" role="tablecontent" l10n="U" oldref="77"> + <paragraph xml-lang="en-US" id="par_id3147539" role="tablecontent"> <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.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155984" role="tablecontent" l10n="U" oldref="78">525<br/>#NAME?</paragraph> + <paragraph xml-lang="en-US" id="par_id3155984" role="tablecontent">525<br/>#NAME?</paragraph> </tablecell> <tablecell> -<paragraph xml-lang="en-US" id="par_id3148428" role="tablecontent" l10n="U" oldref="79">invalid names (instead of Err:525 cell contains #NAME?)</paragraph> +<paragraph xml-lang="en-US" id="par_id3148428" role="tablecontent">invalid names (instead of Err:525 cell contains #NAME?)</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3156259" role="tablecontent" l10n="U" oldref="80">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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156259" role="tablecontent">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.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153720" role="tablecontent" l10n="U" oldref="81">526</paragraph> + <paragraph xml-lang="en-US" id="par_id3153720" role="tablecontent">526</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154315" role="tablecontent" l10n="U" oldref="82">Internal syntax error</paragraph> + <paragraph xml-lang="en-US" id="par_id3154315" role="tablecontent">Internal syntax error</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3083286" role="tablecontent" l10n="U" oldref="83">Obsolete, no longer used, but could come from old documents if the result is a formula from a domain.</paragraph> + <paragraph xml-lang="en-US" id="par_id3083286" role="tablecontent">Obsolete, no longer used, but could come from old documents if the result is a formula from a domain.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3152483" role="tablecontent" l10n="U" oldref="84">527</paragraph> + <paragraph xml-lang="en-US" id="par_id3152483" role="tablecontent">527</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3152966" role="tablecontent" l10n="U" oldref="85">Internal overflow</paragraph> + <paragraph xml-lang="en-US" id="par_id3152966" role="tablecontent">Internal overflow</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149709" role="tablecontent" l10n="U" oldref="86"> + <paragraph xml-lang="en-US" id="par_id3149709" role="tablecontent"> <emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id5324564" role="tablecontent" l10n="NEW">532<br/>#DIV/0!</paragraph> + <paragraph xml-lang="en-US" id="par_id5324564" role="tablecontent">532<br/>#DIV/0!</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id7941831" role="tablecontent" l10n="NEW">Division by zero</paragraph> + <paragraph xml-lang="en-US" id="par_id7941831" role="tablecontent">Division by zero</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id5844294" role="tablecontent" l10n="NEW">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</paragraph> + <paragraph xml-lang="en-US" id="par_id5844294" role="tablecontent">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</paragraph> </tablecell> </tablerow> </table> diff --git a/source/text/scalc/05/OpenCL_options.xhp b/source/text/scalc/05/OpenCL_options.xhp index 39d3ea241d..19a096f30a 100644 --- a/source/text/scalc/05/OpenCL_options.xhp +++ b/source/text/scalc/05/OpenCL_options.xhp @@ -20,40 +20,40 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3146799"><bookmark_value>OpenCl;options</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/formulacalculationoptions/FormulaCalculationOptions" id="bm_id2745673" localize="false"/> -<paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1" l10n="NEW"><variable id="empty_cells"><link href="text/scalc/05/OpenCL_options.xhp">OpenCL Options</link> +<paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1"><variable id="empty_cells"><link href="text/scalc/05/OpenCL_options.xhp">OpenCL Options</link> </variable></paragraph> -<paragraph role="note" id="par_id5293740" xml-lang="en-US" l10n="NEW">This page is under construction</paragraph> -<paragraph role="paragraph" id="par_id2733542" xml-lang="en-US" l10n="NEW">OpenCL: the open standard for parallel programming of heterogeneous systems.</paragraph> +<paragraph role="note" id="par_id5293740" xml-lang="en-US">This page is under construction</paragraph> +<paragraph role="paragraph" id="par_id2733542" xml-lang="en-US">OpenCL: the open standard for parallel programming of heterogeneous systems.</paragraph> <section id="howtoget"> - <paragraph role="paragraph" id="par_id2752992" xml-lang="en-US" l10n="U" oldref="26"> + <paragraph role="paragraph" id="par_id2752992" xml-lang="en-US"> <variable id="sam01">Menu <emph>Tools - Options - LibreOffice Calc - Formula</emph>, and in section <emph>Detailed Calculation Settings</emph> press <emph>Details...</emph> button</variable> </paragraph> </section> -<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US" l10n="NEW"> +<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US"> OpenCL™ is the first open, royalty-free standard for cross-platform, parallel programming of modern processors found in personal computers, servers and handheld/embedded devices. OpenCL (Open Computing Language) greatly improves speed and responsiveness for a wide spectrum of applications in numerous market categories from gaming and entertainment to scientific and medical software</paragraph> -<paragraph role="note" id="par_id5293741" xml-lang="en-US" l10n="NEW">for more information on OpenCL, visit <link href="http://www.khronos.org/opencl/">the OpenCL site</link></paragraph> +<paragraph role="note" id="par_id5293741" xml-lang="en-US">for more information on OpenCL, visit <link href="http://www.khronos.org/opencl/">the OpenCL site</link></paragraph> <paragraph role="heading" id="par_id4238715" xml-lang="en-US" level="2">Contents to Numbers</paragraph> -<paragraph role="heading" id="par_id8277230" xml-lang="en-US" l10n="NEW" level="3">Conversion from text to number</paragraph> -<paragraph role="paragraph" id="par_id396740" xml-lang="en-US" l10n="NEW">How to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Unambiguous conversion is possible for integer numbers including exponents and ISO 8601 dates and times in their extended formats with separators. Fractional numeric values with decimal separators or dates other than ISO 8601 are locale dependent. Note that in locale dependent conversions the resulting numeric value may differ between locales!</paragraph> -<paragraph role="paragraph" id="par_id4086428" xml-lang="en-US" l10n="NEW"><emph>Generate #VALUE! error:</emph> Text found where numeric data is expected will generate #VALUE! error. Example: <item type="input">"123.45"</item> will generate a #VALUE! error, while <item type="input">123.45</item> not.</paragraph> -<paragraph role="paragraph" id="par_id9024628" xml-lang="en-US" l10n="NEW"><emph>Treat as zero:</emph> Any text found where numeric data is expected will be considered as a number of value zero. Example: <item type="input">"123.45"</item> will map to zero, while <item type="input">123.45</item> not.</paragraph> -<paragraph role="paragraph" id="par_id3067110" xml-lang="en-US" l10n="NEW"><emph>Convert only if unambiguous:</emph> If the text represents a valid and unambiguous numeric value, convert it. Example: <item type="input">"123.456"</item> will generate a #VALUE! error because the text contains a separator, while <item type="input">"123456"</item> will not.</paragraph> -<paragraph role="paragraph" id="par_id8841822" xml-lang="en-US" l10n="NEW"><emph>Convert also locale dependent:</emph> convert values valid in the locale representation. Example: <item type="input">"123,45"</item> is a valid number in some locales because the comma is the decimal separator there.</paragraph> -<paragraph role="heading" id="par_id4077578" xml-lang="en-US" l10n="NEW" level="3">Treat empty string as zero</paragraph> -<paragraph role="paragraph" id="par_id9094515" xml-lang="en-US" l10n="NEW">This option determines how an empty string is treated when used in arithmetic operations. If you have set "Conversion from text to number" to either "Generate #VALUE! error" or "Treat as zero", you cannot choose (here) if conversion of an empty string to a number will generate an error or if it will treat empty strings as zero. Otherwise this option determines how empty strings are treated.</paragraph> -<paragraph role="heading" id="par_id3859675" xml-lang="en-US" l10n="NEW" level="3">Reference syntax for string reference</paragraph> -<paragraph role="paragraph" id="par_id402233" xml-lang="en-US" l10n="NEW">Formula syntax to use when parsing references given in string parameters. This affects built-in functions such as INDIRECT that takes a reference as a string value.</paragraph> -<paragraph role="paragraph" id="par_id1623889" xml-lang="en-US" l10n="NEW"><emph>Use formula syntax:</emph></paragraph> -<paragraph role="paragraph" id="par_id7781914" xml-lang="en-US" l10n="NEW"><emph>Calc A1:</emph></paragraph> -<paragraph role="paragraph" id="par_id300912" xml-lang="en-US" l10n="NEW"><emph>Excel A1:</emph></paragraph> -<paragraph role="paragraph" id="par_id9534592" xml-lang="en-US" l10n="NEW"><emph>Excel R1C1:</emph></paragraph> -<paragraph role="heading" id="par_id4969328" xml-lang="en-US" l10n="NEW" level="2">OpenCL Settings</paragraph> -<paragraph role="heading" id="par_id9635914" xml-lang="en-US" l10n="NEW" level="3">Use OpenCL only for a subset of operations</paragraph> -<paragraph role="paragraph" id="par_id2476577" xml-lang="en-US" l10n="NEW">Use OpenCL only for some of the operations that spreadsheet formulas are translated to.</paragraph> -<paragraph role="heading" id="par_id4217047" xml-lang="en-US" l10n="NEW" level="3">Minimum data size for OpenCL use:</paragraph> -<paragraph role="paragraph" id="par_id2629474" xml-lang="en-US" l10n="NEW">An approximate lower limit on the number of data cells a spreadsheet formula should use for OpenCL to be considered.</paragraph> -<paragraph role="heading" id="par_id8069704" xml-lang="en-US" l10n="NEW" level="3">Subset of OpCodes for which OpenCL is used</paragraph> -<paragraph role="paragraph" id="par_id4524674" xml-lang="en-US" l10n="NEW">The list of operators and function opcodes for which to use OpenCL. If a formula contains only these operators and functions, it might be calculated using OpenCL.</paragraph> +<paragraph role="heading" id="par_id8277230" xml-lang="en-US" level="3">Conversion from text to number</paragraph> +<paragraph role="paragraph" id="par_id396740" xml-lang="en-US">How to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Unambiguous conversion is possible for integer numbers including exponents and ISO 8601 dates and times in their extended formats with separators. Fractional numeric values with decimal separators or dates other than ISO 8601 are locale dependent. Note that in locale dependent conversions the resulting numeric value may differ between locales!</paragraph> +<paragraph role="paragraph" id="par_id4086428" xml-lang="en-US"><emph>Generate #VALUE! error:</emph> Text found where numeric data is expected will generate #VALUE! error. Example: <item type="input">"123.45"</item> will generate a #VALUE! error, while <item type="input">123.45</item> not.</paragraph> +<paragraph role="paragraph" id="par_id9024628" xml-lang="en-US"><emph>Treat as zero:</emph> Any text found where numeric data is expected will be considered as a number of value zero. Example: <item type="input">"123.45"</item> will map to zero, while <item type="input">123.45</item> not.</paragraph> +<paragraph role="paragraph" id="par_id3067110" xml-lang="en-US"><emph>Convert only if unambiguous:</emph> If the text represents a valid and unambiguous numeric value, convert it. Example: <item type="input">"123.456"</item> will generate a #VALUE! error because the text contains a separator, while <item type="input">"123456"</item> will not.</paragraph> +<paragraph role="paragraph" id="par_id8841822" xml-lang="en-US"><emph>Convert also locale dependent:</emph> convert values valid in the locale representation. Example: <item type="input">"123,45"</item> is a valid number in some locales because the comma is the decimal separator there.</paragraph> +<paragraph role="heading" id="par_id4077578" xml-lang="en-US" level="3">Treat empty string as zero</paragraph> +<paragraph role="paragraph" id="par_id9094515" xml-lang="en-US">This option determines how an empty string is treated when used in arithmetic operations. If you have set "Conversion from text to number" to either "Generate #VALUE! error" or "Treat as zero", you cannot choose (here) if conversion of an empty string to a number will generate an error or if it will treat empty strings as zero. Otherwise this option determines how empty strings are treated.</paragraph> +<paragraph role="heading" id="par_id3859675" xml-lang="en-US" level="3">Reference syntax for string reference</paragraph> +<paragraph role="paragraph" id="par_id402233" xml-lang="en-US">Formula syntax to use when parsing references given in string parameters. This affects built-in functions such as INDIRECT that takes a reference as a string value.</paragraph> +<paragraph role="paragraph" id="par_id1623889" xml-lang="en-US"><emph>Use formula syntax:</emph></paragraph> +<paragraph role="paragraph" id="par_id7781914" xml-lang="en-US"><emph>Calc A1:</emph></paragraph> +<paragraph role="paragraph" id="par_id300912" xml-lang="en-US"><emph>Excel A1:</emph></paragraph> +<paragraph role="paragraph" id="par_id9534592" xml-lang="en-US"><emph>Excel R1C1:</emph></paragraph> +<paragraph role="heading" id="par_id4969328" xml-lang="en-US" level="2">OpenCL Settings</paragraph> +<paragraph role="heading" id="par_id9635914" xml-lang="en-US" level="3">Use OpenCL only for a subset of operations</paragraph> +<paragraph role="paragraph" id="par_id2476577" xml-lang="en-US">Use OpenCL only for some of the operations that spreadsheet formulas are translated to.</paragraph> +<paragraph role="heading" id="par_id4217047" xml-lang="en-US" level="3">Minimum data size for OpenCL use:</paragraph> +<paragraph role="paragraph" id="par_id2629474" xml-lang="en-US">An approximate lower limit on the number of data cells a spreadsheet formula should use for OpenCL to be considered.</paragraph> +<paragraph role="heading" id="par_id8069704" xml-lang="en-US" level="3">Subset of OpCodes for which OpenCL is used</paragraph> +<paragraph role="paragraph" id="par_id4524674" xml-lang="en-US">The list of operators and function opcodes for which to use OpenCL. If a formula contains only these operators and functions, it might be calculated using OpenCL.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/05/empty_cells.xhp b/source/text/scalc/05/empty_cells.xhp index d9ad6c0048..f443018d2b 100644 --- a/source/text/scalc/05/empty_cells.xhp +++ b/source/text/scalc/05/empty_cells.xhp @@ -30,44 +30,44 @@ </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3146799"><bookmark_value>empty cells;handling of</bookmark_value> -</bookmark><comment>i86303</comment><paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1" l10n="NEW"><variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link> +</bookmark><comment>i86303</comment><paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1"><variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US" l10n="NEW">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. </paragraph> -<paragraph role="paragraph" id="par_id2733542" xml-lang="en-US" l10n="NEW">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. </paragraph> -<paragraph role="paragraph" id="par_id4238715" xml-lang="en-US" l10n="NEW">For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:</paragraph> -<paragraph role="code" id="par_id8277230" xml-lang="en-US" l10n="NEW">A1: 1 B1: <Empty> C1: =B1 (displays 0)</paragraph> -<paragraph role="code" id="par_id4086428" xml-lang="en-US" l10n="NEW">=B1=0 => TRUE</paragraph> -<paragraph role="code" id="par_id9024628" xml-lang="en-US" l10n="NEW">=B1="" => TRUE</paragraph> -<paragraph role="code" id="par_id3067110" xml-lang="en-US" l10n="NEW">=C1=0 => TRUE</paragraph> -<paragraph role="code" id="par_id8841822" xml-lang="en-US" l10n="NEW">=C1="" => TRUE (previously was FALSE)</paragraph> -<paragraph role="code" id="par_id4077578" xml-lang="en-US" l10n="NEW">=ISNUMBER(B1) => FALSE</paragraph> -<paragraph role="code" id="par_id9094515" xml-lang="en-US" l10n="NEW">=ISNUMBER(C1) => FALSE (previously was TRUE)</paragraph> -<paragraph role="code" id="par_id396740" xml-lang="en-US" l10n="NEW">=ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1)</paragraph> -<paragraph role="code" id="par_id3859675" xml-lang="en-US" l10n="NEW">=ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, previously was TRUE)</paragraph> -<paragraph role="code" id="par_id402233" xml-lang="en-US" l10n="NEW">=ISTEXT(B1) => FALSE</paragraph> -<paragraph role="code" id="par_id1623889" xml-lang="en-US" l10n="NEW">=ISTEXT(C1) => FALSE</paragraph> -<paragraph role="code" id="par_id7781914" xml-lang="en-US" l10n="NEW">=ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, previously was TRUE)</paragraph> -<paragraph role="code" id="par_id300912" xml-lang="en-US" l10n="NEW">=ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1)</paragraph> -<paragraph role="code" id="par_id9534592" xml-lang="en-US" l10n="NEW">=ISBLANK(B1) => TRUE</paragraph> -<paragraph role="code" id="par_id4969328" xml-lang="en-US" l10n="NEW">=ISBLANK(C1) => FALSE</paragraph> -<paragraph role="code" id="par_id9635914" xml-lang="en-US" l10n="NEW">=ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, previously was FALSE)</paragraph> -<paragraph role="code" id="par_id2476577" xml-lang="en-US" l10n="NEW">=ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1)</paragraph> -<paragraph role="note" id="par_id4217047" xml-lang="en-US" l10n="NEW">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:</paragraph> -<paragraph role="code" id="par_id2629474" xml-lang="en-US" l10n="NEW">A1: <Empty></paragraph> -<paragraph role="code" id="par_id8069704" xml-lang="en-US" l10n="NEW">B1: =A1 => displays 0, but is just a reference to an empty cell</paragraph> -<paragraph role="code" id="par_id4524674" xml-lang="en-US" l10n="NEW">=ISNUMBER(A1) => FALSE</paragraph> -<paragraph role="code" id="par_id4396801" xml-lang="en-US" l10n="NEW">=ISTEXT(A1) => FALSE</paragraph> -<paragraph role="code" id="par_id5293740" xml-lang="en-US" l10n="NEW">=A1=0 => TRUE</paragraph> -<paragraph role="code" id="par_id7623828" xml-lang="en-US" l10n="NEW">=A1="" => TRUE</paragraph> -<paragraph role="code" id="par_id2861720" xml-lang="en-US" l10n="NEW">=ISNUMBER(B1) => FALSE (MS-Excel: TRUE)</paragraph> -<paragraph role="code" id="par_id9604480" xml-lang="en-US" l10n="NEW">=ISTEXT(B1) => FALSE</paragraph> -<paragraph role="code" id="par_id2298959" xml-lang="en-US" l10n="NEW">=B1=0 => TRUE</paragraph> -<paragraph role="code" id="par_id4653767" xml-lang="en-US" l10n="NEW">=B1="" => TRUE (MS-Excel: FALSE)</paragraph> -<paragraph role="code" id="par_id8801538" xml-lang="en-US" l10n="NEW">C1: =VLOOKUP(...) with empty cell result => displays empty (MS-Excel: displays 0)</paragraph> -<paragraph role="code" id="par_id6746421" xml-lang="en-US" l10n="NEW">=ISNUMBER(VLOOKUP(...)) => FALSE</paragraph> -<paragraph role="code" id="par_id4876247" xml-lang="en-US" l10n="NEW">=ISTEXT(VLOOKUP(...)) => FALSE</paragraph> -<paragraph role="code" id="par_id7458723" xml-lang="en-US" l10n="NEW">=ISNUMBER(C1) => FALSE (MS-Excel: TRUE)</paragraph> -<paragraph role="code" id="par_id2753379" xml-lang="en-US" l10n="NEW">=ISTEXT(C1) => FALSE</paragraph> +<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US">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. </paragraph> +<paragraph role="paragraph" id="par_id2733542" xml-lang="en-US">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. </paragraph> +<paragraph role="paragraph" id="par_id4238715" xml-lang="en-US">For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:</paragraph> +<paragraph role="code" id="par_id8277230" xml-lang="en-US">A1: 1 B1: <Empty> C1: =B1 (displays 0)</paragraph> +<paragraph role="code" id="par_id4086428" xml-lang="en-US">=B1=0 => TRUE</paragraph> +<paragraph role="code" id="par_id9024628" xml-lang="en-US">=B1="" => TRUE</paragraph> +<paragraph role="code" id="par_id3067110" xml-lang="en-US">=C1=0 => TRUE</paragraph> +<paragraph role="code" id="par_id8841822" xml-lang="en-US">=C1="" => TRUE (previously was FALSE)</paragraph> +<paragraph role="code" id="par_id4077578" xml-lang="en-US">=ISNUMBER(B1) => FALSE</paragraph> +<paragraph role="code" id="par_id9094515" xml-lang="en-US">=ISNUMBER(C1) => FALSE (previously was TRUE)</paragraph> +<paragraph role="code" id="par_id396740" xml-lang="en-US">=ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1)</paragraph> +<paragraph role="code" id="par_id3859675" xml-lang="en-US">=ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, previously was TRUE)</paragraph> +<paragraph role="code" id="par_id402233" xml-lang="en-US">=ISTEXT(B1) => FALSE</paragraph> +<paragraph role="code" id="par_id1623889" xml-lang="en-US">=ISTEXT(C1) => FALSE</paragraph> +<paragraph role="code" id="par_id7781914" xml-lang="en-US">=ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, previously was TRUE)</paragraph> +<paragraph role="code" id="par_id300912" xml-lang="en-US">=ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1)</paragraph> +<paragraph role="code" id="par_id9534592" xml-lang="en-US">=ISBLANK(B1) => TRUE</paragraph> +<paragraph role="code" id="par_id4969328" xml-lang="en-US">=ISBLANK(C1) => FALSE</paragraph> +<paragraph role="code" id="par_id9635914" xml-lang="en-US">=ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, previously was FALSE)</paragraph> +<paragraph role="code" id="par_id2476577" xml-lang="en-US">=ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1)</paragraph> +<paragraph role="note" id="par_id4217047" xml-lang="en-US">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:</paragraph> +<paragraph role="code" id="par_id2629474" xml-lang="en-US">A1: <Empty></paragraph> +<paragraph role="code" id="par_id8069704" xml-lang="en-US">B1: =A1 => displays 0, but is just a reference to an empty cell</paragraph> +<paragraph role="code" id="par_id4524674" xml-lang="en-US">=ISNUMBER(A1) => FALSE</paragraph> +<paragraph role="code" id="par_id4396801" xml-lang="en-US">=ISTEXT(A1) => FALSE</paragraph> +<paragraph role="code" id="par_id5293740" xml-lang="en-US">=A1=0 => TRUE</paragraph> +<paragraph role="code" id="par_id7623828" xml-lang="en-US">=A1="" => TRUE</paragraph> +<paragraph role="code" id="par_id2861720" xml-lang="en-US">=ISNUMBER(B1) => FALSE (MS-Excel: TRUE)</paragraph> +<paragraph role="code" id="par_id9604480" xml-lang="en-US">=ISTEXT(B1) => FALSE</paragraph> +<paragraph role="code" id="par_id2298959" xml-lang="en-US">=B1=0 => TRUE</paragraph> +<paragraph role="code" id="par_id4653767" xml-lang="en-US">=B1="" => TRUE (MS-Excel: FALSE)</paragraph> +<paragraph role="code" id="par_id8801538" xml-lang="en-US">C1: =VLOOKUP(...) with empty cell result => displays empty (MS-Excel: displays 0)</paragraph> +<paragraph role="code" id="par_id6746421" xml-lang="en-US">=ISNUMBER(VLOOKUP(...)) => FALSE</paragraph> +<paragraph role="code" id="par_id4876247" xml-lang="en-US">=ISTEXT(VLOOKUP(...)) => FALSE</paragraph> +<paragraph role="code" id="par_id7458723" xml-lang="en-US">=ISNUMBER(C1) => FALSE (MS-Excel: TRUE)</paragraph> +<paragraph role="code" id="par_id2753379" xml-lang="en-US">=ISTEXT(C1) => FALSE</paragraph> </body> </helpdocument> |