Free Support Forum - aspose.com

Formula is not considering as Array Formula

Hey,

I am facing an issue where I am trying to get the Array Formulas from my sheet.
Where some of the cells are array formula though they are not consider as array formula.

I am attaching the screenshot that show some cells are in Array formula and Excel is providing them as array formula but aspose won’t.

I am also uploading that sample file too.

ArrayFormula.zip (232.6 KB)

@harshCIPL22,

Thanks for the template file and screenshot.

After an initial test, I am able to reproduce the issue as you mentioned by using the following sample code with your template file. I found some formulas in the cells are not considered as array formulas.
e.g
Sample code:

Workbook wb = new Workbook("e:\\test2\\ArrayFormula\\ArrayFormula.xlsm");
            Worksheet worksheet = wb.Worksheets["Cash Flow"];

            Cell cell1 = worksheet.Cells["AQ91"];

            Console.WriteLine(cell1.IsFormula + ":" + cell1.Formula);
            Console.WriteLine(cell1.IsArrayFormula); //False.

I have logged a ticket with an id “CELLSNET-47174” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

@harshCIPL22,
In fact the formula is table formula, so please check it by:

Cell.IsTableFormula

Thanks for your reply.

I checked it and I think though It is considering it in Table Formula but It should also consider it as It is a Array Formula too.
So It should come in both the property.
Cell.IsTableFormula and also in Cell.IsArrayFormula.

@harshCIPL22,
We will check and get back to you soon.

Is there any update regarding this issue?

@harshCIPL22,

There is no update on it. We will check if your requirements ("…consider it as an array formula too") can be supported.

Once we have an update on it, we will let you know.

@harshCIPL22,
Yes, it may also be taken as array formula. However we cannot make this change because it may break many existing functions. If you need to get array formulas including table formula, please check whether it is array formula or table formula.