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

    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."

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

    FarPoint.Win.Spread.Model.ParseException: Invalid token was encountered.

    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.

    Here's a sample line of code that fails:

    FpSpread1_Sheet1.Cells(11, 0).Formula = "SUM(R1C:R10C)"

    Is the help file incorrect?  Or am I doing something wrong?  I'm using FarPoint Spread 3.0.2003.2005.



  • 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

    I love the easy ones.  That fixed my problem.  Thanks!
Need extra support?

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

Learn More

Forum Channels