Support for newer Excel functions

Aspose.Cells Product Family
1

Hi There

Will you be introducing support for some of the more recent functions that Microsoft has introduced to Excel, including:

  • UNIQUE
  • SORT
  • SORTBY
  • SEQUENCE
  • XLOOKUP
  • LET
  • LAMBDA

Based on your documentation, it seems that these functions are not yet supported. Do you have a timeline for when these functions will be supported by your product?

Kind Regards

Adem

2

@solvexia,
We already have a feature request logged as “CELLSNET-47363” and the API already supports UNIQUE and SORT functions in latest version. We let you know once all of these functions are supported.

3

Hi,

Are you planning on supporting the LAMBDA function as well? If yes, any idea on the timeline?

I’m asking since the LAMBDA function is not mentioned in the forum post related to “CELLSNET-47363”.

Best regards,
Peter

4

@petersusteen,
Yes, supporting LAMBDA function is planned based on this forum thread. However, any timeline is not available yet. We will let you know once any update will be available.

5

@petersusteen, @solvexia,

Please note, Aspose.Cells now supports SORTBY, SEQUENCE and RANDARRAY functions. We will share the hotfix (upcoming) soon. However, for LAMBDA, it is complicated formula and we cannot support it in near future.

6

Hi,
Any plans for supporting XLOOKUP function?
Thanks

7

@eyalmolad,

Hopefully we will share our plans or ETA to support XLOOKUP formula/function in the next week.

8

@eyalmolad,
We will try to support XLOOKUP function in version 21.6. Hopefully it will be released around 3rd week of June.

9

@solvexia @petersusteen @eyalmolad

For functions such as XLOOKUP, LAMBDA, LET, MAP, SCAN… have been supported by our recent versions. Please try our latest version 24.7.

And here is the list of all supported functions for your refernece: Supported Excel Functions|Documentation (aspose.com)