Formula evaluation - cell returning - "#Name?"

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

  • 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?


     

  • Replied 8 September 2017, 2:03 pm EST

    Hello,

    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 ?

    Thanks

  • Replied 8 September 2017, 2:03 pm EST

    farpoint1976,


    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?


    Bobby

Need extra support?

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

Learn More

Forum Channels