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 2013/07/06 22:18:51 UTC

[Bug 122699] New: Conditional cell address value reassignment

https://issues.apache.org/ooo/show_bug.cgi?id=122699

            Bug ID: 122699
        Issue Type: DEFECT
           Summary: Conditional cell address value reassignment
           Product: Calc
           Version: AOO 3.4.1
          Hardware: Mac
                OS: Mac OSX, 10.6
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: programming
          Assignee: issues@openoffice.apache.org
          Reporter: cphedonist@gmail.com
                CC: issues@openoffice.apache.org

I downloaded OpenOffice V3.4.1 for Mac 10.6 earlier this week.  Everything I
did in a worksheet tracked to my memory of Excel in a past life until I tried
using the "If" function. 



This example:

A1 = -9.31 (keypunched), B1 = 23.48 (keypunched), C1 =
if(a1<0;a1=b1+1;"Altered")

Returns:

A1 = -9.31, B1=23.48, C1=FALSE



C1=IF(-9.31<0;a1=23.48+1;"Altered") returns the same result

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 122699] Conditional cell address value reassignment

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122699

Chris <cp...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |cphedonist@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 122699] Conditional cell address value reassignment

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122699

Edwin Sharp <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |elish@mail-page.com
         Resolution|---                         |NOTABUG

--- Comment #1 from Edwin Sharp <el...@mail-page.com> ---
Same result in Excel 2010...
Impossible to assign in ThenValue i.e. a1=b1+1 will not execute although Test
is true.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.