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

XML

Word

Printable

Resolution:

Hide

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

Show
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

Copied from office-comment list

Original author: Regina Henschel <rb.henschel@t-online.de>
Original date: 6 May 2010 15:09:50 -0000
Original URL: http://lists.oasis-open.org/archives/office-comment/201005/msg00021.html