You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/03/12 11:30:54 UTC
[Bug 54673] New: [PATCH] Simple wildcard support in HLOOKUP,
VOOLKUP, MATCH, COUNTIF
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
[Bug 54673] [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
MATCH, COUNTIF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30048|1 |0
is patch| |
Attachment #30048|text/plain |application/x-gzip
mime type| |
--
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
[Bug 54673] [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
MATCH, COUNTIF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673
--- Comment #2 from opensource@innoveo.com ---
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
--
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
[Bug 54673] [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
MATCH, COUNTIF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #5 from Nick Burch <ap...@gagravarr.org> ---
Looks like this was actually committed last year, shortly after being
contributed:
r1457243 | yegor | 2013-03-16 12:33:08 +0000 (Sat, 16 Mar 2013) | 1 line
Bug 54673 - [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF
As such, closing this bug now
--
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
[Bug 54673] [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
MATCH, COUNTIF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from opensource@innoveo.com ---
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
--
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
[Bug 54673] [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
MATCH, COUNTIF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30041|0 |1
is obsolete| |
--- Comment #3 from opensource@innoveo.com ---
Created attachment 30048
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30048&action=edit
added testcases for complex wildcard values support
--
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
[Bug 54673] [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP,
MATCH, COUNTIF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54673
--- Comment #4 from opensource@innoveo.com ---
Created attachment 30049
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30049&action=edit
xls used by testcases to be copied into test-data\spreadsheet
--
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