1. Feedback
  2. Angular
  3. 23112

Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, 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

MATCH function doesn't work

Hi,

I'm facing some issues with MATCH function in spreadsheet component, please use following link(it is from your examples).

https://stackblitz.com/edit/angular-f1tn2u?file=main.ts

Now I've tried few ways how to use MATCH function, for example:

  1. Type Jeanette Pamplin in H3.
  2. In H4 use following function: =MATCH(H3, A2:A30)
  3. It gives us result = 24 which is not expected 
    Empty

Another question, how to reference cells from other sheets?

Regards,
Jacek