XLL+ Class Library (7.0)

CXlOper::GetLongFormulaA

Get the formula of the referenced cell, for formulae of more than 118 characters

BOOL GetLongFormulaA(
   CStringA& strFormula
) const;

Parameters

strFormula

String buffer which will be filled with the formula. The formula will be in local form, as it appears in the Excel formula bar.

Return Value

Returns TRUE if the function was successful, FALSE if it failed. The function can fail if the CXlOper does not contain a reference, or if it cannot be run in Excel at this time.

Remarks

This function can only be called from macro functions, or from worksheet functions that have been marked as "Defer recalculation". It will always fail if called from worksheet functions that have not been marked as "Defer recalculation".

International considerations

Be aware when inspecting a formula retrieved using this method that the formula is formatted 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.

Requirements

Header: xllplus.h

See Also

CXlOper Class | CXlOper Methods | CXlOper::GetFormula() | CXlOper::SetFormula() | CXlOper::SetLongFormula() | CXlOper::SetLongFormulaIntl()