Excel Index Function

Aspose.Cells Product Family
1

Hi,

We have Apose.cells version 4.5.1 and we have detected an issue when we want to calculate a spreadsheet with excel index functions in it. Could you let me know whether this Aspose version allows that, please?

Kind Regards,

Ferran.

2

Hi,

Well, since you are using some older version of the product for which I am not sure if Index formula/function was supported in it or not. I think you may try to check Workbook.CaculateFormula or Cell.Formula in Aspose.Cells for .NET API Reference to get better know if your desired formula is listed there or not.

Moreover, in the later versions, we have made tremendous enhancements regarding Aspose.Cells formula engine, if you could use latest version(s) of the product e.g v5.2.2, almost all the formulas (including Index etc.) (that MS Excel 97-2010 support) are supported with a very few minor exceptions, see the document (the formulas that are not listed in the list are considered as “Supported”.
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/supported-formulas-functions.html

Thank you.

3

Hi Amjad,

First thank you for your quick answer. I did it, but the error message which is showed by Aspose is not quite clear for me: “Invalid formula in Control:G9 error in calculating cell v24 in worksheet Main”. Aspose doesn’t let you know whether the function is supported or not. Do you know if there is another way to check it? Thank you.

Regards,

4

Hi,

Well, since you are using old version for which i am not sure. Could you try with our latest version/fix i.e. Aspose.Cells for .NET 5.2.2.2.

If you still find the issue, kindly do post your template file here to show the issue, we will check it soon.

Thank you.

5

Hi Amjad,

First sorry for the delay, but I have been testing the latest Dll version on our spreadsheet. I want to be sure that the new aspose version works fine with our excel spreadsheets before ask to my company to update it.

The Dll works properly with index function, but when I have tried in our spreadsheet it showed the following error: "Unable to cast object of type ت.ہ to type System.Collections.ArrayList ". I am trying to reproduce the error in other spreadsheet in order to send you, but with no success at the moment.

I guess the Issue is caused because there are many chained formulas in the spreadsheet. Could you let me know more information about the error, please? Thank you.

Regards,

6

Hi,

Well, I am afraid, I have no clue for the issue. We need your simulation sample code plus template file(if you have) to evaluate the issue, so, that we might be able to figure it out soon.

Thank you.