XLL+ Class Library (7.0)


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

BOOL GetLongFormula(
   CString& strFormula
) const;



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.


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.


Header: xllplus.h

See Also

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