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-1469) Public Comment:[office-formula] Domain problems with exponential operator andfunctionPOWER

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Tue, 2 Feb 2010 12:16:15 -0500 (EST)

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

Dennis Hamilton commented on OFFICE-1469:
-----------------------------------------

Based on our conversation today, I think we need to do two things.

1. ^ and POWER should be defined the same.  (If one accepts complex numbers or can produce a complex result, so should the other).  I don't think we should ever automatically produce a complex result hower.  The user should be completely in control of where Complex Number appears and where it is intended to be used.  (Note that there are cases were POWER of two Number Types could produce a Complex Number result as a surprise.)

2. We need to somehow indicate that we expect Number type results of POWER(x,y) when either x > 0 or when x < 0 and y is an exactly-represented integer.  Any other results are implementation defined and an error condition is appropriate. (However we say that.)  [Note that for large positive y, the result may not be representable for x > 1 (overflow) and may be imprecise or approximated by 0 for x < 1 (underflow).  For large negative y, the reverse situation applies with regard to values of x.]

> Public Comment: [office-formula] Domain problems with exponential operator and functionPOWER
> --------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-1469
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1469
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>            Reporter: Robert Weir
>            Assignee: Robert Weir
>            Priority: Minor
>             Fix For: ODF 1.2 Part 2 CD 1
>
>
> Copied from office-comment list
> Original author: Regina Henschel <rb.henschel@t-online.de>
> Original date: 15 Apr 2009 10:17:12 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200904/msg00023.html

--
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
-

```

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