https://bugs.documentfoundation.org/show_bug.cgi?id=167422
Bug ID: 167422
Summary: AND function does not follow conventions
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Usually in a boolean statement with AND, arguments are tested from left to
right until false is encountered. At the first false the end result is already
decided, further arguments will not be tested and in that way automatically
prevent errors. A number of users will expect this behavior and purposely would
want to use AND this way: from left to right first test for the required values
before you use them later in tests to the right.
This post and my own experience prove that LO Calc is not implemented this way.
I hereby recommend that this is fixed and that it will follow the conventions.
The issue is explained here
https://ask.libreoffice.org/t/calc-and-function-bug-or-design-flaw/102235
--
You are receiving this mail because:
You are the assignee for the bug.
