CGXWorksheetFunctions::LookupFunction
virtual gxKeyword* LookupFunction(LPCTSTR text) = 0;
text
A string with the function name.
Return Value
Returns a pointer to the keyword entry; NULL if the function name could not be found.
Remarks
This virtual method is called from the formula engine to search for a function. You should override this methode in your derived class and return Lookup(text, fn_table, sizeof(fn_table));
Example:
class CGXDefaultWorksheetFunctions: public CGXWorksheetFunctions
{
public:
// Constructor
CGXDefaultWorksheetFunctions();
// Lookup
virtual gxKeyword* LookupFunction(LPCTSTR text);
// Attributes (keyword table table)
static gxKeyword fn_table[];
static int fn_table_size;
};
gxKeyword* CGXDefaultWorksheetFunctions::LookupFunction(LPCTSTR text)
{
// Override this methode in your derived class and
// return Lookup(text, fn_table, sizeof(fn_table));
// (see CGXAllWorksheetFunctions::Lookup as an example)
return Lookup(text, fn_table, fn_table_size);
}
gxKeyword CGXDefaultWorksheetFunctions::fn_table[] =
{
{_T("@"), _gx_fn_indirect, 0, 0, GX_TC_RANGE, 1,
{{GX_TC_STRING, STRICT, GX_REQUIRED}
}},
{_T("ABS"), _gx_fn_abs, 0, 0, GX_TC_NUMBER, 1,
{{GX_TC_NUMERIC, STRICT, GX_REQUIRED}
}},
{_T("ACCRINT"), _gx_fn_accrint, 0, 0, GX_TC_NUMBER, 7,
{{GX_TC_NUMERIC, STRICT, GX_REQUIRED},
{GX_TC_NUMERIC, STRICT, GX_REQUIRED},
{GX_TC_NUMERIC, STRICT, GX_REQUIRED},
{GX_TC_NUMERIC, STRICT, GX_REQUIRED},
{GX_TC_NUMERIC, STRICT, GX_REQUIRED},
{GX_TC_NUMERIC, STRICT, GX_REQUIRED},
{GX_TC_NUMERIC, STRICT, OPTIONAL}
}},
};
int CGXDefaultWorksheetFunctions::fn_table_size = sizeof(fn_table);
