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: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
