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 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.
Find attached an example usage of SUMIFS in cell A6.
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.
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
Cell result = worksheet.getCells().get(“A8”);