Worksheet.ConvertFormulaReferenceStyle

Worksheet.ConvertFormulaReferenceStyle method

Converts the formula reference style.

public string ConvertFormulaReferenceStyle(string formula, bool toR1C1, int baseCellRow, 
    int baseCellColumn)

Parameter	Type	Description
formula	String	The formula to be converted.
toR1C1	Boolean	Which reference style to convert the formula to. If the original formula is of A1 reference style, then this value should be true so the formula will be converted from A1 to R1C1 reference style; If the original formula is of R1C1 reference style, then this value should be false so the formula will be converted from R1C1 to A1 reference style;
baseCellRow	Int32	The row index of the base cell.
baseCellColumn	Int32	The column index of the base cell.

The converted formula.