Get the formula of the referenced cell, for formulae of more than 118 characters
BOOL GetLongFormulaA( CStringA& 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.
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".
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
CXlOper Class | CXlOper Methods | CXlOper::GetFormula() | CXlOper::SetFormula() | CXlOper::SetLongFormula() | CXlOper::SetLongFormulaIntl()