
Type: Bug

Status: Closed

Priority: Major

Resolution: Fixed

Affects Version/s: None

Fix Version/s: ODF 1.2

Component/s: OpenFormula

Labels:None

Proposal:

Resolution:
We have in 5.2:
Constraints: A description of constraints, in addition to the constraints imposed by the
parameter types. If there are no additional constraints beyond those imposed by the
parameter types, this is "None". If a constraint is not met, the function/operator should return
an Error unless otherwise noted.
I always, perhaps incorrectly, read this as that the constraints limit the possible parameters (beyond what is implied by their type).
In the function descriptions we have:
ACOT Constraints: The result must be between 0 and PI().
ACOTH Constraints: Real result
ATAN Constraints: The result must be between PI()/2.0 and PI()/2.0.