diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
| commit | ed5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch) | |
| tree | 7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/scalc/05 | |
| parent | Initial commit. (diff) | |
| download | libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip | |
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/scalc/05')
| -rw-r--r-- | helpcontent2/source/text/scalc/05/02140000.xhp | 426 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/05/empty_cells.xhp | 320 |
2 files changed, 746 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/05/02140000.xhp b/helpcontent2/source/text/scalc/05/02140000.xhp new file mode 100644 index 000000000..4a54582a7 --- /dev/null +++ b/helpcontent2/source/text/scalc/05/02140000.xhp @@ -0,0 +1,426 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + + +<meta> + <topic id="textscalc0502140000xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Error Codes in %PRODUCTNAME Calc</title> + <filename>/text/scalc/05/02140000.xhp</filename> + </topic> + </meta> + <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"><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> + <bookmark_value>#REF error message</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148428"><bookmark_value>invalid names; error messages</bookmark_value> + <bookmark_value>#NAME error message</bookmark_value> +</bookmark> + <table id="tbl_id3147559"> + <tablerow> + <tablecell> + <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">Message</paragraph> + </tablecell> + <tablecell> + <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" localize="false">###</paragraph> + </tablecell> + <tablecell> +<paragraph xml-lang="en-US" id="par_id3165766" role="tablecontent">none</paragraph> + </tablecell> + <tablecell> + <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_id1668468" role="tablecontent" localize="false">#FMT</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3165767" role="tablecontent">none</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3169267" role="tablecontent">This value is outside of limits valid for this format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3153188" role="tablecontent">501</paragraph> + </tablecell> + <tablecell> + <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">Character in a formula is not valid.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3145253" role="tablecontent">502</paragraph> + </tablecell> + <tablecell> + <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">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">503<br/>#NUM!</paragraph> + </tablecell> + <tablecell> + <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">A calculation results in an overflow of the defined value range.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3149258" role="tablecontent">504</paragraph> + </tablecell> + <tablecell> + <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">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 localize="false" id="par_id3154532" role="tablecontent">507, 508</paragraph> + </tablecell> + <tablecell> + <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">Missing bracket, for example, closing brackets, but no opening brackets</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3149895" role="tablecontent">509</paragraph> + </tablecell> + <tablecell> + <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">Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3153813" role="tablecontent">510</paragraph> + </tablecell> + <tablecell> + <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">Variable is missing, for example when two operators are together "=1+*2".</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3154739" role="tablecontent">511</paragraph> + </tablecell> + <tablecell> + <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">Function requires more variables than are provided, for example, AND() and OR().</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3149050" role="tablecontent">512</paragraph> + </tablecell> + <tablecell> + <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"> + <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 localize="false" id="par_id3150537" role="tablecontent">513</paragraph> + </tablecell> + <tablecell> + <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"> + <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 localize="false" id="par_id3149147" role="tablecontent">514</paragraph> + </tablecell> + <tablecell> + <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">Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3154842" role="tablecontent">515</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147424" role="tablecontent">Internal syntax error</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148438" role="tablecontent">Unknown error.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3154841" role="tablecontent">516</paragraph> + </tablecell> + <tablecell> + <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">Matrix is expected on the calculation stack, but is not available.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3155261" role="tablecontent">517</paragraph> + </tablecell> + <tablecell> + <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">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 localize="false" id="par_id3148585" role="tablecontent">518</paragraph> + </tablecell> + <tablecell> + <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">Variable is not available</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <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">No value (instead of Err:519 cell displays #VALUE!)</paragraph> + </tablecell> + <tablecell> + <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 localize="false" id="par_id3150338" role="tablecontent">520</paragraph> + </tablecell> + <tablecell> + <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">Compiler creates an unknown compiler code.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3154324" role="tablecontent">521<br/>#NULL!</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153737" role="tablecontent">Internal syntax error (instead of Err:521 cell displays #NULL!)</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155436" role="tablecontent">No code or no result.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3153045" role="tablecontent">522</paragraph> + </tablecell> + <tablecell> + <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">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 localize="false" id="par_id3149538" role="tablecontent">523</paragraph> + </tablecell> + <tablecell> + <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">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">524<br/>#REF!</paragraph> + </tablecell> + <tablecell> +<paragraph xml-lang="en-US" id="par_id3154634" role="tablecontent">Not a valid reference (instead of Err:524 cell displays #REF!)</paragraph> + </tablecell> + <tablecell> + <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">525<br/>#NAME?</paragraph> + </tablecell> + <tablecell> +<paragraph xml-lang="en-US" id="par_id3148428" role="tablecontent">invalid names (instead of Err:525 cell displays #NAME?)</paragraph> + </tablecell> + <tablecell> + <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 localize="false" id="par_id3153720" role="tablecontent">526</paragraph> + </tablecell> + <tablecell> + <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">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 localize="false" id="par_id3152483" role="tablecontent">527</paragraph> + </tablecell> + <tablecell> + <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"> + <emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3152484" role="tablecontent">530</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id4152967" role="tablecontent">No AddIn</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149710" role="tablecontent"> + <emph>Interpreter: </emph>AddIn not found.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id3152485" role="tablecontent">531</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152967" role="tablecontent">No Macro</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149711" role="tablecontent"> + <emph>Interpreter: </emph>Macro not found.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <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">Division by zero</paragraph> + </tablecell> + <tablecell> + <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> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id231549820000708" role="tablecontent">533</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id951549820044260" role="tablecontent">Nested arrays are not supported</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id781549820065619" role="tablecontent"> For example, ={1;{2}} </paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id961549825716936" role="tablecontent">538</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id521549825734781" role="tablecontent">Error: Array or matrix size</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id601549825744677" role="tablecontent" localize="false"> - </paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id41549825806618" role="tablecontent">539</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id931549825818729" role="tablecontent">Unsupported inline array content</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id551549825825905" role="tablecontent"> For example, ={1+2} </paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph localize="false" id="par_id441549825884434" role="tablecontent">540</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id131549825893410" role="tablecontent">External content disabled</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id881549825900965" role="tablecontent"> Happens if a function that requires (re)loading of external sources is encountered and the user hasn't confirmed reloading of external sources yet </paragraph> + </tablecell> + </tablerow> + </table> + </body> +</helpdocument> diff --git a/helpcontent2/source/text/scalc/05/empty_cells.xhp b/helpcontent2/source/text/scalc/05/empty_cells.xhp new file mode 100644 index 000000000..56ccc19b7 --- /dev/null +++ b/helpcontent2/source/text/scalc/05/empty_cells.xhp @@ -0,0 +1,320 @@ +<?xml version="1.0" encoding="UTF-8"?> + + + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> +<helpdocument version="1.0"> +<meta> +<topic id="textscalc05empty_cellsxml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Handling of Empty Cells</title> +<filename>/text/scalc/05/empty_cells.xhp</filename> +</topic> +</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"><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">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> +<table id="tab_id771535142746120"> + <tablerow> + <tablecell> + <paragraph id="par_id291535142746121" role="tablehead" xml-lang="en-US">Case</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id441535142746121" role="tablehead" xml-lang="en-US">Formula</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id261535142746121" role="tablehead" xml-lang="en-US">Results and comments</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell rowspan="17"> + <paragraph id="par_id941535142746122" role="tablecontent" xml-lang="en-US">A1: 1<br/>B1: <Empty></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id471535142746122" role="tablecontent" xml-lang="en-US" localize="false">C1: =B1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id851535142746123" role="tablecontent" xml-lang="en-US">Displays 0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id611535142948275" role="tablecontent" xml-lang="en-US" localize="false">=B1=0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id981535142948275" role="tablecontent" xml-lang="en-US"><variable id="vtrue">TRUE</variable></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id311535142974515" role="tablecontent" xml-lang="en-US" localize="false">=B1=""</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id851535142974516" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id161535143000810" role="tablecontent" xml-lang="en-US" localize="false">=C1=0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id941535143000810" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id251535143031604" role="tablecontent" xml-lang="en-US" localize="false">=C1=""</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001535143031604" role="tablecontent" xml-lang="en-US" >TRUE (previously was FALSE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id201535143064244" role="tablecontent" xml-lang="en-US" >=ISNUMBER(B1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id421535143064245" role="tablecontent" xml-lang="en-US" ><variable id="vfalse">FALSE</variable></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id681535143124250" role="tablecontent" xml-lang="en-US" >=ISNUMBER(C1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id211535143124250" role="tablecontent" xml-lang="en-US" >FALSE (previously was TRUE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id221535143151829" role="tablecontent" xml-lang="en-US" >=ISNUMBER(VLOOKUP(1;A1:C1;2))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id271535143151830" role="tablecontent" xml-lang="en-US" >FALSE (B1)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id861535143183196" role="tablecontent" xml-lang="en-US" >=ISNUMBER(VLOOKUP(1;A1:C1;3))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id371535143183197" role="tablecontent" xml-lang="en-US" >FALSE (C1, previously was TRUE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id191535143228538" role="tablecontent" xml-lang="en-US" >=ISTEXT(B1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id271535143228539" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id251535143279847" role="tablecontent" xml-lang="en-US" >=ISTEXT(C1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id691535143279847" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id641535143301636" role="tablecontent" xml-lang="en-US" >=ISTEXT(VLOOKUP(1;A1:C1;2))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id391535143301637" role="tablecontent" xml-lang="en-US" >FALSE (B1, previously was TRUE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id661535143336012" role="tablecontent" xml-lang="en-US" >=ISTEXT(VLOOKUP(1;A1:C1;3))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id11535143336012" role="tablecontent" xml-lang="en-US" >FALSE (C1)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id661535143373396" role="tablecontent" xml-lang="en-US" >=ISBLANK(B1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id141535143373396" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id281535143396581" role="tablecontent" xml-lang="en-US" >=ISBLANK(C1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id81535143396581" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id31535143422248" role="tablecontent" xml-lang="en-US" >=ISBLANK(VLOOKUP(1;A1:C1;2))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id871535143422248" role="tablecontent" xml-lang="en-US" >TRUE (B1, previously was FALSE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id731535143454577" role="tablecontent" xml-lang="en-US" >=ISBLANK(VLOOKUP(1;A1:C1;3))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id941535143454577" role="tablecontent" xml-lang="en-US" >FALSE (C1)</paragraph> + </tablecell> + </tablerow> +</table> +<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> +<table id="tab_id691535143557532"> + <tablerow> + <tablecell> + <paragraph id="par_id251535143557533" role="tablehead" xml-lang="en-US">Case</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id441535143557533" role="tablehead" xml-lang="en-US">Formula</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id481535143557533" role="tablehead" xml-lang="en-US">Results and comments</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell rowspan="14"> + <paragraph id="par_id311535143557534" role="tablecontent" xml-lang="en-US">A1: <Empty></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id321535143557534" role="tablecontent" xml-lang="en-US" localize="false">B1: =A1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id961535143557535" role="tablecontent" xml-lang="en-US">Displays 0, but is just a reference to an empty cell.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id441535143762523" role="tablecontent" xml-lang="en-US" >=ISNUMBER(A1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id881535143762523" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id751535143810734" role="tablecontent" xml-lang="en-US" >=ISTEXT(A1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id211535143810734" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id961535143845607" role="tablecontent" xml-lang="en-US" localize="false">=A1=0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id411535143845608" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id781535143884547" role="tablecontent" xml-lang="en-US" localize="false">=A1=""</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id521535143884547" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id121535143920008" role="tablecontent" xml-lang="en-US" >=ISNUMBER(B1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id391535143920009" role="tablecontent" xml-lang="en-US" >FALSE (Microsoft Excel: TRUE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id371535143961386" role="tablecontent" xml-lang="en-US" >=ISTEXT(B1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id451535143961387" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id601535143981973" role="tablecontent" xml-lang="en-US" localize="false">=B1=0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id701535143981974" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vtrue" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id761535144016851" role="tablecontent" xml-lang="en-US" localize="false">=B1=""</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id111535144016852" role="tablecontent" xml-lang="en-US" >TRUE (Microsoft Excel: FALSE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id771535144043975" role="tablecontent" xml-lang="en-US" >C1: =VLOOKUP(...) with empty cell result</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id311535144043975" role="tablecontent" xml-lang="en-US" >displays empty (Microsoft Excel: displays 0)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id761535144080504" role="tablecontent" xml-lang="en-US" >=ISNUMBER(VLOOKUP(...))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id711535144080505" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id11535144101388" role="tablecontent" xml-lang="en-US" >=ISTEXT(VLOOKUP(...))</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id831535144101388" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id131535144123734" role="tablecontent" xml-lang="en-US" >=ISNUMBER(C1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id151535144123735" role="tablecontent" xml-lang="en-US" >FALSE (Microsoft Excel: TRUE)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id981535144159183" role="tablecontent" xml-lang="en-US" >=ISTEXT(C1)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id101535144159184" role="tablecontent" xml-lang="en-US" localize="false"><embedvar href="text/scalc/05/empty_cells.xhp#vfalse" markup="ignore"/></paragraph> + </tablecell> + </tablerow> +</table> +</body> +</helpdocument> |