1. Home
  2. Forum
  3. ASP.NET MVC - EJ 2
  4. Syncfusion.XlsIO.Implementation.Exceptions.ParseException: Table[Role] is not valid named range

Syncfusion.XlsIO.Implementation.Exceptions.ParseException: Table[Role] is not valid named range

We get this error while trying to copy this formula ("= vlookup (@ [Role]; Table2; 2; FALSE)") to a new row.


In VS (debug mode) the formula is copied as "= VLOOKUP (Table[Role]; Table2; 2; FALSE)" ("Table" is the name of the table where the formula is located).


I don't understand why I get a range where the implicit interceptor should define a single value. I don't even understand the error: "Syncfusion.XlsIO.Implementation.Exceptions.ParseException: Table[Role] is not a valid named range". Table[Role] is actually a range.



1 Reply
RS Ramya Sivakumar Syncfusion Team June 20, 2022 12:53 PM UTC

Hi Marco Buonaguidi,


Greetings from Syncfusion.


We are unable to reproduce the issue at our end. We have attached the sample which was tried at our end. Kindly share a sample illustrating the issue or else modify the following sample and reproduce the issue which would help us to proceed further.


Sample link - https://www.syncfusion.com/downloads/support/directtrac/general/ze/F-1757011465195400


And kindly confirm the Syncfusion XlsIO Package version which you are using at your end.


Regards,

Ramya.


Loader.
Up arrow icon