https://issues.apache.org/ooo/show_bug.cgi?id=123020
Bug ID: 123020
Issue Type: ENHANCEMENT
Summary: Conditional Rounding - "=ROUND(IF" not implemented
properly
Product: Calc
Version: 4.0.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: programming
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Place any number above 1 into column A2. Then proceed to round -
In Excel only this works: =ROUND(IF(A2>1,A2*0.5,A2),0)
The same code in OpenOffice fails with Error: 509.
In OpenOffice this is the work around: =ROUND(IF(A2>1;A2*0.5;A2);0)
The two are not backwards compatible with each other due to one semi-colon.
I would request a conversion take place automatically or the normal formula be
implemented to avoid confusion.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
