Details

    • Type: Bug
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2, ODF 1.3
    • Fix Version/s: ODF 1.3
    • Labels:
      None
    • Environment:

      Formula

    • Proposal:
      Hide

      Agreed at ODF TC meeting to this issue and to set for ODF 1.3.

      Show
      Agreed at ODF TC meeting to this issue and to set for ODF 1.3.

      Description

      LINEST, LOGEST, MATCH, VLOOKUP and HLOOKUP should have ForceArray parameter types.

      should read:

      LINEST( ForceArray Array knownY [ ; [ ForceArray Array knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] )

      LOGEST( ForceArray Array knownY [ ; [ ForceArray Array knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] )

      HLOOKUP( Any Lookup ; ForceArray Reference|Array DataSource ; Integer Row [ ; Logical RangeLookup = TRUE() ] )

      MATCH( Scalar Search ; ForceArray Reference|Array SearchRegion [ ; Integer MatchType = 1 ] )

      VLOOKUP( Any Lookup ; ForceArray Reference|Array DataSource ; Integer Column [ ; Logical RangeLookup = TRUE() ] )

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Patrick Patrick Durusau
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: