Posted 8 September 2017, 12:45 pm EST
In the FarPoint Spread for .Net 3.0 formula reference, the SUM function description says: "R1C:R2C is okay but, R1C1:R2C is not."
When I try to use the SUM formula with (R1C:R2C) 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.