office-comment message

Subject: MATCH, VLOOKUP and HLOOKUP should have ForceArray parameter types

From: Eike Rathke <erack@redhat.com>
To: office-comment@lists.oasis-open.org
Date: Mon, 4 Apr 2016 15:14:43 +0100

Hi,

In OpenFormula, similar to LOOKUP, the functions MATCH, VLOOKUP and HLOOKUP
should have parameters of type ForceArray Reference|Array, so the definitions
should read:

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


This is what Excel and LibreOffice implement.

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack

Attachment: signature.asc
Description: PGP signature