Posted 8 September 2017, 2:03 pm EST
I am using the farpoint spread and running into issues using formulas.
I have set the set the reference type of the Activesheet to R1C1. This is the forumula that i am using to sum the 3 cells above the cell that i have marked as a formula cell
Variation 1: fpSpread1.ActiveSheet.Cells[6, 2].Formula = "SUM(R3C2,R4C2,R5C2)";
Variation 2: fpSpread1.ActiveSheet.Cells[6, 2].Formula = "SUM(R[-3]C,R[-2]C,R[-1]C)";
Both these formula return "#Name?" in the formula cell instead of showing the summation of the 3 cells.
Am i missing any setting for the cells that is causing this?