Public Comment: [office-formula] IMLOG, IMLOG10, IMLOG2 and IMSQRT have no formula

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2 CD 06
    • Affects Version/s: ODF 1.2 Part 2 CD 2
    • Component/s: OpenFormula
    • None
    • 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

            Assignee:
            Andreas Guelzow (Inactive)
            Reporter:
            Robert Weir (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: