CXlOper::Evaluate

Evaluate a formula expressed in local language


int Evaluate( const char* pszFormula ); int Evaluate( const wchar_t* pszFormula );

Parameters

pszFormula: A string containing the formula to be evaluated.

Return Value

The result of the SDK call-back. xlretSuccess (0) indicates success. Other values indicate failure. A full list of return values can be found in Error Codes.

Remarks

This function fills the CXlOper object with the result of the formula passed to it.

International considerations

Be careful when using formulae that the formula is formatted correctly for the current language settings. For example, arguments in English are separated by commas; in German, semi-colons are used.

You can use CXllApp::GetInternational to get the current list separators and other punctuation characters.

Alternatively, you can use CXlOper::EvaluateIntl to apply formulae that work under all language settings.

Requirements