Formula evaluation - cell returning - "#Name?"

Posted by: farpoint1976 on 8 September 2017, 2:03 pm EST

  • Posted 8 September 2017, 2:03 pm EST

    <FONT color=#000000> I am using the farpoint spread and running into issues using formulas.</FONT>

    <FONT color=#000000>I have set the set the reference type of the Activesheet to R1C1. </FONT><FONT color=#000000>This is the forumula that i am using to sum the 3 cells above the cell that i have marked as a formula cell</FONT>

    <FONT color=#000000>Variation 1:  <FONT size=2><FONT size=2>fpSpread1.ActiveSheet.Cells[6, 2].Formula = "SUM(R3C2,R4C2,R5C2)";</FONT></FONT></FONT>

    <FONT size=2><FONT size=2><FONT color=#000000>Variation 2:  <FONT size=2><FONT size=2>fpSpread1.ActiveSheet.Cells[6, 2].Formula = <FONT size=2><FONT size=2>"SUM(R[-3]C,R[-2]C,R[-1]C)";


    <FONT size=2><FONT color=#000000 size=2>Both these formula return "#Name?" in the formula cell instead of showing the summation of the 3 cells.</FONT></FONT>

    <FONT size=2><FONT color=#cc0000 size=2>Am i missing  any setting for the cells that is causing this?</FONT></FONT>

    <FONT color=#008000></FONT><FONT color=#008000 size=2><FONT color=#008000 size=2> 

  • Replied 8 September 2017, 2:03 pm EST


    I have tested the same at my side and this is working as expected and correctly evaluating the SUM function in Cell(6,2). I am not getting # Name in my cell (6,2). If I enter any numeric values in cells C4, C5 and C6, based on the values in these cells.SUM is being correctly performed in cell C7 (Cell(6,2)). Are there any additional steps to replicate the said issue at our side ?


  • Replied 8 September 2017, 2:03 pm EST


    The #NAME? error is returned when a formula uses a name (e.g. constant name or function name) that does not exist.  This error could occur if you use a custom name or custom function in a formula but you forgot to define the custom name or custom function (e.g. enter formula =SUM(ALPHA,BETA) when either ALPHA or BETA has not been defined).  This error could occur if you incorrectly spell a function name in a formula (e.g. enter formula =SUN(R3C2,R4C2,R5C2) where the SUM function is spelled incorrectly).  This error could occur if you enter a formula using one reference style but the sheet is currently set to a different reference style (e.g. enter formula =SUM(R3C2,R4C2,R5C2) when sheet is using A1 reference style).  This error could occur if your formula references a cell that contains the #NAME? error (e.g. enter formula =SUM(R3C2,R4C2,R5C2) when cell R3C2 contains the #NAME? error).

    There is not enough information in your post to determine the exact reason you are getting a #NAME? error result.  Could you provide sample code or sample application that reproduces the issue?


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels