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

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

    • Post Options:
    • Link

    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.

  • Posted 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