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 2012/05/04 22:40:15 UTC
DO NOT REPLY [Bug 119310] New: IF Conditional inconsistent
https://issues.apache.org/ooo/show_bug.cgi?id=119310
Bug #: 119310
Issue Type: DEFECT
Summary: IF Conditional inconsistent
Classification: Application
Product: Spreadsheet
Version: OOo 3.3
Platform: HP
OS/Version: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
AssignedTo: ooo-issues@incubator.apache.org
ReportedBy: brianpitt612@gmail.com
Created attachment 77513
--> https://issues.apache.org/ooo/attachment.cgi?id=77513
A spreadsheet showing the described problem
The IF conditional does not always produce correct results. It's very hard to
explain since it seems somewhat arbitrary in terms of when it works and when it
doesn't. I set up a spreadsheet and attached it to this bug to show the
problem. To summarize, it seems that if you use an IF to check the value of a
cell who's value is the result of a calculation, the IF may not return TRUE
even if it should. It seems to be related to how far down the chain the cell
in question is. To reproduce, simply create a column where each value is the
previous row's value plus 0.01, starting at 0.01. Then use an IF conditional
in the next column to see if the value equals some constant. If that constant
is anything greater than 2.46 it fails.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
DO NOT REPLY [Bug 119310] IF Conditional inconsistent
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119310
Terry <te...@yahoo.com.au> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |terauck-aoobugs@yahoo.com.a
| |u
--- Comment #2 from Terry <te...@yahoo.com.au> 2012-05-05 03:00:54 UTC ---
The error seems to occur only with the start and increment of 0.01 each with a
check figure in B3 greater than 2.46.
Using increments of 0.02 and 0.03 and different check values, the error does
not occur.
The formula needs to be altered from =IF(A5=$B$3;$B$1;A5+$B$2) to
=IF(A5>=$B$3;$B$1;A5+$B$2) to produce the desired result. The new formula
produces the desired results even when using start of 0.01 and increment of
0.01. I cannot understand why the initial formula fails when a higher check
number than 2.46 is used with those start and increment numbers.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 119310] IF Conditional inconsistent
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119310
--- Comment #5 from Li Feng Wang <ph...@gmail.com> ---
Can reproduce on AOO3.4 release version
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119310] IF Conditional inconsistent
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119310
Terry <te...@yahoo.com.au> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC|terauck-aoobugs@yahoo.com.a |
|u |
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119310] IF Conditional inconsistent
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119310
Li Feng Wang <ph...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |phoenix.wanglf@gmail.com
Ever confirmed|0 |1
--- Comment #4 from Li Feng Wang <ph...@gmail.com> ---
Can reproduce on AOO3.3.
Can't reproduce on AOO3.4 release version.
--
You are receiving this mail because:
You are the assignee for the bug.
DO NOT REPLY [Bug 119310] IF Conditional inconsistent
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119310
--- Comment #1 from Brian <br...@gmail.com> 2012-05-04 20:41:29 UTC ---
I chose OOo 3.3 as the version. Not sure if that's correct. I'm using Windows
version 3.3.0.
OOO330m20 (Build:9567)
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
DO NOT REPLY [Bug 119310] IF Conditional inconsistent
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119310
--- Comment #3 from Terry <te...@yahoo.com.au> 2012-05-05 04:06:30 UTC ---
A correction. Using the check figure of 2.48, with the new formula, cell A252
displays 2.48 and A253 displays 2.49. Renumbering commences in A254, one cell
late.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.