XLL+ Class Library (7.0)


Changes the style and type of references in a formula between A1 and R1C1 and between relative and absolute

static int FormulaConvert(
   CString& strformula,
   LPCTSTR formula_text,
   bool from_a1,
   short int to_a1 = -1,
   unsigned short to_ref_type = 0,
   const CXlOper& rel_to_ref = CXlOper::MissingArg()



A reference to a string that will contain the desired data if the function succeeds.


Formula_text is the formula, given as text, containing the references you want to change.


From_a1 is a logical value specifying whether the references in formula_text are in A1 or R1C1 style.


To_a1 is a logical value specifying the form for the references FORMULA.CONVERT returns. A value of -1 is treated as a missing argument, A value greater than 0 is treated as TRUE, and 0 is treated as FALSE.


To_ref_type is a number from 1 to 4 specifying the reference type of the returned formula. A value of 0 is treated as a missing argument, A value greater than 0 is treated normally.


Rel_to_ref is an absolute reference that specifies what cell the relative references are or should be relative to.

Return Value

Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.


See the Microsoft Excel on-line Help for full details about this function.


Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods