Issue 104714 - Remove undocumented AND and OR infix operators
Summary: Remove undocumented AND and OR infix operators
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.1.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-02 09:33 UTC by Stefan Weigel
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Stefan Weigel 2009-09-02 09:33:22 UTC 
For reproducing this bug you should have OOo in english as well as in german
localization.

First try with englisch OOo:

(1) Open new spreadsheet
(2) In A2 enter: =IF((A1>=0.1)AND(A1<1);1;0)
(3) Result is: 0 or 1 depending on your value in A1
Ok, so far.

(4) In A2 enter: =IF(A1>=0.1AND(A1<1);1;0)
(5) Missing brackets lead to result: #NAME?
Ok, so far.

Now try with german OOo:

(1) Open new spreadsheet
(2) In A2 enter: =WENN(A1>=0,1UND(A1<1),1,0)
(3) Missing brackets do *NOT* lead to an error.
(4) Result is: 0 or 1 depending on your value in A1

(5) Save, close and reopen the document
(6) You get: =WENN(A1>=0.1and(A1<1);1;0)
(7) Formula is not usable anymore.

The defect is, that Calc accepted the wrong formula with missing brackets in
german step 2.
Comment 1 Stefan Weigel 2009-09-02 09:37:58 UTC 
Sorry for a typo in the bug description above!

Step 2 in german must read:

(2) In A2 enter: =WENN(A1>=0,1UND(A1<1);1;0)
Comment 2 ooo 2009-09-02 12:32:21 UTC 
We should completely remove this undocumented and error prone legacy "feature".
Other applications opening an ODF document wouldn't be able to calculate that
anyway.
Comment 3 Marcus 2017-05-20 11:11:51 UTC 
Reset assigne to the default "issues@openoffice.apache.org".