CXlOper::ConvertFormulaIntlA

Convert a formula between A1 and RC formats, using English language settings

BOOL ConvertFormulaIntlA(
   const char* pszFormulaIn,
   CStringA& strFormulaOut,
   BOOL bToA1
) const;

Parameters

pszFormulaIn

String buffer containing the formula. The formula is assumed to be in English, using US English regional settings - i.e. arguments and lists are separated by commas; rows in arrays are separated by semi-colons; the full stop is used as a decimal point.

If the formula is not in the correct English format, then the call will fail. To convert a formula which works using local language settings, see CXlOper::ConvertFormula.

strFormulaOut

Buffer to receive converted formula.

bToA1

If FALSE, then pszFormulaIn should contain references in A1 format; they will be converted to RC. If TRUE, the references should be in RC format; they will be converted to A1.

Return Value

Remarks

This method requires that the calling object be a valid reference (i.e. this->IsRef() is true). Relative addresses in the formula will be treated as being relative to the calling object's reference.

Requirements

Header: xllplus.h

See Also

CXlOper Class | CXlOper Methods | CXlOper::GetFormulaIntl() | CXlOper::SetFormulaIntl()