[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 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]