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