Issue 15821 - Accumulation of whitespace with use of IF and a logical operator
Summary: Accumulation of whitespace with use of IF and a logical operator
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta2
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 124139 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-06-19 18:38 UTC by kyoshida
Modified: 2017-05-20 10:44 UTC (History)
3 users (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 kyoshida 2003-06-19 18:38:17 UTC 
When using a IF clause with two or more conditions jointed by one or more
logical operators (i.e. AND/OR), whitespaces keep being inserted between the
condition clauses and the logical operator(s).  For instance,

1. Type in the word "Good" in cell A1
2. Type in the word "Bad" in cell A2
3. In cell A3, type in the following formula:
   =if((A1="Good") or (A2="Good");"Good";"not so")
   and hit the enter.  Note that at this point there is only one whitespace
   between three terms '(A1="Good")', 'or', and '(A2="Good")'.  The cursor moves
   to cell A4 as a result of you hitting the enter, of course.
4. Go back to cell A3, and you should see now two whitespaces between the three
   terms mentioned in step 3.  Now, in the input line above, click somewhere 
   between the 'or' and the '(A2="Good")', then hit the enter again.
5. Go back to cell A3.  Now you see three whitespaces!
6. Keep repeating steps 4 and 5, and you will see even more whitespaces being
   inserted (but seems to stop at a certain number of whitespaces).

I'm pretty sure this is a bug.  I've seen this happen in the previous versions
of OO.o too (i.e. OO.o 1.0.x), so it may be an old bug.

Can someone confirm this?  Thanks,

Kohei
Comment 1 oc 2003-06-20 08:33:17 UTC 
Hi Eike,
one4you
Comment 2 ooo 2003-06-20 11:05:52 UTC 
A simple 
=(1) AND (2)
in a cell and re-edit does it, same with OR.

The recognition of this syntax is very old legacy code to be able to
read StarCalc 1.0 (yes!) files, usage is an undocumented feature.

For the records: back-reference to iBIS task #110232#
Comment 3 Regina Henschel 2014-01-29 09:07:59 UTC 
*** Issue 124139 has been marked as a duplicate of this issue. ***
Comment 4 Regina Henschel 2014-01-29 09:12:28 UTC 
ODFF as defined in ODF1.2 does not support the operators AND and OR. Therefore I suggest to resolve this as WONTFIX. Task for removing these "feature" is bug 104714.
Comment 5 Marcus 2017-05-20 10:44:23 UTC 
Reset the assignee to the default "issues@openoffice.apache.org".