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-1191

Public Comment: [ODFF] SERIESSUM needs a rule for x=0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Fix Version/s: ODF 1.2 Part 2 CD 2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Add to Constraints:
      X <> 0 if any of the exponents, which are generated from N and M, are negative.

      Add to Semantics:
      If X=0 and all of the exponents are non-negative, then 0^0 shall be set to 1 and 0^(exponent>0) shall be set to 0.

      Show
      Add to Constraints: X <> 0 if any of the exponents, which are generated from N and M, are negative. Add to Semantics: If X=0 and all of the exponents are non-negative, then 0^0 shall be set to 1 and 0^(exponent>0) shall be set to 0.

      Description

      Copied from office-comment list

      Original author: Regina Henschel <rb.henschel@t-online.de>
      Original date: 2 Jan 2009 19:59:06 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200901/msg00000.html

      Dennis Hamilton, 2010-02-01:

      This public comment notes that the cases for X=0 are problematic if the series specified a negative exponent for any term and also if the exponent 0 arises.

      The current specification does not require or treat the exponents and the interval as integers. If non-integral values are permitted, there are additional problematic cases.

      Although 0^0 = 1 is assumed by some practitioners, it is arguable that 0^0 is not mathematically determined. Since some spreadsheet programs already treat this as an error, it would seem prudent to continue to do so.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: