You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by Opensource <op...@innoveo.com> on 2013/03/12 11:43:36 UTC

Bug 54673 - [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF

Hi All,

thanks for your review and feedbacks.

Support now wilcards
? (question mark) Any single character
    For example, sm?th finds "smith" and "smyth"
* (asterisk) Any number of characters
    For example, *east finds "Northeast" and "Southeast"
~ (tilde) followed by ?, *, or ~A question mark, asterisk, or tilde
    For example, fy91~? finds "fy91?"

Combinations are supported and were extensively tested

Testcases extended
* LookupFunctionsTestCaseData.xls
* org.apache.poi.ss.formula.functions.TestCountFuncs
* org.apache.poi.ss.formula.functions.TestMatch