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.