Wildcard lookup values not supported yet

["cedric.walter" <ce...@innoveo.com>]

Hi all,

I have some excel that use a lot of Wildcard lookup values. And this is noo 
supported in POI 3.9, as seen here in the code of the trunk

http://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/ss/formula/fun
ctions/Match.java

private static LookupValueComparer createLookupComparer(ValueEval lookupValue, 
boolean matchExact) {
 if (matchExact && lookupValue instanceof StringEval) {
	String stringValue = ((StringEval) lookupValue).getStringValue();
	if(isLookupValueWild(stringValue)) {
		throw new RuntimeException("Wildcard lookup values '" + 
stringValue + "' not supported yet");
	}
 }
 return LookupUtils.createLookupComparer(lookupValue);
}
private static boolean isLookupValueWild(String stringValue) {
 if(stringValue.indexOf('?') >=0 || stringValue.indexOf('*') >=0) { 
	return true;
 }
 return false;
}

here is an example out of my excel
*_TableValues_Label

My Questions are

* Would it be difficult to develop this functionality? If i get guidance (what 
has to be done) i would be ready to develop it and provide a patch. 

Is there a excel way to get around this, some pointers or experience (i know it 
is domains specific, but some guidance would be also appreciated)

Thanks
Cédric




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