OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-2344) 3.4 Complex Number -conversion to complex

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Tue, 23 Mar 2010 13:46:15 -0400 (EDT)

```
[ http://tools.oasis-open.org/issues/browse/OFFICE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18148#action_18148 ]

David Wheeler  commented on OFFICE-2344:
----------------------------------------

Several issues here.

First of all, the definition of the COMPLEX() function is wrong.  The second parameter should have type Number, not type Complex.
Thus, COMPLEX(0;1) has the same value as IMSQRT(-1).  The function COMPLEX *produces* complex numbers;
it is a producer, not a consumer of them.  [Nitpick: In mathematics, real numbers are a subset of complex numbers.
Yes, I know that.  But we're talking about the types in the spec.]

--- David A. Wheeler

> 3.4 Complex Number - conversion to complex
> ------------------------------------------
>
>                 Key: OFFICE-2344
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2344
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 1
>            Reporter: Patrick Durusau
>            Assignee: Dennis Hamilton
>             Fix For: ODF 1.2 Part 2 CD 2
>
>
> The fourth paragraph under 3.4 Complex Number reads:
> ***
> Note that functions and operators that accept complex numbers shall accept Text values as complex numbers (see the section on convert to complex), as well as Numbers that are not complex numbers, so IMSUM("3i";4) will produce the same result as COMPLEX(4;3).
> ***
> If Text and Number values are automatically converted, then how does COMPLEX() accept Text values?
> By the time the value reaches COMPLEX() it is a complex number.
> Yes?

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-