Missing ForceArray parameter types

XMLWordPrintable

    • 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.

      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() ] )

            Assignee:
            Unassigned
            Reporter:
            Patrick Durusau
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: