OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: RE: HLOOKUP and VLOOKUP


Hi,
I agree that the statement about binary searches need not or should not be there.

We cannot just require that the range is sorted since readers might think that to mean that for non sorted ranges an error should be returned.

So we need to say that in that case the behavior is implementation dependent.

Andreas



Sent from my Galaxy


-------- Original message --------
From: Patrick Durusau <patrick@durusau.net>
Date: 2023-01-27 14:12 (GMT-07:00)
To: "Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>, ODF TC List <office@lists.oasis-open.org>
Subject: HLOOKUP and VLOOKUP

Andreas,

Francis and I are puzzling over the last two sentences in HLOOKUP and
VLOOKUP, both of which read:

"If DataSource is not sorted, the result is undetermined and
implementation-dependent. In most cases it will be arbitrary and just
plain wrong due to binary search algorithms."

We can just require the DataSource to be sorted and fall silent about
what happens when it's not sorted.

The final sentence, " In most cases it will be arbitrary and just plain
wrong due to binary search algorithms.", in any event, seemed like a odd
statement to have in a standard. Yes?

Thanks!

Hope you are about to start a great weekend!

Patrick

--
Patrick Durusau
patrick@durusau.net
Technical Advisory Board, OASIS (TAB)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]