SUMIFS Support

Aspose.Cells Product Family
1

Hi,

We are evaluating Aspose.Cells for Java. We have quite a few circular references and usage of the excel SUMIFS function. Is this function supported? If not what are your plans for supporting SUMFS

Thanks,

:Ravi

2

Hi,

Thanks for your posting and considering Aspose.Cells for Java.

Please refer to this article for your reference.


It seems, this function is not supported.

However, please provide us a source xls/xlsx file with sumifs formula. You can create one manually using Ms-Excel.

We will look into it and update you asap.

3

Hi,

Find attached an example usage of SUMIFS in cell A6.

Thanks,

:Ravi

4

Hi,

My further investigation revealed that this function is supported. Please download the input file used in this code.

Please download and use the latest version:

Aspose.Cells for Java 7.1.1


If you put 5 in A2, then you should get 9 in A8 after the calculateFormula()

It gives the expected output, which is 9.

Java


String filePath = “F:\Source_SUMIFS_Example.xlsx”;


Workbook workbook = new Workbook(filePath);

Worksheet worksheet = workbook.getWorksheets().get(0);


Cell cell = worksheet.getCells().get(“A2”);


cell.putValue(5); //if you put 5 in A2 here, then you should get 9 in A8


workbook.calculateFormula();


Cell result = worksheet.getCells().get(“A8”);


System.out.println(result.getStringValue());