Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: OpenFormula
    • Labels:
      None
    • Environment:

      as per 11/26/2018

       

    • Proposal:
      Hide

      Constrains: Evaluators may restrict the evaluation to integer values for the order N.

      Show
      Constrains: Evaluators may restrict the evaluation to integer values for the order N.

      Description

      The BESSELJ function ( section 6.16.13 in ODF1.3 draft) has the Constraints "N >= 0, INT(N)=N; Evaluators may evaluate expressions where N >= 0 returns a non-error value."

      But the order N need not be non-negative, there exists reflection formulae. And the order N need not be integer, fractional order, especially half-integer is used too.

      References:

      http://functions.wolfram.com/webMathematica/FunctionPlotting.jsp?name=BesselJ&ptype=3&n=1&z=1&threeDtype2=0&part2=0&free1=n&free2=z&Min1=-5&Max1=5&Min2=-5&Max2=5

      https://en.wikipedia.org/wiki/Bessel_function

      https://www.boost.org/doc/libs/1_48_0/libs/math/doc/sf_and_dist/html/math_toolkit/special/bessel/bessel.html

      https://stat.ethz.ch/R-manual/R-devel/library/base/html/Bessel.html

        Attachments

          Activity

          Hide
          AlfredHellstern Alfred Hellstern added a comment -

          Note that the OOXML specification 18.17.7.24 does specify non-negative currently:

                     However, if n < 0, #NUM! is returned.

          Show
          AlfredHellstern Alfred Hellstern added a comment - Note that the OOXML specification 18.17.7.24 does specify non-negative currently:            However, if n < 0, #NUM! is returned.
          Hide
          aguelzow Andreas Guelzow (Inactive) added a comment -

          Gnumeric currently allows N to be any non-negative number (i.e. it need not be an integer.)

          e.g. =besselj(0.89,0.89) evaluates to 0.456188

           

           

          Show
          aguelzow Andreas Guelzow (Inactive) added a comment - Gnumeric currently allows N to be any non-negative number (i.e. it need not be an integer.) e.g. =besselj(0.89,0.89) evaluates to 0.456188    
          Hide
          aguelzow Andreas Guelzow (Inactive) added a comment -

          1.2 has:

          Summary: Returns the Bessel function of integer order Jn (cylinder function)
          Syntax: BESSELJ( Integer X ; Number N )
          Returns: Number
          Constraints: N >= 0, INT(N)=N; Evaluators may evaluate expressions where N >= 0 returns a
          non-error value.
          Semantics: Computes the Bessel function of integer order Jn. N is also known as the order.

           

          This issue talks about N, but why is X an integer?

           

          Show
          aguelzow Andreas Guelzow (Inactive) added a comment - 1.2 has: Summary: Returns the Bessel function of integer order Jn (cylinder function) Syntax: BESSELJ( Integer X ; Number N ) Returns: Number Constraints: N >= 0, INT(N)=N; Evaluators may evaluate expressions where N >= 0 returns a non-error value. Semantics: Computes the Bessel function of integer order Jn . N is also known as the order.   This issue talks about N, but why is X an integer?  
          Hide
          regina.henschel Regina Henschel added a comment -

          "This issue talks about N, but why is X an integer?"

          That was solved in https://issues.oasis-open.org/browse/OFFICE-3842.

          But the wording for ODF1.3 might need improvement, therefore my https://issues.oasis-open.org/browse/OFFICE-4006.

          Show
          regina.henschel Regina Henschel added a comment - "This issue talks about N, but why is X an integer?" That was solved in https://issues.oasis-open.org/browse/OFFICE-3842 . But the wording for ODF1.3 might need improvement, therefore my https://issues.oasis-open.org/browse/OFFICE-4006 .

            People

            • Assignee:
              Unassigned
              Reporter:
              regina.henschel Regina Henschel
            • Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: