CalculateFormula doesn't work when using INDIRECT WITH COUNTA

Aspose.Cells Product Family
1

I am unable to get the value of a COUNTA formula which references an INDIRECT range. The below code puts should place a 3 value in cell (4,1). The attached workbook shows a 0 value. My Aspose.Cells.NET version is 5.2.1.0.

Dim datLIC As New Aspose.Cells.License : datLIC.SetLicense(New System.IO.StreamReader("C:\Test\Aspose.Cells.lic").BaseStream)

Dim BOOK As New Aspose.Cells.Workbook

Dim SHEET As Aspose.Cells.Worksheet = BOOK.Worksheets.Item(1)

SHEET.Cells(2, 2).PutValue("COUNT", True)

SHEET.Cells(2, 3).PutValue("ME", True)

SHEET.Cells(2, 4).PutValue("TOO", True)

SHEET.Cells(3, 1).Formula = "=COUNTA(INDIRECT(""A2:IV2""))"

BOOK.CalculateFormula()

SHEET.Cells(4, 1).PutValue(SHEET.Cells(3, 1).Value, True)

BOOK.Save("C:\Test\A.xls")

2

Hi,

After an initial test using your code snippet, I can find the issue as you have mentioned. I have logged your issue into our issue tracking system with an id: CELLSNET-23711. Once we figure it out, we will let you know here.

Thank you.

3

Hi tstone,

We have fixed this issue. Please download theAspose.Cells for .NET (Latest Version).

4

It works now. Thank you.

5

The issues you have found earlier (filed as 23711) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.