https://bz.apache.org/ooo/show_bug.cgi?id=128585
Issue ID: 128585
Issue Type: DEFECT
Summary: Make the "IF" function compatible with ODF 1.3
Product: Calc
Version: 4.2.0-dev
Hardware: All
OS: All
Status: CONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: code
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I am creating this issue to track a harder kind of change to our OpenFormula
code, needed for ODF 1.3 compatibility.
On AOO:
| Condition
IF formula |TRUE | FALSE
--------------------------------+---------------+------
IF(condition) |TRUE |FALSE
IF(condition;) |Err:511 |Err:511
IF(condition;IfTrue) |IfTrue |FALSE
IF(condition;;) |Err:511 |Err:511
IF(condition;;IfFalse) |Err:518 |IfFalse
IF(condition;IfTrue;) |Err:511 |Err:511
IF(condition;IfTrue;IfFalse) |IfTrue |IfFalse
On LO, and as per the ODF 1.3 requirements:
| Condition
IF formula |TRUE | FALSE
--------------------------------+---------------+------
IF(condition) |TRUE |FALSE
IF(condition;) |0 |FALSE
IF(condition;IfTrue) |IfTrue |FALSE
IF(condition;;) |0 |0
IF(condition;;IfFalse) |0 |IfFalse
IF(condition;IfTrue;) |IfTrue |0
IF(condition;IfTrue;IfFalse) |IfTrue |IfFalse
--
You are receiving this mail because:
You are the assignee for the issue.
