[OFFICE-3902] Missing ForceArray parameter types - OASIS Technical Committees Issue Tracker

XML

Word

Printable

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.

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