[OASIS Issue Tracker] Updated: (OFFICE-2676) Public Comment:[office-formula] IMLOG, IMLOG10, IMLOG2 and IMSQRT have no formula

[ http://tools.oasis-open.org/issues/browse/OFFICE-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andreas Guelzow  updated OFFICE-2676:
-------------------------------------

    Resolution: 
1) Replace the semantics of 6.8.22 IMSQRT with:

If N = 0+0i, then IMSQRT(N)=0. Otherwise IMSQRT(N) is SQRT(IMABS(N)) * sin(IMARGUMENT(N)/2) + SQRT(IMABS(N)) * cos(IMARGUMENT(N)/2) i.

2) Note that the reporter refers to IMLOG which does not exist. I suspect that she meant IMLN:
Replace the semantics of 6.8.13 IMLN with:

IMLN(X) is  LN(IMABS(X)) + IMARGUMENT(X)i

add a constraint of:
 X ≠ 0

3) replace the semantics of 6.8.14 IMLOG10 with

IMLOG10(X) is IMDIV(IMLN(X),COMPLEX(LN(10),0))

and add a constraint of
X ≠ 0


4) replace the semantics of 6.8.15 IMLOG2 with

IMLOG2(X) is IMDIV(IMLN(X),COMPLEX(LN(2),0))

and add a constraint of
X ≠ 0


  was:
1) Replace the semantics of 6.8.22 IMSQRT with:

If N = 0+0i, then IMSQRT(N)=0. Otherwise IMSQRT(N) is SQRT(IMABS(N)) * sin(IMARGUMENT(N)/2) + SQRT(IMABS(N)) * cos(IMARGUMENT(N)/2) i.

2) Note that the reporter refers to IMLOG which does not exist. I suspect that she meant IMLN:
Replace the semantics of 6.8.13 IMLN with:

IMLN(X) is  LN(IMABS(X)) + IMARGUMENT(X)i

add a constraint of:
 X ≠ 0

3) replace the semantics of 6.8.14 IMLOG10 with

IMLOG10(X) is IMDIV(IMLN(X),COMPLEX(10,0))

and add a constraint of
X ≠ 0


4) replace the semantics of 6.8.15 IMLOG2 with

IMLOG2(X) is IMDIV(IMLN(X),COMPLEX(2,0))

and add a constraint of
X ≠ 0



> Public Comment: [office-formula] IMLOG, IMLOG10, IMLOG2 and IMSQRT have no formula
> ----------------------------------------------------------------------------------
>
>                 Key: OFFICE-2676
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2676
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 2
>            Reporter: Robert Weir 
>            Assignee: Andreas Guelzow 
>             Fix For: ODF 1.2 CD 06
>
>
> Copied from office-comment list
> Original author: Regina Henschel <> 
> Original date: 6 May 2010 15:09:50 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/201005/msg00021.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