poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54673] New: [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF
Date Tue, 12 Mar 2013 10:30:54 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673

            Bug ID: 54673
           Summary: [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
                    MATCH, COUNTIF
           Product: POI
           Version: 4.0-dev
          Hardware: PC
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: opensource@innoveo.com
    Classification: Unclassified

Created attachment 30041
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=30041&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message