source/text/scalc/01/04060110.xhp | 12 ++++++++++++
source/text/shared/01/02100001.xhp | 5 +++++
2 files changed, 17 insertions(+)
New commits:
commit 805241fc011cf160c349548bcb532f487aa18e38
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun Jul 21 11:48:54 2024 -0300
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Sun Jul 21 22:59:01 2024 +0200
tdf#144986 Blank cells vs. empty string.
Change-Id: If9c718e476625a137881805757f1011938ac9986
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170816
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 20bff1be7c..193380683d 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -67,6 +67,18 @@
<paragraph role="paragraph" id="par_id401624454547945">Be aware that Calc's
AutoCorrect function may modify double quotation marks. AutoCorrect should not
change the double quotation marks within formula cells but may change those
used in non-formula cells containing text. For example, if you copy a string
that is surrounded by some other form of typographical double quotation marks,
such as the left double quotation mark (U+201C) and the right double quotation
mark (U+201D), and then paste into a formula cell, an error may result. Open
the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect
Options - Localized Options</menuitem> dialog to set the characters used to
automatically correct the start and end typographical double quotation marks.
Uncheck the <menuitem>Replace</menuitem> toggle button to disable the
feature.</paragraph>
</section>
+<h2 id="hd_id451721571883016">Empty string and blank cells</h2>
+<paragraph role="paragraph" id="par_id241721571890240"><variable
id="stringblank">Cells with the empty string ("") are not equivalent to blank
cells. When searching or calculating with text, the empty string "" is the text
with length zero.</variable></paragraph>
+<paragraph role="paragraph" id="par_id451721571895265">For example, when the
formula in A1 returns the empty string "", the following applies:</paragraph>
+<paragraph role="paragraph"
id="par_id591721571900225"><input>=ISBLANK(A1)</input> returns FALSE. The cell
is not blank.</paragraph>
+<paragraph role="paragraph"
id="par_id781721571904769"><input>=ISFORMULA(A1)</input> returns TRUE. The cell
is a formula.</paragraph>
+<paragraph role="paragraph"
id="par_id671721571909081"><input>=ISLOGICAL(A1)</input> returns FALSE. Not a
logical value.
+</paragraph>
+<paragraph role="paragraph"
id="par_id791721571916704"><input>=ISNONTEXT(A1)</input> returns FALSE. The
cell has the empty string.</paragraph>
+<paragraph role="paragraph"
id="par_id91721571920288"><input>=ISNUMBER(A1)</input> returns FALSE. Not a
number.</paragraph>
+<paragraph role="paragraph"
id="par_id821721571924250"><input>=ISTEXT(A1)</input> returns TRUE. The cell
has the empty string, calculated by a formula.</paragraph>
+<paragraph role="paragraph" id="par_id71721571927654"><input>=LEN(A1)</input>
returns 0. The length of the empty string is 0.</paragraph>
+
<sort order="asc" descendant="h2">
diff --git a/source/text/shared/01/02100001.xhp
b/source/text/shared/01/02100001.xhp
index dc184e775e..48c70d5407 100644
--- a/source/text/shared/01/02100001.xhp
+++ b/source/text/shared/01/02100001.xhp
@@ -40,6 +40,11 @@
</bookmark><comment>mw added "replacing;" and "tab stops;"</comment>
<h1 id="hd_id3146765"><variable id="02100001"><link
href="text/shared/01/02100001.xhp">List of Regular
Expressions</link></variable></h1>
<note id="par_id5311440">For a full list of supported metacharacters and
syntax, see <link
href="https://unicode-org.github.io/icu/userguide/strings/regexp.html#regular-expression-metacharacters";>ICU
Regular Expressions documentation</link></note>
+<switch select="appl">
+ <case select="CALC">
+ <note id="par_id731721572578180"><embedvar
href="text/scalc/01/04060110.xhp#stringblank" markup="ignore"/></note>
+ </case>
+</switch>
<table id="tbl_id3149517">
<tablerow>
<tablecell>
