Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2676

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

    XMLWordPrintable

    Details

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

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: