Welcome to the ASP.NET Core feedback portal. We’re happy you’re here! If you have feedback on how to improve the ASP.NET Core, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Using structured references to tables in formulas return wrong values.

For example, using `MATCH` on `Countries[#Headers]` should return the index of string. In the example I attached it works. If I enable calculations on the sheet and do the same calculation with XlsIO, I get the wrong value.

Screenshot_2023-01-09_17-00-47.png

(Screenshot from Excel 365. Opening with XlsIO and enabled calculations gives wrong results.)

var sheet = (... omitted)
sheet.EnableSheetCalculations();
sheet["C10"].Formula = "=MATCH(\"Capital\", Countries[#Headers], 0)";
Console.WriteLine(sheet["C10"].DisplayText); //Prints "#N/A"


There is some support for the structured references: I can find `Countries` when looking at `workbook.Names`; if I set the formula to be just "=Countries[#Headers]" then I get a value; etc. But using it with array functions like MATCH or INDEX returns the wrong result when compared with Excel.

Thanks for your help,
Simon