We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Dynamic Array support

dear aspose.cells support,

Can you advise which Excel dynamic arrays function are implemented inside Aspose.cells ( for .NET ). Are they automaticlaly included whenever Micorosft releases a new function, or must this be explicately requested as an incident ?

Does Aspose.cells use the # operator, eg =MINVERSE(A1#) when A1 contains a dynamic array formula ?

kidn regards

guido

@gdebouver,

We enhance Aspose.Cells formula calculation engine with each new release of the product. If a formula is not supported in Aspose.Cells formula calculation engine, users can request with a test case and sample Excel file(s) and we evaluate it and support it as per our convenience.

Aspose.Cells follows Ms Excel standards and specifications. Does MS Excel support it? If so, Aspose.Cells will support it. Otherwise, it won’t use it.

Good aftrenoon/evening/….

Please find attached a zipped file containing

  • An excel file
  • The output file
  • The VB code

It seems Aspose.Cells does not support the # operator that was introduced with the dynamic arrays.

Thank you

guido

@gdebouver,
It seems you forgot to attach the zip file. Please attach the zip file here for our reference.