You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/17 21:31:25 UTC
[Bug 124248] New: Empty cells evaluate to True
https://issues.apache.org/ooo/show_bug.cgi?id=124248
Bug ID: 124248
Issue Type: DEFECT
Summary: Empty cells evaluate to True
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: critical
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: villeroy@t-online.de
CC: issues@openoffice.apache.org
See attachment where =IF(AND(A1;B1;C1);D1;E1)==>TRUE although A1 and B1 are
empty.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124248] Empty cells evaluate to True
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124248
Andre <aw...@googlemail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |awf.aoo@googlemail.com
--- Comment #2 from Andre <aw...@googlemail.com> ---
Do we have a specification of the AND function somewhere?
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_AND_function
is somewhat vague.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124248] Empty cells evaluate to True
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124248
--- Comment #4 from Andreas Säger <vi...@t-online.de> ---
With column A being empty:
=A1=FALSE() => TRUE (implicit conversion in boolean context)
=A2="" => TRUE (implicit conversion in string context)
=A3=0 => TRUE (implicit conversion in numeric context)
also:
=IF(A1;"y";"n") => n
therefore
=AND(A1;A2;A3) should return FALSE and not #VALUE!
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124248] Empty cells evaluate to True
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124248
--- Comment #1 from Andreas Säger <vi...@t-online.de> ---
Created attachment 82609
--> https://issues.apache.org/ooo/attachment.cgi?id=82609&action=edit
Issue 124248
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124248] Empty cells evaluate to True
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124248
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |rb.henschel@t-online.de
Ever confirmed|0 |1
--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
Specification is always at OASIS, e.g. in its (non normative) online version
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html
AND is in section 6.15.2. But here you need section 6.3 Implicit Conversion
Operators and there "6.3.12 Conversion to Logical". It states "If the reference
is to an empty cell, consider it FALSE()."
The error here is, that references to empty cells are ignored. When you clear
cell C1 in the attached example, then result is an error, but should be FALSE.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124248] Empty cells evaluate to True
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124248
brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oliver.brinzing@gmx.de
--- Comment #5 from brinzing <ol...@gmx.de> ---
.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.