Changes the style and type of references in a formula between A1 and R1C1 and between relative and absolute
[C++]
static int FormulaConvert(
CString& strformula,
const char* 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.
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