/**
* Resolves internal function names into function indexes.
*
* <p>The name matching is case insensitive.
*
* @return the standard worksheet function index if found, otherwise
* <tt>FUNCTION_INDEX_EXTERNAL</tt>
*/
protected static short lookupIndex(String name) {
short ix = FunctionMetadataRegistry.lookupIndexByName(name.toUpperCase());
if (ix < 0) {
return FUNCTION_INDEX_EXTERNAL;
}
return ix;
}
/**
* Used to detect whether a function name found in a formula is one of the standard excel
* functions
*
* <p>The name matching is case insensitive.
*
* @return <code>true</code> if the name specifies a standard worksheet function, <code>false
* </code> if the name should be assumed to be an external function.
*/
public static final boolean isBuiltInFunctionName(String name) {
short ix = FunctionMetadataRegistry.lookupIndexByName(name.toUpperCase());
return ix >= 0;
}
