Issue 29 in formulacompiler: MATCH is not resilient to trailing empty cells in lookup range
formula...@googlecode.com
Owner: peter.arrenbrecht
Labels: Type-Defect Priority-Medium Component-Runtime
New issue 29 by peter.arrenbrecht: MATCH is not resilient to trailing empty
cells in lookup range
http://code.google.com/p/formulacompiler/issues/detail?id=29
What steps will reproduce the problem?
1. Use MATCH(value;range) where range has a more trailing empty cells than
filled-in cells.
2. Run compiled engine.
Excel and OpenOffice will return the expected result. They seem to always
scan the range from the start.
AFC currently uses a binary search, which fails. AFC is, in principle,
correct because the trailing empty cells actually violate the spec that the
range should be sorted (see
http://office.microsoft.com/en-ca/excel-help/match-HP005209168.aspx).
I am still going to change AFC to be slightly slower but more compatible
with Excel.
formula...@googlecode.com
Status: Fixed
Comment #1 on issue 29 by peter.arrenbrecht: MATCH is not resilient to
trailing empty cells in lookup range
http://code.google.com/p/formulacompiler/issues/detail?id=29
(No comment was entered for this change.)