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

Posted by: fokostaelle on 19 November 2018, 7:55 am EST

  • Posted 19 November 2018, 7:55 am EST

    Hello,
    there are spreadsheets in .Net application I'm working on. I don't know how it works and I get this error:
    FarPoint.Web.Spread.Model.ParseException: Invalid token was encountered. Error offset 11.
    The error is related to this line of code:

    FpSpread.Rows(index).Formula = "SUBTOTAL(9,R[1]C:R[" & nb & "]C)"

    where nb is an integer. Doing some research, I found that this is probably related to position 11 of my string, but I'm no more advanced.

    Please help.
  • Marked as Answer

    Replied 21 November 2018, 1:09 am EST

    Hello,

    Error indicates that there is an issue when parsing the formula range. Please make sure that you have set the ReferenceStyle for Sheet in your application to R1C1. For example

    FpSpread1.ActiveSheetView.ReferenceStyle=FarPoint.Web.Spread.Model.ReferenceStyle.R1C1;

    In case the issue still persists, please provide me a sample application to debug this issue.

    Thanks,
    Deepak Sharma
Need extra support?

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

Learn More

Forum Channels