This project has moved and is read-only. For the latest updates, please go here.

FormulaR1C1 increasing row value.

Feb 4, 2015 at 6:28 PM
I have set a formula as follows:
RMWorksheet.Cells[3, 2, (dt3.Rows.Count + 2), 2].FormulaR1C1 = "'Dados Projeto'!R[-1]C";

The problem is it increases the value of the Row to -2,-3,... and as so references the same value. How can I make it stick as -1 for all cells.