ParseException when Using R1C1 notation in SUM function

Posted by: bburba on 8 September 2017, 12:45 pm EST

  • Posted 8 September 2017, 12:45 pm EST

    <FONT face=Arial>In the FarPoint Spread for .Net 3.0 formula reference, the SUM function description says: "R1C[1]:R2C[2] is okay but, R1C1:R2C[2] is not." </FONT>

    <FONT face=Arial>When I try to use the SUM formula with (R1C[1]:R2C[2]) or any R1C1-style range, I get a run-time exception:</FONT>

    <FONT face=Arial>FarPoint.Win.Spread.Model.ParseException: Invalid token was encountered.</FONT>

    <FONT face=Arial>Is there any way to use R1C1 range notation with the SUM function?  I have 24 columns, each of which needs a SUM function in the last row.  I'd much rather set each cell to the same forumla for each column (i.e. SUM(R1C:R15C)) instead of having to write 24 separate formulas for the 24 separate columns.</FONT>

    <FONT face=Arial>Here's a sample line of code that fails:</FONT>

    <FONT size=2>

    <FONT face="Courier New">FpSpread1_Sheet1.Cells(11, 0).Formula = </FONT></FONT><FONT color=#a31515 size=2><FONT face="Courier New">"SUM(R1C:R10C)"</FONT>


    <FONT face=Arial>Is the help file incorrect?  Or am I doing something wrong?  I'm using FarPoint Spread 3.0.2003.2005.</FONT>

    <FONT face=Arial></FONT> 


  • Replied 8 September 2017, 12:45 pm EST

    Make sure you have set the ReferenceStyle to the R1C1 notation.
  • Replied 8 September 2017, 12:45 pm EST

    <FONT face=Arial>I love the easy ones.  That fixed my problem.  Thanks!</FONT>
Need extra support?

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

Learn More

Forum Channels