CXlOper::ConvertFormulaIntl

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

[C++]
BOOL ConvertFormulaIntl(
   const CString& strFormulaIn,
   CString& strFormulaOut,
   BOOL bToA1
) const;

Parameters

strFormulaIn

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 strFormulaIn 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

Returns TRUE if the function was successful, FALSE if it failed.

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()