Aspose::Cells::Worksheet::ConvertFormulaReferenceStyle method

Worksheet::ConvertFormulaReferenceStyle(const U16String&, bool, int32_t, int32_t) method

Converts the formula reference style.

U16String Aspose::Cells::Worksheet::ConvertFormulaReferenceStyle(const U16String &formula, bool toR1C1, int32_t baseCellRow, int32_t baseCellColumn)
ParameterTypeDescription
formulaconst U16String&The formula to be converted.
toR1C1boolWhich 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;
baseCellRowint32_tThe row index of the base cell.
baseCellColumnint32_tThe column index of the base cell.

ReturnValue

The converted formula.

See Also

Worksheet::ConvertFormulaReferenceStyle(const char16_t*, bool, int32_t, int32_t) method

Converts the formula reference style.

U16String Aspose::Cells::Worksheet::ConvertFormulaReferenceStyle(const char16_t *formula, bool toR1C1, int32_t baseCellRow, int32_t baseCellColumn)
ParameterTypeDescription
formulaconst char16_t*The formula to be converted.
toR1C1boolWhich 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;
baseCellRowint32_tThe row index of the base cell.
baseCellColumnint32_tThe column index of the base cell.

ReturnValue

The converted formula.

See Also