XLL+ Class Library

CXlOper::GetFormulaIntl

Get the formula in the referenced cell, in English

[C++]
BOOL GetFormulaIntl(
   CString& strFormula,
   BOOL& bIsArray,
   BOOL bA1 = TRUE
) const;

Parameters

strFormula

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

bIsArray

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

bA1

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.

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

Requirements

Header: xllplus.h

See Also

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