Support for Excel Dynamic Arrays

Aspose.Cells Product Family
1

Hi – Does the latest Aspose Cells support the new Dynamic Arrays related features in Excel 2020?

This includes functions

  • FILTER
  • UNIQUE
  • SORT
  • SORTBY
  • SEQUENCE
  • RANDARRAY

Thanks, WILL

1 Like
2

@wglass,
I am afraid Dynamc Array feature is not supported in the API. We have logged the issue as “CELLSNET-47363” in our database for investigations. Once, we will have some news for you, we will update you in this topic.

3

@wglass,
We would like to update you that SORT and FILTER functions have been supported in recent versions. For other functions, we will support them in future.

4

@wglass,
Please note that UNIQUE function has been supported from 21.3 version. We will support other functions and will let you know soon.

5

@wglass,

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.