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

    <P><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></P>
    <P><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></P>
    <P><FONT face=Arial>FarPoint.Win.Spread.Model.ParseException: Invalid token was encountered.</FONT></P>
    <P><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></P>
    <P><FONT face=Arial>Here's a sample line of code that fails:</FONT></P><FONT size=2>
    <P><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></P></FONT>
    <P><FONT face=Arial>Is the help file incorrect?  Or am I doing something wrong?  I'm using FarPoint Spread 3.0.2003.2005.</FONT></P>
    <P><FONT face=Arial></FONT> </P>
    <P> </P>
  • Replied 8 September 2017, 12:45 pm EST

    Make sure you have set the ReferenceStyle to the R1C1 notation.<br>
  • 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