incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119310] New: IF Conditional inconsistent
Date Fri, 04 May 2012 20:40:15 GMT
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.

Mime
View raw message