[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Another OpenFormula problem: parsing empty arguments
From:       Brad Hards <bradh () frogmouth ! net>
Date:       2007-01-27 6:00:02
Message-ID: 200701271700.03189.bradh () frogmouth ! net
[Download RAW message or body]

I need a hand with a problem with implementing IF() per the OpenFormula spec.

This is what the draft says:
<quote>
Summary: Return one of two values, depending on a condition

Syntax: IF( Logical Condition ; Any IfTrue [ ; Any IfFalse ] )

Returns: Any

Constraints: None.

Semantics: Computes Condition. If it is TRUE, it returns IfTrue, else it 
returns IfFalse. If there are only 2 parameters, IfFalse is considered to be 
FALSE. If there are 3 parameters but the third parameter is null, IfFalse is 
considered to be 0.  This function only evaluates IfTrue, or ifFalse, and 
never both; that is to say, it short-circuits.
</quote>

I assume that standardises some weird behaviour in Excel.

I've got it working in accordance with that, except for the "3 parameters, 
third parameter is null" case (e.g. =IF(FALSE();7;) should produce 0, while
=IF(FALSE();7) should produce false). All I'm getting is a #PARSE! error.

Any suggestions on where I should look?

Brad
_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel

[prev in list] [next in list] [prev in thread] [next in thread]