vlookup - optimize SC_EQUAL and NOT_EQUAL.

Desktop / LibreOffice - Michael Meeks [collabora.com] - 10 April 2018 20:28 EDT

Also don't accept partial matches ie. CONTAINS != EQUAL, for VLOOKUP even if document option "search criteria =, <> for whole cells" is turned off.

This also adds a new spreadsheet test file vlookup2.fods with the option "search criteria =,<> for whole cells" turned off, with VLOOKUP test cases that ensures that partial matches are not accepted.

Change-Id: Ib1f4781b216431546c3fd6967f22518e86abf36b Reviewed-on: https://gerrit.libreoffice.org/52589

a953fa1c0f6a vlookup - optimize SC_EQUAL and NOT_EQUAL.
.../data/functions/spreadsheet/fods/vlookup2.fods | 1562 ++++++++++++++++++++
sc/source/core/data/table3.cxx | 9 +
2 files changed, 1571 insertions(+)

Upstream: cgit.freedesktop.org


  • Share