source/text/scalc/05/empty_cells.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)
New commits: commit b91788bdfe56875a9342d011439f954e50d9c751 Author: Andras Timar <[email protected]> Date: Fri Nov 30 17:03:34 2012 +0100 <empty> -> <Empty> to please pofilter Change-Id: I6708f2d8d99d8b948733fb29b0a9279892bd3da9 diff --git a/source/text/scalc/05/empty_cells.xhp b/source/text/scalc/05/empty_cells.xhp index 774afb4..38951eb 100644 --- a/source/text/scalc/05/empty_cells.xhp +++ b/source/text/scalc/05/empty_cells.xhp @@ -47,7 +47,7 @@ <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_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> @@ -65,7 +65,7 @@ <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_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> _______________________________________________ Libreoffice-commits mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
