XLL+ Class Library (7.0)


Get the formula in the referenced cell, in English

BOOL GetFormulaIntlA(
   CStringA& strFormula,
   BOOL& bIsArray,
   BOOL bA1 = TRUE
) const;



String buffer which will be filled with the formula. The formula will be in English and will use US English settings for punctuation.


Will be set to TRUE if the cell is part of an array; to FALSE if it is not.


If TRUE, then the formula will contain references in A1 format; if FALSE, the references will be in RC format.

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".


Header: xllplus.h

See Also

CXlOper Class | CXlOper Methods | CXlOper::SetFormulaIntl() | CXlOper::ConvertFormulaIntl() | CXlOper::GetFormula()