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

XMLWordPrintable

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

      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.

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

              Created:
              Updated:
              Resolved: