https://issues.apache.org/bugzilla/show_bug.cgi?id=45289
Summary: [PATCH]Small improvement for HSSF Countif function
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: enhancement
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
The current COUNTIF funztion implementation in HSSF can handle espression like
COUNTIF(A1:A5; "12")
COUNTIF(A1:A5; "right")
but not analogous ones like
COUNTIF(A1:A5; "=12")
COUNTIF(A1:A5; "=right")
A simple patch could consist of small editing of createGeneralMatchPredicate
method:
1) replace the first statement
String value = stringEval.getStringValue();
with
String value = stringEval.getStringValue().replaceAll("^=", "");
2) comment out the
case '=':
statement (preserving the throw statement right next)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
