Summary: | [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF | ||
---|---|---|---|
Product: | POI | Reporter: | opensource |
Component: | POI Overall | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | ||
Priority: | P2 | ||
Version: | 3.10-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: |
diff files generated using ant patchpackage task + excel LookupFunctionsTestCaseData.xls
added testcases for complex wildcard values support xls used by testcases to be copied into test-data\spreadsheet |
I've added more than 150 new unitary tests in LookupFunctionsTestCaseData.xls) show that complex wildcards are also supported by the core of apache poi and this patch! new LookupFunctionsTestCaseData.xls will be uploaded here later added files + org.apache.poi.ss.formula.functions.TestFunctionsFromSpreadsheet + org.apache.poi.ss.formula.functions.TestMatchFunctionsFromSpreadsheet + MatchFunctionTestCaseData.xls Limitations Current patch has some limitations: Match don't support wilcards values with Match type * 1 Largest value * -1 Smallest value for both simple and complex wildcard, testcases in MatchFunctionTestCaseData.xls are defined but skipped using <skip> Use patch.tar.gz + spreadsheet.zip Created attachment 30048 [details]
added testcases for complex wildcard values support
Created attachment 30049 [details]
xls used by testcases to be copied into test-data\spreadsheet
|
Created attachment 30041 [details] diff files generated using ant patchpackage task + excel LookupFunctionsTestCaseData.xls 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