Problems with array formulas

Aspose.Cells Product Family
1

Hi,

We have identified a problem when evaluating array formulaes.(Version of Aspose is Aspose.CellsV2.1.0.36)
In the attached spreadsheet there are some array formulas for the cells D21, D23, D24 and D25 in the sheet named Calcs.

Excel has the following values:

D21: 20
D23: 3
D24: 12
D25: 18

But when reading the values using Aspose we get:

D21: 20.0
D23: 3.0
D24: 10.0
D25: 10.0

The evaluation of D24 and D25 is wrong.

Sample code:

import java.io.FileInputStream;
import java.io.IOException;

import com.aspose.cells.AsposeLicenseException;
import com.aspose.cells.FileFormatType;
import com.aspose.cells.License;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

public class ArrayFormulae {

public static void main(String[] args) throws IOException, AsposeLicenseException {

License lic = new License();
lic.setLicense(new FileInputStream(“lib/Aspose.Cells.lic”));

Workbook workbook = new Workbook();

workbook.open(“Excel/ArrayFormulae.xls”);

Worksheet inputs = workbook.getWorksheets().getSheet(“Calcs”);

workbook.calculateFormula();

System.out.println("D21: "+inputs.getCells().getCell(“D21”).getValue());
System.out.println("D22: "+inputs.getCells().getCell(“D22”).getValue());
System.out.println("D23: "+inputs.getCells().getCell(“D23”).getValue());
System.out.println("D24: "+inputs.getCells().getCell(“D24”).getValue());
System.out.println("D25: "+inputs.getCells().getCell(“D25”).getValue());

}

}

2

Hi,

Thanks for providing us the template file with sample code.

After an initial test, we found the issue as you described. Your issue has been logged into our issue tracking system with an issue id: CELLSJAVA-11697. We will figure it out soon.

Thank you.

3

Hi,

Please try the attached version, we have fixed the issue.

Thank you.

4

It solves the problem - thank you

5

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

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