[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
[ http://tools.oasis-open.org/issues/browse/OFFICE-1469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16624#action_16624 ]
Dennis Hamilton commented on OFFICE-1469:
-----------------------------------------
The submitted comment seems very clear. The edge cases around either ^ or POWER are evidently not dealt with. In fact, the difficulties of POWER (and ^ which is defined to be the infix equivalent) are not identified at all except for the case where the two operands are exactly 0.
There are a variety of cases that must be define somehow or else ruled out. For example, when the right operand is not an exact integer value, the commonplace substition EXP(right*LOG(left)) fails when left is 0 or less. Dealing with simply-rational right operands is also a challenge and some exponention function implementations attempt to deal with those.
An example of the difficulties to be dealt with can be found in the Java Language API Specification for this function when given floating-point left and right operands. Those cases are comparable to ones that might be employed in treating spreadsheet number left and right POWER operands when there is no separate type for exact integer values. It seems necessary to say something about what can be counted on here, and also what cannot be counted on.
In this respect IMPOWER is even hairier, because the real cases should probably be a subset, especially when the exponent is not an integer (but at least it is not allowed to be complex). I note, en passant, that the IMLN definition is also rather opaque, failing to say of what the natural logarithm is taken and how that is incorporated into a complex number.
> 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
> Affects Versions: ODF 1.2
> Reporter: Robert Weir
> Assignee: Robert Weir
> Priority: Minor
> Fix For: ODF 1.2
>
>
> 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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]