[Libreoffice-commits] help.git: source/text
Libreoffice Gerrit user
logerrit at kemper.freedesktop.org
Mon Aug 27 15:46:25 UTC 2018
source/text/scalc/05/empty_cells.xhp | 323 ++++++++++++++++++++++++++++++-----
1 file changed, 285 insertions(+), 38 deletions(-)
New commits:
commit ad2c3417d5a789ef775fdf70b85f7d95845d4d03
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Fri Aug 24 19:45:12 2018 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Mon Aug 27 17:46:04 2018 +0200
Refactor help page on empty cells
Change-Id: I8bff8e56804fae90a71fb35c0a67b015356c2138
Reviewed-on: https://gerrit.libreoffice.org/59585
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
diff --git a/source/text/scalc/05/empty_cells.xhp b/source/text/scalc/05/empty_cells.xhp
index 2717f993c..56ccc19b7 100644
--- a/source/text/scalc/05/empty_cells.xhp
+++ b/source/text/scalc/05/empty_cells.xhp
@@ -19,9 +19,7 @@
* 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">
+<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>
@@ -29,45 +27,294 @@
</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>
+<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>
-<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>
+<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>
-<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 (Microsoft 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 (Microsoft Excel: FALSE)</paragraph>
-<paragraph role="code" id="par_id8801538" xml-lang="en-US">C1: =VLOOKUP(...) with empty cell result => displays empty (Microsoft 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 (Microsoft Excel: TRUE)</paragraph>
-<paragraph role="code" id="par_id2753379" xml-lang="en-US">=ISTEXT(C1) => FALSE</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>
More information about the Libreoffice-commits
mailing list